/// <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);
}
}
