16,472
社区成员
发帖
与我相关
我的任务
分享
void CStore::sql_Delete()
{
// 建立数据连接
AccADOConn m_AdoConn;
m_AdoConn.OnInitDBConnect();
// 设置SQL语句
CString sprice,scount;
sprice.Format("%f",_price);
scount.Format("%d",_count);
_bstr_t vSql;
vSql = "UPDATE Store SET Store.Tag = 1 WHERE Type = '" + _type + "' ";
vSql = vSql + "AND Brand = '" + _brand + "' ";
vSql = vSql + "AND LotNo = '" + _lotno + "' ";
vSql = vSql + "AND Pack = '" + _pack + "' ";
vSql = vSql + "AND Price = " + sprice + " ";
vSql = vSql + "AND Count_i = " + scount + " ";
vSql = vSql + "AND Provider = '" + _provider + "' ";
vSql = vSql + "AND Input_Date = '" + _date + "' ";
TRACE( vSql );
// 执行SQL语句
m_AdoConn.ExecuteSQL( vSql );
// 断开数据连接
m_AdoConn.ExitConnect();
}