/// <summary> /// 更新一条数据 /// </summary> public bool Updates(FMS_Model.shop_invoices_among_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_invoices_among_goods set "); strSql.Append("goods_old_num=@goods_old_num,"); strSql.Append("goods_num=@goods_num,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("total_money=@total_money,"); strSql.Append("update_time=@update_time"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@goods_old_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 16), new MySqlParameter("@total_money", MySqlDbType.Decimal, 16), new MySqlParameter("@update_time", MySqlDbType.VarChar, 32), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.goods_old_num; parameters[1].Value = model.goods_num; parameters[2].Value = model.goods_price; parameters[3].Value = model.total_money; parameters[4].Value = model.update_time; parameters[5].Value = model.id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FMS_Model.shop_invoices_among_goods GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,target_id,instorage_goods_cat_id,ype,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 from shop_invoices_among_goods"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = id; FMS_Model.shop_invoices_among_goods model = new FMS_Model.shop_invoices_among_goods(); DataSet ds = Shop_DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_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 Update(FMS_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); } }