/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.wms_voucher GetModel(long voucher_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select voucher_id,emp_code,emp_name,voucher_date,order_date,voucher_no,voucher_type,voucher_name,pay_type,pay_name,suppliers_erp_code,suppliers_name,order_sn,pay_money,pay_surplus,sup_money,sup_surplus,inv_money,inv_surplus,need_inv,need_surplus,adjust_money,adjust_surplus,period_money,period_inv,remark,is_del,red_rush,push_erp,push_kingdee,push_finish,day_send from wms_voucher ");
strSql.Append(" where voucher_id=@voucher_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@voucher_id", MySqlDbType.Int64, 20)
};
parameters[0].Value = voucher_id;
FMS_Model.wms_voucher model = new FMS_Model.wms_voucher();
DataSet ds = Wms_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.wms_voucher model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wms_voucher(");
strSql.Append("voucher_id,emp_code,emp_name,voucher_date,order_date,voucher_no,voucher_type,voucher_name,pay_type,pay_name,suppliers_erp_code,suppliers_name,order_sn,pay_money,pay_surplus,sup_money,sup_surplus,inv_money,inv_surplus,need_inv,need_surplus,adjust_money,adjust_surplus,period_money,period_inv,remark,is_del,red_rush,push_erp,push_kingdee,push_finish,day_send)");
strSql.Append(" values (");
strSql.Append("@voucher_id,@emp_code,@emp_name,@voucher_date,@order_date,@voucher_no,@voucher_type,@voucher_name,@pay_type,@pay_name,@suppliers_erp_code,@suppliers_name,@order_sn,@pay_money,@pay_surplus,@sup_money,@sup_surplus,@inv_money,@inv_surplus,@need_inv,@need_surplus,@adjust_money,@adjust_surplus,@period_money,@period_inv,@remark,@is_del,@red_rush,@push_erp,@push_kingdee,@push_finish,@day_send)");
MySqlParameter[] parameters =
{
new MySqlParameter("@voucher_id", MySqlDbType.Int64, 20),
new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@voucher_date", MySqlDbType.DateTime),
new MySqlParameter("@order_date", MySqlDbType.DateTime),
new MySqlParameter("@voucher_no", MySqlDbType.VarChar, 30),
new MySqlParameter("@voucher_type", MySqlDbType.Int16, 2),
new MySqlParameter("@voucher_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_type", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_name", MySqlDbType.VarChar, 100),
new MySqlParameter("@suppliers_erp_code", MySqlDbType.VarChar, 50),
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@order_sn", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@pay_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@sup_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@sup_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@inv_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@inv_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@need_inv", MySqlDbType.Decimal, 15),
new MySqlParameter("@need_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@adjust_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@adjust_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@period_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@period_inv", MySqlDbType.Decimal, 15),
new MySqlParameter("@remark", MySqlDbType.VarChar, 200),
new MySqlParameter("@is_del", MySqlDbType.Int16, 2),
new MySqlParameter("@red_rush", MySqlDbType.Int16, 2),
new MySqlParameter("@push_erp", MySqlDbType.Int16, 2),
new MySqlParameter("@push_kingdee", MySqlDbType.Int16, 2),
new MySqlParameter("@push_finish", MySqlDbType.Int16, 2),
new MySqlParameter("@day_send", MySqlDbType.Int16, 2)
};
parameters[0].Value = model.voucher_id;
parameters[1].Value = model.emp_code;
parameters[2].Value = model.emp_name;
parameters[3].Value = model.voucher_date;
parameters[4].Value = model.order_date;
parameters[5].Value = model.voucher_no;
parameters[6].Value = model.voucher_type;
parameters[7].Value = model.voucher_name;
parameters[8].Value = model.pay_type;
parameters[9].Value = model.pay_name;
parameters[10].Value = model.suppliers_erp_code;
parameters[11].Value = model.suppliers_name;
parameters[12].Value = model.order_sn;
parameters[13].Value = model.pay_money;
parameters[14].Value = model.pay_surplus;
parameters[15].Value = model.sup_money;
parameters[16].Value = model.sup_surplus;
parameters[17].Value = model.inv_money;
parameters[18].Value = model.inv_surplus;
parameters[19].Value = model.need_inv;
parameters[20].Value = model.need_surplus;
parameters[21].Value = model.adjust_money;
parameters[22].Value = model.adjust_surplus;
parameters[23].Value = model.period_money;
parameters[24].Value = model.period_inv;
parameters[25].Value = model.remark;
parameters[26].Value = model.is_del;
parameters[27].Value = model.red_rush;
parameters[28].Value = model.push_erp;
parameters[29].Value = model.push_kingdee;
parameters[30].Value = model.push_finish;
parameters[31].Value = model.day_send;
int rows = Wms_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.wms_voucher DataRowToModel(DataRow row)
{
FMS_Model.wms_voucher model = new FMS_Model.wms_voucher();
if (row != null)
{
if (row["voucher_id"] != null && row["voucher_id"].ToString() != "")
{
model.voucher_id = long.Parse(row["voucher_id"].ToString());
}
if (row["emp_code"] != null)
{
model.emp_code = row["emp_code"].ToString();
}
if (row["emp_name"] != null)
{
model.emp_name = row["emp_name"].ToString();
}
if (row["voucher_date"] != null && row["voucher_date"].ToString() != "")
{
model.voucher_date = DateTime.Parse(row["voucher_date"].ToString());
}
if (row["order_date"] != null && row["order_date"].ToString() != "")
{
model.order_date = DateTime.Parse(row["order_date"].ToString());
}
if (row["voucher_no"] != null)
{
model.voucher_no = row["voucher_no"].ToString();
}
if (row["voucher_type"] != null && row["voucher_type"].ToString() != "")
{
model.voucher_type = int.Parse(row["voucher_type"].ToString());
}
if (row["voucher_name"] != null)
{
model.voucher_name = row["voucher_name"].ToString();
}
if (row["pay_type"] != null)
{
model.pay_type = row["pay_type"].ToString();
}
if (row["pay_name"] != null)
{
model.pay_name = row["pay_name"].ToString();
}
if (row["suppliers_erp_code"] != null)
{
model.suppliers_erp_code = row["suppliers_erp_code"].ToString();
}
if (row["suppliers_name"] != null)
{
model.suppliers_name = row["suppliers_name"].ToString();
}
if (row["order_sn"] != null)
{
model.order_sn = row["order_sn"].ToString();
}
if (row["pay_money"] != null && row["pay_money"].ToString() != "")
{
model.pay_money = decimal.Parse(row["pay_money"].ToString());
}
if (row["pay_surplus"] != null && row["pay_surplus"].ToString() != "")
{
model.pay_surplus = decimal.Parse(row["pay_surplus"].ToString());
}
if (row["sup_money"] != null && row["sup_money"].ToString() != "")
{
model.sup_money = decimal.Parse(row["sup_money"].ToString());
}
if (row["sup_surplus"] != null && row["sup_surplus"].ToString() != "")
{
model.sup_surplus = decimal.Parse(row["sup_surplus"].ToString());
}
if (row["inv_money"] != null && row["inv_money"].ToString() != "")
{
model.inv_money = decimal.Parse(row["inv_money"].ToString());
}
if (row["inv_surplus"] != null && row["inv_surplus"].ToString() != "")
{
model.inv_surplus = decimal.Parse(row["inv_surplus"].ToString());
}
if (row["need_inv"] != null && row["need_inv"].ToString() != "")
{
model.need_inv = decimal.Parse(row["need_inv"].ToString());
}
if (row["need_surplus"] != null && row["need_surplus"].ToString() != "")
{
model.need_surplus = decimal.Parse(row["need_surplus"].ToString());
}
if (row["adjust_money"] != null && row["adjust_money"].ToString() != "")
{
model.adjust_money = decimal.Parse(row["adjust_money"].ToString());
}
if (row["adjust_surplus"] != null && row["adjust_surplus"].ToString() != "")
{
model.adjust_surplus = decimal.Parse(row["adjust_surplus"].ToString());
}
if (row["period_money"] != null && row["period_money"].ToString() != "")
{
model.period_money = decimal.Parse(row["period_money"].ToString());
}
if (row["period_inv"] != null && row["period_inv"].ToString() != "")
{
model.period_inv = decimal.Parse(row["period_inv"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["is_del"] != null && row["is_del"].ToString() != "")
{
model.is_del = int.Parse(row["is_del"].ToString());
}
if (row["red_rush"] != null && row["red_rush"].ToString() != "")
{
model.red_rush = int.Parse(row["red_rush"].ToString());
}
if (row["push_erp"] != null && row["push_erp"].ToString() != "")
{
model.push_erp = int.Parse(row["push_erp"].ToString());
}
if (row["push_kingdee"] != null && row["push_kingdee"].ToString() != "")
{
model.push_kingdee = int.Parse(row["push_kingdee"].ToString());
}
if (row["push_finish"] != null && row["push_finish"].ToString() != "")
{
model.push_finish = int.Parse(row["push_finish"].ToString());
}
if (row["day_send"] != null && row["day_send"].ToString() != "")
{
model.day_send = int.Parse(row["day_send"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.wms_voucher model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wms_voucher set ");
strSql.Append("emp_code=@emp_code,");
strSql.Append("emp_name=@emp_name,");
strSql.Append("voucher_date=@voucher_date,");
strSql.Append("order_date=@order_date,");
strSql.Append("voucher_no=@voucher_no,");
strSql.Append("voucher_type=@voucher_type,");
strSql.Append("voucher_name=@voucher_name,");
strSql.Append("pay_type=@pay_type,");
strSql.Append("pay_name=@pay_name,");
strSql.Append("suppliers_erp_code=@suppliers_erp_code,");
strSql.Append("suppliers_name=@suppliers_name,");
strSql.Append("order_sn=@order_sn,");
strSql.Append("pay_money=@pay_money,");
strSql.Append("pay_surplus=@pay_surplus,");
strSql.Append("sup_money=@sup_money,");
strSql.Append("sup_surplus=@sup_surplus,");
strSql.Append("inv_money=@inv_money,");
strSql.Append("inv_surplus=@inv_surplus,");
strSql.Append("need_inv=@need_inv,");
strSql.Append("need_surplus=@need_surplus,");
strSql.Append("adjust_money=@adjust_money,");
strSql.Append("adjust_surplus=@adjust_surplus,");
strSql.Append("period_money=@period_money,");
strSql.Append("period_inv=@period_inv,");
strSql.Append("remark=@remark,");
strSql.Append("is_del=@is_del,");
strSql.Append("red_rush=@red_rush,");
strSql.Append("push_erp=@push_erp,");
strSql.Append("push_kingdee=@push_kingdee,");
strSql.Append("push_finish=@push_finish,");
strSql.Append("day_send=@day_send");
strSql.Append(" where voucher_id=@voucher_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@emp_code", MySqlDbType.VarChar, 20),
new MySqlParameter("@emp_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@voucher_date", MySqlDbType.DateTime),
new MySqlParameter("@order_date", MySqlDbType.DateTime),
new MySqlParameter("@voucher_no", MySqlDbType.VarChar, 30),
new MySqlParameter("@voucher_type", MySqlDbType.Int16, 2),
new MySqlParameter("@voucher_name", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_type", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_name", MySqlDbType.VarChar, 100),
new MySqlParameter("@suppliers_erp_code", MySqlDbType.VarChar, 50),
new MySqlParameter("@suppliers_name", MySqlDbType.VarChar, 200),
new MySqlParameter("@order_sn", MySqlDbType.VarChar, 50),
new MySqlParameter("@pay_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@pay_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@sup_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@sup_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@inv_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@inv_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@need_inv", MySqlDbType.Decimal, 15),
new MySqlParameter("@need_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@adjust_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@adjust_surplus", MySqlDbType.Decimal, 20),
new MySqlParameter("@period_money", MySqlDbType.Decimal, 15),
new MySqlParameter("@period_inv", MySqlDbType.Decimal, 15),
new MySqlParameter("@remark", MySqlDbType.VarChar, 200),
new MySqlParameter("@is_del", MySqlDbType.Int16, 2),
new MySqlParameter("@red_rush", MySqlDbType.Int16, 2),
new MySqlParameter("@push_erp", MySqlDbType.Int16, 2),
new MySqlParameter("@push_kingdee", MySqlDbType.Int16, 2),
new MySqlParameter("@push_finish", MySqlDbType.Int16, 2),
new MySqlParameter("@day_send", MySqlDbType.Int16, 2),
new MySqlParameter("@voucher_id", MySqlDbType.Int64, 20)
};
parameters[0].Value = model.emp_code;
parameters[1].Value = model.emp_name;
parameters[2].Value = model.voucher_date;
parameters[3].Value = model.order_date;
parameters[4].Value = model.voucher_no;
parameters[5].Value = model.voucher_type;
parameters[6].Value = model.voucher_name;
parameters[7].Value = model.pay_type;
parameters[8].Value = model.pay_name;
parameters[9].Value = model.suppliers_erp_code;
parameters[10].Value = model.suppliers_name;
parameters[11].Value = model.order_sn;
parameters[12].Value = model.pay_money;
parameters[13].Value = model.pay_surplus;
parameters[14].Value = model.sup_money;
parameters[15].Value = model.sup_surplus;
parameters[16].Value = model.inv_money;
parameters[17].Value = model.inv_surplus;
parameters[18].Value = model.need_inv;
parameters[19].Value = model.need_surplus;
parameters[20].Value = model.adjust_money;
parameters[21].Value = model.adjust_surplus;
parameters[22].Value = model.period_money;
parameters[23].Value = model.period_inv;
parameters[24].Value = model.remark;
parameters[25].Value = model.is_del;
parameters[26].Value = model.red_rush;
parameters[27].Value = model.push_erp;
parameters[28].Value = model.push_kingdee;
parameters[29].Value = model.push_finish;
parameters[30].Value = model.day_send;
parameters[31].Value = model.voucher_id;
int rows = Wms_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.wms_voucher model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.wms_voucher model)
{
return(dal.Add(model));
}
