p.datamanage->GetRecordset()->RecordCount>0)
     {
     int currentrow = list.GetSelectionMark();//得到当前行
     if (currentrow !=-1)
     {
     CString sql,olddata;
     olddata = list.GetItemText(currentrow,0);
     sql.Format("delete tb_usestate where usestate = '%s'",olddata);
     try
     {
     theApp.datamanage->ExecSQL(sql);
     MessageBox("操作成功.","提示",64);
     }
     catch(...)
     {
     MessageBox("操作失败.","提示",64);
     }
     OnButtonrefresh() ;
     }
     else
     {
     MessageBox("请在表格中选择欲删除的数据.","提示",64);
     }
     }
     else
     MessageBox("当前没有可删除的记录.","提示");
    }
    
    void CUseState::OnButtonrefresh() 
    {
     kind.SetWindowText("");
     list.DeleteAllItems();
     theApp.datamanage->GetRecordset()->raw_Close();
     theApp.datamanage->GetRecordset()->Open("select usestate as 使用状况 from tb_usestate",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
     if (theApp.datamanage->GetRecordset()->RecordCount >0)
     {
     while (! theApp.datamanage->GetRecordset()->ADOEOF)
     {
     CString str;
     _variant_t temp;
     temp =theApp.datamanage->GetRecordset()->GetCollect((long)0);
     str = temp.bstrVal;
     list.InsertItem(0,str,0);
     theApp.datamanage->GetRecordset()->MoveNext();
     }
     }
    }
    void CUseState::OnButtonupdate() 
    {
     if (theApp.datamanage->GetRecordset()->RecordCount >0)
     {
     if(MessageBox("确实要修改当前数据吗?","提示",MB_YESNO)==IDYES )
     {
     CString str;
     kind.GetWindowText(str);
     if (str.IsEmpty()) //判断能力基础信息是否为空
     {
     MessageBox("基础信息不能为空","提示",64);
     }
     else if (!IsRepeated(str))
     {
     int currentrow = list.GetSelectionMark();//得到当前行
     if (currentrow!=-1)
     {
     try
     {
     CString sql,olddata;
     olddata = list.GetItemText(currentrow,0);
     sql.Format("update tb_usestate set usestate = '%s' where usestate = '%s'",str,olddata);
     theApp.datamanage->ExecSQL(sql);
     MessageBox("操作成功.","提示",64);
     kind.SetWindowText("");
     kind.SetFocus();
     }
     catch(...)
     {
     MessageBox("操作失败.","提示",64);
     }
     OnButtonrefresh() ;
     }
     else
     {
     MessageBox("当前没有可修改的数据.","提示",64);
     }
     }
     else
     MessageBox("该类别已经存在.","提示",64);
     }
     }
     else
     MessageBox("当前没有可修改的数据.","提示",64);
    }