sql CString 转int 问题 

 1 void LendAddEq::OnSureAddLend()
 2 {
 3     // TODO:  在此添加控件通知处理程序代码
 4     CString id, e_name,p_name,l_date,r_date;
 5 
 6     lend_flag = "lending";
 7 
 8     BOOL In = FALSE;
 9 
10     CString sum_count;
11     CString c_name;
12     int count=0;
13 
14     CString q;
15     
16 
17 
18     GetDlgItemText(IDC_EDIT1, id);
19     GetDlgItemText(IDC_EDIT2, e_name);
20     GetDlgItemText(IDC_EDIT4, p_name);
21     GetDlgItemText(IDC_EDIT5, l_date);
22     GetDlgItemText(IDC_EDIT6, r_date);
23 
24     rs.Open(CRecordset::forwardOnly, _T("SELECT * FROM equipment_table order by id Desc"));
25     while (!rs.IsEOF())
26     {
27         
28         rs.GetFieldValue(L"equipment_name", c_name);
29         //AfxMessageBox(c_name);
30         if (c_name == e_name)
31         {
32             //if ()借走数量
33             rs.GetFieldValue(L"sum_count", sum_count);
34             AfxMessageBox(sum_count);
35             count = _ttoi(sum_count);
36             //AfxMessageBox(count);
37             if (count - 1 > 0)
38             {
39                 In = TRUE;
40                 count =count - 1;
41                 q.Format(L"%d", count);
42                 AfxMessageBox(q);
43                 break;
44             }
45             
46         }
47         rs.MoveNext();
48     }
49     rs.Close();
50     if (In)
51     {
52         CString sql1;
53         sql1.Format(L"update equipment_table set count='%d' where equipment_name='%s'", count, c_name);
54         db.ExecuteSQL(sql1);
55 
56         CString sql;
57         sql.Format(_T("insert into lend_table (id, eq_name,people_name,flag,lend_date,return_date) values ('%s','%s','%s','%s','%s','%s')"), id, e_name, p_name, lend_flag, l_date, r_date);
58         db.ExecuteSQL(sql);
59 
60         AfxMessageBox(L"添加成功");
61         EndDialog(true);
62     }
63     else
64     {
65         MessageBox(L"实验室没有该设备！");
66     }
67 }

rs.GetFieldValue(L"sum_count", sum_count);    //读取数据
//AfxMessageBox(sum_count);
count = _ttoi(sum_count);       //CString转换int
//AfxMessageBox(count);     

q.Format(L"%d", count);   //int再转为CString 

终于解决了我更新数据库的问题

 

posted @ 2014-09-18 11:37  尽子轨  阅读(348)  评论(0)  编辑  收藏  举报