1、选择语句
string str_sql = "select distinct pt_id,pt_time,m_name,pt_phone from putin where pt_time >='" + P_time_from + "' and pt_time <='" + P_time_to + "' ";
BindingSource bs = dataCon.getBindingSource(str_sql, "putin"); // 使用BindingSource数据源绑定
2、插入语句
sqlStr = "insert into purchase(p_id,l_id,p_producer,p_provider,p_name,p_phone,p_deadline,p_num,p_price,p_time,p_info,p_sign ) values('" + p_id + "','" + l_id + "','" + p_producer + "','" + p_provider + "','" + p_name + "','" + p_phone + "','" + p_deadline + "','" + p_num + "','" + p_price + "','" + p_time + "','" + p_info + "' ," + p_sign + " )";
datacon.getcom(sqlStr);
3、修改语句
string str_sql = "update purchase set p_producer = '" + p_producer + "' , p_provider ='" + p_provider + "' , p_name = '" + p_name + "' , p_phone ='" + p_phone + "' , p_deadline = '" + product_time + "' , p_num = " + p_num + " , p_price = '" + p_price + "' , p_info = '" + p_info + "' where l_id ='" + l_id + "' and p_id ='" + MyClass.Field.p_id + "' ";
dataCon.getcom(str_sql);
4、删除语句
string str_sql = "delete from purchase where p_id = '" + p_id + "'";
dataCon.getcom(str_sql);
5、绑定语句
dataOperate.cboxBind("select distinct l_id from library ", "library", "l_id", cboxId);