/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.shop_points_order_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_points_order_goods set "); strSql.Append("cart_id=@cart_id,"); strSql.Append("order_id=@order_id,"); strSql.Append("goods_id=@goods_id,"); strSql.Append("goods_name=@goods_name,"); strSql.Append("goods_sn=@goods_sn,"); strSql.Append("goods_number=@goods_number,"); strSql.Append("market_price=@market_price,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("shipping_fee_price=@shipping_fee_price,"); strSql.Append("user_id=@user_id,"); strSql.Append("admin_id=@admin_id,"); strSql.Append("purchase_goods_status=@purchase_goods_status,"); strSql.Append("is_submit_purchase=@is_submit_purchase,"); strSql.Append("stock_warn=@stock_warn,"); strSql.Append("is_invoce=@is_invoce,"); strSql.Append("is_add_order=@is_add_order,"); strSql.Append("doc_id=@doc_id,"); strSql.Append("wms_setbook_id=@wms_setbook_id,"); strSql.Append("wms_position=@wms_position,"); strSql.Append("wms_record=@wms_record,"); strSql.Append("goods_integral_price=@goods_integral_price"); strSql.Append(" where ordergood_id=@ordergood_id "); MySqlParameter[] parameters = { new MySqlParameter("@cart_id", MySqlDbType.Int16, 8), new MySqlParameter("@order_id", MySqlDbType.Int16, 8), new MySqlParameter("@goods_id", MySqlDbType.Int16, 8), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 120), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 60), new MySqlParameter("@goods_number", MySqlDbType.Int32, 10), new MySqlParameter("@market_price", MySqlDbType.Decimal, 10), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 10), new MySqlParameter("@shipping_fee_price", MySqlDbType.Decimal, 10), new MySqlParameter("@user_id", MySqlDbType.Int32, 10), new MySqlParameter("@admin_id", MySqlDbType.Int32, 10), new MySqlParameter("@purchase_goods_status", MySqlDbType.Int16, 2), new MySqlParameter("@is_submit_purchase", MySqlDbType.Int16, 2), new MySqlParameter("@stock_warn", MySqlDbType.Int16, 1), new MySqlParameter("@is_invoce", MySqlDbType.Int16, 3), new MySqlParameter("@is_add_order", MySqlDbType.Int16, 2), new MySqlParameter("@doc_id", MySqlDbType.Decimal, 18), new MySqlParameter("@wms_setbook_id", MySqlDbType.Int16, 3), new MySqlParameter("@wms_position", MySqlDbType.VarChar, 50), new MySqlParameter("@wms_record", MySqlDbType.Int32, 10), new MySqlParameter("@goods_integral_price", MySqlDbType.Decimal, 10), new MySqlParameter("@ordergood_id", MySqlDbType.Int16, 8) }; parameters[0].Value = model.cart_id; parameters[1].Value = model.order_id; parameters[2].Value = model.goods_id; parameters[3].Value = model.goods_name; parameters[4].Value = model.goods_sn; parameters[5].Value = model.goods_number; parameters[6].Value = model.market_price; parameters[7].Value = model.goods_price; parameters[8].Value = model.shipping_fee_price; parameters[9].Value = model.user_id; parameters[10].Value = model.admin_id; parameters[11].Value = model.purchase_goods_status; parameters[12].Value = model.is_submit_purchase; parameters[13].Value = model.stock_warn; parameters[14].Value = model.is_invoce; parameters[15].Value = model.is_add_order; parameters[16].Value = model.doc_id; parameters[17].Value = model.wms_setbook_id; parameters[18].Value = model.wms_position; parameters[19].Value = model.wms_record; parameters[20].Value = model.goods_integral_price; parameters[21].Value = model.ordergood_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.shop_invoices_among_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_invoices_among_goods set "); strSql.Append("target_id=@target_id,"); strSql.Append("instorage_goods_cat_id=@instorage_goods_cat_id,"); strSql.Append("type=@type,"); strSql.Append("goods_sn=@goods_sn,"); strSql.Append("goods_name=@goods_name,"); strSql.Append("goods_packing=@goods_packing,"); strSql.Append("goods_unit=@goods_unit,"); strSql.Append("goods_num=@goods_num,"); strSql.Append("goods_sold_price=@goods_sold_price,"); strSql.Append("goods_sold_num=@goods_sold_num,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("total_money=@total_money,"); strSql.Append("tax_rate=@tax_rate,"); strSql.Append("update_time=@update_time,"); strSql.Append("add_time=@add_time,"); strSql.Append("rec_id=@rec_id,"); strSql.Append("order_id=@order_id,"); strSql.Append("t_is_shipping_fee=@t_is_shipping_fee,"); strSql.Append("is_replace=@is_replace,"); strSql.Append("is_hidden=@is_hidden,"); strSql.Append("goods_old_price=@goods_old_price,"); strSql.Append("goods_old_num=@goods_old_num,"); strSql.Append("goods_id=@goods_id"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@target_id", MySqlDbType.Int32, 11), new MySqlParameter("@instorage_goods_cat_id", MySqlDbType.Int32, 11), new MySqlParameter("@type", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 60), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_packing", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sold_price", MySqlDbType.Decimal, 12), new MySqlParameter("@goods_sold_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 16), new MySqlParameter("@total_money", MySqlDbType.Decimal, 16), new MySqlParameter("@tax_rate", MySqlDbType.Int32, 3), new MySqlParameter("@update_time", MySqlDbType.VarChar, 32), new MySqlParameter("@add_time", MySqlDbType.VarChar, 32), new MySqlParameter("@rec_id", MySqlDbType.Int32, 11), new MySqlParameter("@order_id", MySqlDbType.Int32, 11), new MySqlParameter("@t_is_shipping_fee", MySqlDbType.Decimal, 10), new MySqlParameter("@is_replace", MySqlDbType.Int16, 2), new MySqlParameter("@is_hidden", MySqlDbType.Int16, 2), new MySqlParameter("@goods_old_price", MySqlDbType.Decimal, 16), new MySqlParameter("@goods_old_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.target_id; parameters[1].Value = model.instorage_goods_cat_id; parameters[2].Value = model.type; parameters[3].Value = model.goods_sn; parameters[4].Value = model.goods_name; parameters[5].Value = model.goods_packing; parameters[6].Value = model.goods_unit; parameters[7].Value = model.goods_num; parameters[8].Value = model.goods_sold_price; parameters[9].Value = model.goods_sold_num; parameters[10].Value = model.goods_price; parameters[11].Value = model.total_money; parameters[12].Value = model.tax_rate; parameters[13].Value = model.update_time; parameters[14].Value = model.add_time; parameters[15].Value = model.rec_id; parameters[16].Value = model.order_id; parameters[17].Value = model.t_is_shipping_fee; parameters[18].Value = model.is_replace; parameters[19].Value = model.is_hidden; parameters[20].Value = model.goods_old_price; parameters[21].Value = model.goods_old_num; parameters[22].Value = model.goods_id; parameters[23].Value = model.id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.shop_invoices_among_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into shop_invoices_among_goods("); strSql.Append("id,target_id,instorage_goods_cat_id,type,goods_sn,goods_name,goods_packing,goods_unit,goods_num,goods_sold_price,goods_sold_num,goods_price,total_money,tax_rate,update_time,add_time,rec_id,order_id,t_is_shipping_fee,is_replace,is_hidden,goods_old_price,goods_old_num,goods_id)"); strSql.Append(" values ("); strSql.Append("@id,@target_id,@instorage_goods_cat_id,@type,@goods_sn,@goods_name,@goods_packing,@goods_unit,@goods_num,@goods_sold_price,@goods_sold_num,@goods_price,@total_money,@tax_rate,@update_time,@add_time,@rec_id,@order_id,@t_is_shipping_fee,@is_replace,@is_hidden,@goods_old_price,@goods_old_num,@goods_id)"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@target_id", MySqlDbType.Int32, 11), new MySqlParameter("@instorage_goods_cat_id", MySqlDbType.Int32, 11), new MySqlParameter("@type", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 60), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_packing", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 128), new MySqlParameter("@goods_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sold_price", MySqlDbType.Decimal, 12), new MySqlParameter("@goods_sold_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 16), new MySqlParameter("@total_money", MySqlDbType.Decimal, 16), new MySqlParameter("@tax_rate", MySqlDbType.Int32, 3), new MySqlParameter("@update_time", MySqlDbType.VarChar, 32), new MySqlParameter("@add_time", MySqlDbType.VarChar, 32), new MySqlParameter("@rec_id", MySqlDbType.Int32, 11), new MySqlParameter("@order_id", MySqlDbType.Int32, 11), new MySqlParameter("@t_is_shipping_fee", MySqlDbType.Decimal, 10), new MySqlParameter("@is_replace", MySqlDbType.Int16, 2), new MySqlParameter("@is_hidden", MySqlDbType.Int16, 2), new MySqlParameter("@goods_old_price", MySqlDbType.Decimal, 16), new MySqlParameter("@goods_old_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.id; parameters[1].Value = model.target_id; parameters[2].Value = model.instorage_goods_cat_id; parameters[3].Value = model.type; parameters[4].Value = model.goods_sn; parameters[5].Value = model.goods_name; parameters[6].Value = model.goods_packing; parameters[7].Value = model.goods_unit; parameters[8].Value = model.goods_num; parameters[9].Value = model.goods_sold_price; parameters[10].Value = model.goods_sold_num; parameters[11].Value = model.goods_price; parameters[12].Value = model.total_money; parameters[13].Value = model.tax_rate; parameters[14].Value = model.update_time; parameters[15].Value = model.add_time; parameters[16].Value = model.rec_id; parameters[17].Value = model.order_id; parameters[18].Value = model.t_is_shipping_fee; parameters[19].Value = model.is_replace; parameters[20].Value = model.is_hidden; parameters[21].Value = model.goods_old_price; parameters[22].Value = model.goods_old_num; parameters[23].Value = model.goods_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_Model.shop_return_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into shop_return_goods("); strSql.Append("sid,return_id,ck_admin_id,rec_id,goods_name,goods_id,goods_sn,goods_number,goods_price,order_price,goods_unit,note,return_goods_status,goods_reason,receive_num,allow_sale,noallow_sale,back_factory,allow_nosale,noallow,is_tax,order_id,erp_time,erp_code_as,erp_code_bf,erp_code_an,erp_code_n,is_invoice)"); strSql.Append(" values ("); strSql.Append("@sid,@return_id,@ck_admin_id,@rec_id,@goods_name,@goods_id,@goods_sn,@goods_number,@goods_price,@order_price,@goods_unit,@note,@return_goods_status,@goods_reason,@receive_num,@allow_sale,@noallow_sale,@back_factory,@allow_nosale,@noallow,@is_tax,@order_id,@erp_time,@erp_code_as,@erp_code_bf,@erp_code_an,@erp_code_n,@is_invoice)"); MySqlParameter[] parameters = { new MySqlParameter("@sid", MySqlDbType.Int32, 11), new MySqlParameter("@return_id", MySqlDbType.Int32, 10), new MySqlParameter("@ck_admin_id", MySqlDbType.Int32, 11), new MySqlParameter("@rec_id", MySqlDbType.Int32, 10), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 60), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 30), new MySqlParameter("@goods_number", MySqlDbType.Int32, 10), new MySqlParameter("@goods_price", MySqlDbType.Float, 10), new MySqlParameter("@order_price", MySqlDbType.Float, 10), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 10), new MySqlParameter("@note", MySqlDbType.VarChar, 255), new MySqlParameter("@return_goods_status", MySqlDbType.Int16, 2), new MySqlParameter("@goods_reason", MySqlDbType.VarChar, 255), new MySqlParameter("@receive_num", MySqlDbType.Int32, 6), new MySqlParameter("@allow_sale", MySqlDbType.Int32, 6), new MySqlParameter("@noallow_sale", MySqlDbType.Int32, 6), new MySqlParameter("@back_factory", MySqlDbType.Int32, 6), new MySqlParameter("@allow_nosale", MySqlDbType.Int32, 6), new MySqlParameter("@noallow", MySqlDbType.Int32, 6), new MySqlParameter("@is_tax", MySqlDbType.Int16, 2), new MySqlParameter("@order_id", MySqlDbType.Int32, 10), new MySqlParameter("@erp_time", MySqlDbType.Int32, 11), new MySqlParameter("@erp_code_as", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_bf", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_an", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_n", MySqlDbType.VarChar, 30), new MySqlParameter("@is_invoice", MySqlDbType.Int16, 2) }; parameters[0].Value = model.sid; parameters[1].Value = model.return_id; parameters[2].Value = model.ck_admin_id; parameters[3].Value = model.rec_id; parameters[4].Value = model.goods_name; parameters[5].Value = model.goods_id; parameters[6].Value = model.goods_sn; parameters[7].Value = model.goods_number; parameters[8].Value = model.goods_price; parameters[9].Value = model.order_price; parameters[10].Value = model.goods_unit; parameters[11].Value = model.note; parameters[12].Value = model.return_goods_status; parameters[13].Value = model.goods_reason; parameters[14].Value = model.receive_num; parameters[15].Value = model.allow_sale; parameters[16].Value = model.noallow_sale; parameters[17].Value = model.back_factory; parameters[18].Value = model.allow_nosale; parameters[19].Value = model.noallow; parameters[20].Value = model.is_tax; parameters[21].Value = model.order_id; parameters[22].Value = model.erp_time; parameters[23].Value = model.erp_code_as; parameters[24].Value = model.erp_code_bf; parameters[25].Value = model.erp_code_an; parameters[26].Value = model.erp_code_n; parameters[27].Value = model.is_invoice; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.shop_return_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_return_goods set "); strSql.Append("return_id=@return_id,"); strSql.Append("ck_admin_id=@ck_admin_id,"); strSql.Append("rec_id=@rec_id,"); strSql.Append("goods_name=@goods_name,"); strSql.Append("goods_id=@goods_id,"); strSql.Append("goods_sn=@goods_sn,"); strSql.Append("goods_number=@goods_number,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("order_price=@order_price,"); strSql.Append("goods_unit=@goods_unit,"); strSql.Append("note=@note,"); strSql.Append("return_goods_status=@return_goods_status,"); strSql.Append("goods_reason=@goods_reason,"); strSql.Append("receive_num=@receive_num,"); strSql.Append("allow_sale=@allow_sale,"); strSql.Append("noallow_sale=@noallow_sale,"); strSql.Append("back_factory=@back_factory,"); strSql.Append("allow_nosale=@allow_nosale,"); strSql.Append("noallow=@noallow,"); strSql.Append("is_tax=@is_tax,"); strSql.Append("order_id=@order_id,"); strSql.Append("erp_time=@erp_time,"); strSql.Append("erp_code_as=@erp_code_as,"); strSql.Append("erp_code_bf=@erp_code_bf,"); strSql.Append("erp_code_an=@erp_code_an,"); strSql.Append("erp_code_n=@erp_code_n,"); strSql.Append("is_invoice=@is_invoice"); strSql.Append(" where sid=@sid "); MySqlParameter[] parameters = { new MySqlParameter("@return_id", MySqlDbType.Int32, 10), new MySqlParameter("@ck_admin_id", MySqlDbType.Int32, 11), new MySqlParameter("@rec_id", MySqlDbType.Int32, 10), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 60), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 30), new MySqlParameter("@goods_number", MySqlDbType.Int32, 10), new MySqlParameter("@goods_price", MySqlDbType.Float, 10), new MySqlParameter("@order_price", MySqlDbType.Float, 10), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 10), new MySqlParameter("@note", MySqlDbType.VarChar, 255), new MySqlParameter("@return_goods_status", MySqlDbType.Int16, 2), new MySqlParameter("@goods_reason", MySqlDbType.VarChar, 255), new MySqlParameter("@receive_num", MySqlDbType.Int32, 6), new MySqlParameter("@allow_sale", MySqlDbType.Int32, 6), new MySqlParameter("@noallow_sale", MySqlDbType.Int32, 6), new MySqlParameter("@back_factory", MySqlDbType.Int32, 6), new MySqlParameter("@allow_nosale", MySqlDbType.Int32, 6), new MySqlParameter("@noallow", MySqlDbType.Int32, 6), new MySqlParameter("@is_tax", MySqlDbType.Int16, 2), new MySqlParameter("@order_id", MySqlDbType.Int32, 10), new MySqlParameter("@erp_time", MySqlDbType.Int32, 11), new MySqlParameter("@erp_code_as", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_bf", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_an", MySqlDbType.VarChar, 30), new MySqlParameter("@erp_code_n", MySqlDbType.VarChar, 30), new MySqlParameter("@is_invoice", MySqlDbType.Int16, 2), new MySqlParameter("@sid", MySqlDbType.Int32, 11) }; parameters[0].Value = model.return_id; parameters[1].Value = model.ck_admin_id; parameters[2].Value = model.rec_id; parameters[3].Value = model.goods_name; parameters[4].Value = model.goods_id; parameters[5].Value = model.goods_sn; parameters[6].Value = model.goods_number; parameters[7].Value = model.goods_price; parameters[8].Value = model.order_price; parameters[9].Value = model.goods_unit; parameters[10].Value = model.note; parameters[11].Value = model.return_goods_status; parameters[12].Value = model.goods_reason; parameters[13].Value = model.receive_num; parameters[14].Value = model.allow_sale; parameters[15].Value = model.noallow_sale; parameters[16].Value = model.back_factory; parameters[17].Value = model.allow_nosale; parameters[18].Value = model.noallow; parameters[19].Value = model.is_tax; parameters[20].Value = model.order_id; parameters[21].Value = model.erp_time; parameters[22].Value = model.erp_code_as; parameters[23].Value = model.erp_code_bf; parameters[24].Value = model.erp_code_an; parameters[25].Value = model.erp_code_n; parameters[26].Value = model.is_invoice; parameters[27].Value = model.sid; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.shop_user_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_user_address set "); strSql.Append("address_name=@address_name,"); strSql.Append("user_id=@user_id,"); strSql.Append("consignee=@consignee,"); strSql.Append("email=@email,"); strSql.Append("country=@country,"); strSql.Append("province=@province,"); strSql.Append("city=@city,"); strSql.Append("district=@district,"); strSql.Append("address=@address,"); strSql.Append("zipcode=@zipcode,"); strSql.Append("tel=@tel,"); strSql.Append("mobile=@mobile,"); strSql.Append("sign_building=@sign_building,"); strSql.Append("best_time=@best_time,"); strSql.Append("is_default=@is_default,"); strSql.Append("is_invoice=@is_invoice"); strSql.Append(" where address_id=@address_id "); MySqlParameter[] parameters = { new MySqlParameter("@address_name", MySqlDbType.VarChar, 50), new MySqlParameter("@user_id", MySqlDbType.Int32, 8), new MySqlParameter("@consignee", MySqlDbType.VarChar, 60), new MySqlParameter("@email", MySqlDbType.VarChar, 60), new MySqlParameter("@country", MySqlDbType.Int32, 5), new MySqlParameter("@province", MySqlDbType.Int32, 5), new MySqlParameter("@city", MySqlDbType.Int32, 5), new MySqlParameter("@district", MySqlDbType.Int32, 5), new MySqlParameter("@address", MySqlDbType.VarChar, 120), new MySqlParameter("@zipcode", MySqlDbType.VarChar, 60), new MySqlParameter("@tel", MySqlDbType.VarChar, 60), new MySqlParameter("@mobile", MySqlDbType.VarChar, 60), new MySqlParameter("@sign_building", MySqlDbType.VarChar, 120), new MySqlParameter("@best_time", MySqlDbType.VarChar, 120), new MySqlParameter("@is_default", MySqlDbType.Int32, 1), new MySqlParameter("@is_invoice", MySqlDbType.Int32, 1), new MySqlParameter("@address_id", MySqlDbType.Int32, 8) }; parameters[0].Value = model.address_name; parameters[1].Value = model.user_id; parameters[2].Value = model.consignee; parameters[3].Value = model.email; parameters[4].Value = model.country; parameters[5].Value = model.province; parameters[6].Value = model.city; parameters[7].Value = model.district; parameters[8].Value = model.address; parameters[9].Value = model.zipcode; parameters[10].Value = model.tel; parameters[11].Value = model.mobile; parameters[12].Value = model.sign_building; parameters[13].Value = model.best_time; parameters[14].Value = model.is_default; parameters[15].Value = model.is_invoice; parameters[16].Value = model.address_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Updates(FMS_Model.shop_invoices_among model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_invoices_among set "); strSql.Append("invoice_type=@invoice_type,"); strSql.Append("address=@address,"); strSql.Append("bank_number=@bank_number,"); strSql.Append("bank=@bank,"); strSql.Append("shuihao=@shuihao,"); strSql.Append("company_name=@company_name,"); strSql.Append("tax_rate=@tax_rate,"); strSql.Append("pay_note=@pay_note,"); strSql.Append("update_time=@update_time,"); strSql.Append("invoice_status=@invoice_status,"); strSql.Append("shipping_type=@shipping_type,"); strSql.Append("shipping_id=@shipping_id,"); strSql.Append("note=@note"); strSql.Append(" where invoice_id=@invoice_id "); MySqlParameter[] parameters = { new MySqlParameter("@invoice_type", MySqlDbType.Int16, 2), new MySqlParameter("@address", MySqlDbType.VarChar, 255), new MySqlParameter("@bank_number", MySqlDbType.VarChar, 30), new MySqlParameter("@bank", MySqlDbType.VarChar, 100), new MySqlParameter("@shuihao", MySqlDbType.VarChar, 50), new MySqlParameter("@company_name", MySqlDbType.VarChar, 100), new MySqlParameter("@tax_rate", MySqlDbType.Int16, 2), new MySqlParameter("@pay_note", MySqlDbType.VarChar, 255), new MySqlParameter("@update_time", MySqlDbType.Int32, 11), new MySqlParameter("@invoice_status", MySqlDbType.Int16, 3), new MySqlParameter("@shipping_type", MySqlDbType.Int16, 2), new MySqlParameter("@shipping_id", MySqlDbType.Int16, 3), new MySqlParameter("@note", MySqlDbType.Text), new MySqlParameter("@invoice_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.invoice_type; parameters[1].Value = model.address; parameters[2].Value = model.bank_number; parameters[3].Value = model.bank; parameters[4].Value = model.shuihao; parameters[5].Value = model.company_name; parameters[6].Value = model.tax_rate; parameters[7].Value = model.pay_note; parameters[8].Value = model.update_time; parameters[9].Value = model.invoice_status; parameters[10].Value = model.shipping_type; parameters[11].Value = model.shipping_id; parameters[12].Value = model.note; parameters[13].Value = model.invoice_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.shop_invoices_among model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_invoices_among set "); strSql.Append("invoice_sn=@invoice_sn,"); strSql.Append("invoice2_id=@invoice2_id,"); strSql.Append("invoice_type=@invoice_type,"); strSql.Append("tax_rate=@tax_rate,"); strSql.Append("currency=@currency,"); strSql.Append("exchange_rate=@exchange_rate,"); strSql.Append("down_count=@down_count,"); strSql.Append("admin_id=@admin_id,"); strSql.Append("user_id=@user_id,"); strSql.Append("address=@address,"); strSql.Append("bank_number=@bank_number,"); strSql.Append("bank=@bank,"); strSql.Append("shuihao=@shuihao,"); strSql.Append("company_name=@company_name,"); strSql.Append("tel=@tel,"); strSql.Append("total_count=@total_count,"); strSql.Append("total_money=@total_money,"); strSql.Append("note=@note,"); strSql.Append("invoices_note=@invoices_note,"); strSql.Append("pay_note=@pay_note,"); strSql.Append("add_time=@add_time,"); strSql.Append("update_time=@update_time,"); strSql.Append("invoice_status=@invoice_status,"); strSql.Append("pre_status=@pre_status,"); strSql.Append("invoice_time=@invoice_time,"); strSql.Append("erp_order_sn=@erp_order_sn,"); strSql.Append("invoice_num=@invoice_num,"); strSql.Append("invoice_date=@invoice_date,"); strSql.Append("refund_money=@refund_money,"); strSql.Append("refund_djhm_str=@refund_djhm_str,"); strSql.Append("sold_total_money=@sold_total_money,"); strSql.Append("shipping_num=@shipping_num,"); strSql.Append("shipping_time=@shipping_time,"); strSql.Append("shipping_type=@shipping_type,"); strSql.Append("shipping_id=@shipping_id,"); strSql.Append("print_num=@print_num,"); strSql.Append("invoice_sn_temp=@invoice_sn_temp,"); strSql.Append("invoice_num_temp=@invoice_num_temp,"); strSql.Append("last_update_admin=@last_update_admin,"); strSql.Append("init_refund_money=@init_refund_money,"); strSql.Append("print_hide=@print_hide"); strSql.Append(" where invoice_id=@invoice_id "); MySqlParameter[] parameters = { new MySqlParameter("@invoice_sn", MySqlDbType.VarChar, 32), new MySqlParameter("@invoice2_id", MySqlDbType.Int32, 11), new MySqlParameter("@invoice_type", MySqlDbType.Int16, 2), new MySqlParameter("@tax_rate", MySqlDbType.Int16, 2), new MySqlParameter("@currency", MySqlDbType.VarChar, 50), new MySqlParameter("@exchange_rate", MySqlDbType.Decimal, 10), new MySqlParameter("@down_count", MySqlDbType.Int32, 11), new MySqlParameter("@admin_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@address", MySqlDbType.VarChar, 255), new MySqlParameter("@bank_number", MySqlDbType.VarChar, 30), new MySqlParameter("@bank", MySqlDbType.VarChar, 100), new MySqlParameter("@shuihao", MySqlDbType.VarChar, 50), new MySqlParameter("@company_name", MySqlDbType.VarChar, 100), new MySqlParameter("@tel", MySqlDbType.VarChar, 50), new MySqlParameter("@total_count", MySqlDbType.Int32, 11), new MySqlParameter("@total_money", MySqlDbType.Decimal, 10), new MySqlParameter("@note", MySqlDbType.Text), new MySqlParameter("@invoices_note", MySqlDbType.VarChar, 255), new MySqlParameter("@pay_note", MySqlDbType.VarChar, 255), new MySqlParameter("@add_time", MySqlDbType.Int32, 11), new MySqlParameter("@update_time", MySqlDbType.Int32, 11), new MySqlParameter("@invoice_status", MySqlDbType.Int16, 3), new MySqlParameter("@pre_status", MySqlDbType.Int16, 3), new MySqlParameter("@invoice_time", MySqlDbType.Int32, 11), new MySqlParameter("@erp_order_sn", MySqlDbType.VarChar, 32), new MySqlParameter("@invoice_num", MySqlDbType.VarChar, 32), new MySqlParameter("@invoice_date", MySqlDbType.VarChar, 32), new MySqlParameter("@refund_money", MySqlDbType.Decimal, 10), new MySqlParameter("@refund_djhm_str", MySqlDbType.Text), new MySqlParameter("@sold_total_money", MySqlDbType.Decimal, 10), new MySqlParameter("@shipping_num", MySqlDbType.VarChar, 32), new MySqlParameter("@shipping_time", MySqlDbType.Int32, 11), new MySqlParameter("@shipping_type", MySqlDbType.Int16, 2), new MySqlParameter("@shipping_id", MySqlDbType.Int16, 3), new MySqlParameter("@print_num", MySqlDbType.Int32, 11), new MySqlParameter("@invoice_sn_temp", MySqlDbType.VarChar, 32), new MySqlParameter("@invoice_num_temp", MySqlDbType.Int32, 11), new MySqlParameter("@last_update_admin", MySqlDbType.VarChar, 255), new MySqlParameter("@init_refund_money", MySqlDbType.Decimal, 10), new MySqlParameter("@print_hide", MySqlDbType.Int16, 1), new MySqlParameter("@invoice_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.invoice_sn; parameters[1].Value = model.invoice2_id; parameters[2].Value = model.invoice_type; parameters[3].Value = model.tax_rate; parameters[4].Value = model.currency; parameters[5].Value = model.exchange_rate; parameters[6].Value = model.down_count; parameters[7].Value = model.admin_id; parameters[8].Value = model.user_id; parameters[9].Value = model.address; parameters[10].Value = model.bank_number; parameters[11].Value = model.bank; parameters[12].Value = model.shuihao; parameters[13].Value = model.company_name; parameters[14].Value = model.tel; parameters[15].Value = model.total_count; parameters[16].Value = model.total_money; parameters[17].Value = model.note; parameters[18].Value = model.invoices_note; parameters[19].Value = model.pay_note; parameters[20].Value = model.add_time; parameters[21].Value = model.update_time; parameters[22].Value = model.invoice_status; parameters[23].Value = model.pre_status; parameters[24].Value = model.invoice_time; parameters[25].Value = model.erp_order_sn; parameters[26].Value = model.invoice_num; parameters[27].Value = model.invoice_date; parameters[28].Value = model.refund_money; parameters[29].Value = model.refund_djhm_str; parameters[30].Value = model.sold_total_money; parameters[31].Value = model.shipping_num; parameters[32].Value = model.shipping_time; parameters[33].Value = model.shipping_type; parameters[34].Value = model.shipping_id; parameters[35].Value = model.print_num; parameters[36].Value = model.invoice_sn_temp; parameters[37].Value = model.invoice_num_temp; parameters[38].Value = model.last_update_admin; parameters[39].Value = model.init_refund_money; parameters[40].Value = model.print_hide; parameters[41].Value = model.invoice_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }