/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.shop_return_goods GetModel(int sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select 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 from shop_return_goods ");
strSql.Append(" where sid=@sid ");
MySqlParameter[] parameters =
{
new MySqlParameter("@sid", MySqlDbType.Int32, 11)
};
parameters[0].Value = sid;
FMS_Model.shop_return_goods model = new FMS_Model.shop_return_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 Update(FMS_Model.shop_return_goods model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.shop_return_goods model)
{
return(dal.Add(model));
}
/// <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 FMS_Model.shop_return_goods DataRowToModel(DataRow row)
{
FMS_Model.shop_return_goods model = new FMS_Model.shop_return_goods();
if (row != null)
{
if (row["sid"] != null && row["sid"].ToString() != "")
{
model.sid = int.Parse(row["sid"].ToString());
}
if (row["return_id"] != null && row["return_id"].ToString() != "")
{
model.return_id = int.Parse(row["return_id"].ToString());
}
if (row["ck_admin_id"] != null && row["ck_admin_id"].ToString() != "")
{
model.ck_admin_id = int.Parse(row["ck_admin_id"].ToString());
}
if (row["rec_id"] != null && row["rec_id"].ToString() != "")
{
model.rec_id = int.Parse(row["rec_id"].ToString());
}
if (row["goods_name"] != null)
{
model.goods_name = row["goods_name"].ToString();
}
if (row["goods_id"] != null && row["goods_id"].ToString() != "")
{
model.goods_id = int.Parse(row["goods_id"].ToString());
}
if (row["goods_sn"] != null)
{
model.goods_sn = row["goods_sn"].ToString();
}
if (row["goods_number"] != null && row["goods_number"].ToString() != "")
{
model.goods_number = int.Parse(row["goods_number"].ToString());
}
if (row["goods_price"] != null && row["goods_price"].ToString() != "")
{
model.goods_price = decimal.Parse(row["goods_price"].ToString());
}
if (row["order_price"] != null && row["order_price"].ToString() != "")
{
model.order_price = decimal.Parse(row["order_price"].ToString());
}
if (row["goods_unit"] != null)
{
model.goods_unit = row["goods_unit"].ToString();
}
if (row["note"] != null)
{
model.note = row["note"].ToString();
}
if (row["return_goods_status"] != null && row["return_goods_status"].ToString() != "")
{
model.return_goods_status = int.Parse(row["return_goods_status"].ToString());
}
if (row["goods_reason"] != null)
{
model.goods_reason = row["goods_reason"].ToString();
}
if (row["receive_num"] != null && row["receive_num"].ToString() != "")
{
model.receive_num = int.Parse(row["receive_num"].ToString());
}
if (row["allow_sale"] != null && row["allow_sale"].ToString() != "")
{
model.allow_sale = int.Parse(row["allow_sale"].ToString());
}
if (row["noallow_sale"] != null && row["noallow_sale"].ToString() != "")
{
model.noallow_sale = int.Parse(row["noallow_sale"].ToString());
}
if (row["back_factory"] != null && row["back_factory"].ToString() != "")
{
model.back_factory = int.Parse(row["back_factory"].ToString());
}
if (row["allow_nosale"] != null && row["allow_nosale"].ToString() != "")
{
model.allow_nosale = int.Parse(row["allow_nosale"].ToString());
}
if (row["noallow"] != null && row["noallow"].ToString() != "")
{
model.noallow = int.Parse(row["noallow"].ToString());
}
if (row["is_tax"] != null && row["is_tax"].ToString() != "")
{
model.is_tax = int.Parse(row["is_tax"].ToString());
}
if (row["order_id"] != null && row["order_id"].ToString() != "")
{
model.order_id = int.Parse(row["order_id"].ToString());
}
if (row["erp_time"] != null && row["erp_time"].ToString() != "")
{
model.erp_time = int.Parse(row["erp_time"].ToString());
}
if (row["erp_code_as"] != null)
{
model.erp_code_as = row["erp_code_as"].ToString();
}
if (row["erp_code_bf"] != null)
{
model.erp_code_bf = row["erp_code_bf"].ToString();
}
if (row["erp_code_an"] != null)
{
model.erp_code_an = row["erp_code_an"].ToString();
}
if (row["erp_code_n"] != null)
{
model.erp_code_n = row["erp_code_n"].ToString();
}
if (row["is_invoice"] != null && row["is_invoice"].ToString() != "")
{
model.is_invoice = int.Parse(row["is_invoice"].ToString());
}
}
return(model);
}
/// <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);
}
}
