/// <summary>
/// 更新一条数据
/// </summary>
public bool Updates(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 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;
Model.shop_invoices_among_goods model = new 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(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(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 updateBill(Model.shop_invoices_among_goods model)
{
return(dal.updateBill(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Updates(Model.shop_invoices_among_goods model)
{
return(dal.Updates(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.shop_invoices_among_goods model)
{
return(dal.Add(model));
}
