public int checkOrder_id(string order_id, string gongsi)
{
ms = new Order.Common.MySqlHelper(sqlStr);
string sql = "select orderid from yh_jinxiaocun_mingxi where orderid = '" + order_id + "' and gongsi = '" + gongsi + "'";
int result = ms.ExecuteSql(sql);
return(result);
}
public int insertMingxi(items item, string company, string name, string mxtype)
{
ms = new Order.Common.MySqlHelper(sqlStr);
string sql = "";
string date_now = DateTime.Now.ToString();
for (int i = 0; i < item.itemList.Count; i++)
{
sql += "insert into yh_jinxiaocun_mingxi(cplb,cpname,cpsj,cpsl,mxtype,orderid,shijian,sp_dm,shou_h,zh_name,gs_name) select lei_bie as cplb,`name` as cpname," + item.itemList[i].price + " as cpsj," + item.itemList[i].num + " as cpsl,'" + mxtype + "' as mxtype,'" + item.orderid + "' as orderid,'" + date_now + "' as shijian,sp_dm,'" + item.gonghuo + "' as shou_h,'" + company + "' as zh_name,'" + name + "' as gs_name from yh_jinxiaocun_jichuziliao where id = " + item.itemList[i].id + ";";
}
int result = ms.ExecuteSql(sql);
return(result);
}
