private void ShowInfo(int id)
{
Jium.BLL.product bll = new Jium.BLL.product();
Jium.Model.product model = bll.GetModel(id);
this.lblid.Text = model.id.ToString();
this.txtpcode.Text = model.pcode;
this.txtpname.Text = model.pname;
this.txtpsaleprice.Text = model.psaleprice.ToString();
this.txtprealprice.Text = model.prealprice.ToString();
this.txtptype.Text = model.ptype;
this.txtpisgroup.Text = model.pisgroup.ToString();
this.txtpdesc.Text = model.pdesc;
this.txtps1.Text = model.ps1;
this.txtps2.Text = model.ps2;
this.txtps3.Text = model.ps3;
this.txtps4.Text = model.ps4;
this.txtps5.Text = model.ps5;
this.txtpd1.Text = model.pd1.ToString();
this.txtpd2.Text = model.pd2.ToString();
this.txtpd3.Text = model.pd3.ToString();
this.txtpd4.Text = model.pd4.ToString();
this.txtpd5.Text = model.pd5.ToString();
this.txtpdc1.Text = model.pdc1.ToString();
this.txtpdc2.Text = model.pdc2.ToString();
this.txtpdc3.Text = model.pdc3.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.product GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,pcode,pname,psaleprice,prealprice,ptype,pisgroup,pdesc,ps1,ps2,ps3,ps4,ps5,pd1,pd2,pd3,pd4,pd5,pdc1,pdc2,pdc3 from product ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Jium.Model.product model = new Jium.Model.product();
DataSet ds = 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(Jium.Model.product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into product(");
strSql.Append("pcode,pname,psaleprice,prealprice,ptype,pisgroup,pdesc,ps1,ps2,ps3,ps4,ps5,pd1,pd2,pd3,pd4,pd5,pdc1,pdc2,pdc3)");
strSql.Append(" values (");
strSql.Append("@pcode,@pname,@psaleprice,@prealprice,@ptype,@pisgroup,@pdesc,@ps1,@ps2,@ps3,@ps4,@ps5,@pd1,@pd2,@pd3,@pd4,@pd5,@pdc1,@pdc2,@pdc3)");
MySqlParameter[] parameters =
{
new MySqlParameter("@pcode", MySqlDbType.VarChar, 20),
new MySqlParameter("@pname", MySqlDbType.VarChar, 50),
new MySqlParameter("@psaleprice", MySqlDbType.Decimal, 20),
new MySqlParameter("@prealprice", MySqlDbType.Decimal, 20),
new MySqlParameter("@ptype", MySqlDbType.VarChar, 20),
new MySqlParameter("@pisgroup", MySqlDbType.Int32, 11),
new MySqlParameter("@pdesc", MySqlDbType.VarChar, 200),
new MySqlParameter("@ps1", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps2", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps3", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps4", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps5", MySqlDbType.VarChar, 20),
new MySqlParameter("@pd1", MySqlDbType.Int32, 11),
new MySqlParameter("@pd2", MySqlDbType.Int32, 11),
new MySqlParameter("@pd3", MySqlDbType.Int32, 11),
new MySqlParameter("@pd4", MySqlDbType.Int32, 11),
new MySqlParameter("@pd5", MySqlDbType.Int32, 11),
new MySqlParameter("@pdc1", MySqlDbType.Decimal, 20),
new MySqlParameter("@pdc2", MySqlDbType.Decimal, 20),
new MySqlParameter("@pdc3", MySqlDbType.Decimal, 20)
};
parameters[0].Value = model.pcode;
parameters[1].Value = model.pname;
parameters[2].Value = model.psaleprice;
parameters[3].Value = model.prealprice;
parameters[4].Value = model.ptype;
parameters[5].Value = model.pisgroup;
parameters[6].Value = model.pdesc;
parameters[7].Value = model.ps1;
parameters[8].Value = model.ps2;
parameters[9].Value = model.ps3;
parameters[10].Value = model.ps4;
parameters[11].Value = model.ps5;
parameters[12].Value = model.pd1;
parameters[13].Value = model.pd2;
parameters[14].Value = model.pd3;
parameters[15].Value = model.pd4;
parameters[16].Value = model.pd5;
parameters[17].Value = model.pdc1;
parameters[18].Value = model.pdc2;
parameters[19].Value = model.pdc3;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Jium.Model.product DataRowToModel(DataRow row)
{
Jium.Model.product model = new Jium.Model.product();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["pcode"] != null)
{
model.pcode = row["pcode"].ToString();
}
if (row["pname"] != null)
{
model.pname = row["pname"].ToString();
}
if (row["psaleprice"] != null && row["psaleprice"].ToString() != "")
{
model.psaleprice = decimal.Parse(row["psaleprice"].ToString());
}
if (row["prealprice"] != null && row["prealprice"].ToString() != "")
{
model.prealprice = decimal.Parse(row["prealprice"].ToString());
}
if (row["ptype"] != null)
{
model.ptype = row["ptype"].ToString();
}
if (row["pisgroup"] != null && row["pisgroup"].ToString() != "")
{
model.pisgroup = int.Parse(row["pisgroup"].ToString());
}
if (row["pdesc"] != null)
{
model.pdesc = row["pdesc"].ToString();
}
if (row["ps1"] != null)
{
model.ps1 = row["ps1"].ToString();
}
if (row["ps2"] != null)
{
model.ps2 = row["ps2"].ToString();
}
if (row["ps3"] != null)
{
model.ps3 = row["ps3"].ToString();
}
if (row["ps4"] != null)
{
model.ps4 = row["ps4"].ToString();
}
if (row["ps5"] != null)
{
model.ps5 = row["ps5"].ToString();
}
if (row["pd1"] != null && row["pd1"].ToString() != "")
{
model.pd1 = int.Parse(row["pd1"].ToString());
}
if (row["pd2"] != null && row["pd2"].ToString() != "")
{
model.pd2 = int.Parse(row["pd2"].ToString());
}
if (row["pd3"] != null && row["pd3"].ToString() != "")
{
model.pd3 = int.Parse(row["pd3"].ToString());
}
if (row["pd4"] != null && row["pd4"].ToString() != "")
{
model.pd4 = int.Parse(row["pd4"].ToString());
}
if (row["pd5"] != null && row["pd5"].ToString() != "")
{
model.pd5 = int.Parse(row["pd5"].ToString());
}
if (row["pdc1"] != null && row["pdc1"].ToString() != "")
{
model.pdc1 = decimal.Parse(row["pdc1"].ToString());
}
if (row["pdc2"] != null && row["pdc2"].ToString() != "")
{
model.pdc2 = decimal.Parse(row["pdc2"].ToString());
}
if (row["pdc3"] != null && row["pdc3"].ToString() != "")
{
model.pdc3 = decimal.Parse(row["pdc3"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Jium.Model.product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update product set ");
strSql.Append("pcode=@pcode,");
strSql.Append("pname=@pname,");
strSql.Append("psaleprice=@psaleprice,");
strSql.Append("prealprice=@prealprice,");
strSql.Append("ptype=@ptype,");
strSql.Append("pisgroup=@pisgroup,");
strSql.Append("pdesc=@pdesc,");
strSql.Append("ps1=@ps1,");
strSql.Append("ps2=@ps2,");
strSql.Append("ps3=@ps3,");
strSql.Append("ps4=@ps4,");
strSql.Append("ps5=@ps5,");
strSql.Append("pd1=@pd1,");
strSql.Append("pd2=@pd2,");
strSql.Append("pd3=@pd3,");
strSql.Append("pd4=@pd4,");
strSql.Append("pd5=@pd5,");
strSql.Append("pdc1=@pdc1,");
strSql.Append("pdc2=@pdc2,");
strSql.Append("pdc3=@pdc3");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@pcode", MySqlDbType.VarChar, 20),
new MySqlParameter("@pname", MySqlDbType.VarChar, 50),
new MySqlParameter("@psaleprice", MySqlDbType.Decimal, 20),
new MySqlParameter("@prealprice", MySqlDbType.Decimal, 20),
new MySqlParameter("@ptype", MySqlDbType.VarChar, 20),
new MySqlParameter("@pisgroup", MySqlDbType.Int32, 11),
new MySqlParameter("@pdesc", MySqlDbType.VarChar, 200),
new MySqlParameter("@ps1", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps2", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps3", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps4", MySqlDbType.VarChar, 20),
new MySqlParameter("@ps5", MySqlDbType.VarChar, 20),
new MySqlParameter("@pd1", MySqlDbType.Int32, 11),
new MySqlParameter("@pd2", MySqlDbType.Int32, 11),
new MySqlParameter("@pd3", MySqlDbType.Int32, 11),
new MySqlParameter("@pd4", MySqlDbType.Int32, 11),
new MySqlParameter("@pd5", MySqlDbType.Int32, 11),
new MySqlParameter("@pdc1", MySqlDbType.Decimal, 20),
new MySqlParameter("@pdc2", MySqlDbType.Decimal, 20),
new MySqlParameter("@pdc3", MySqlDbType.Decimal, 20),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.pcode;
parameters[1].Value = model.pname;
parameters[2].Value = model.psaleprice;
parameters[3].Value = model.prealprice;
parameters[4].Value = model.ptype;
parameters[5].Value = model.pisgroup;
parameters[6].Value = model.pdesc;
parameters[7].Value = model.ps1;
parameters[8].Value = model.ps2;
parameters[9].Value = model.ps3;
parameters[10].Value = model.ps4;
parameters[11].Value = model.ps5;
parameters[12].Value = model.pd1;
parameters[13].Value = model.pd2;
parameters[14].Value = model.pd3;
parameters[15].Value = model.pd4;
parameters[16].Value = model.pd5;
parameters[17].Value = model.pdc1;
parameters[18].Value = model.pdc2;
parameters[19].Value = model.pdc3;
parameters[20].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtpcode.Text.Trim().Length == 0)
{
strErr += "pcode不能为空！\\n";
}
if (this.txtpname.Text.Trim().Length == 0)
{
strErr += "pname不能为空！\\n";
}
if (!PageValidate.IsNumber(txtpsaleprice.Text) && !PageValidate.IsDecimal(txtpsaleprice.Text))
{
strErr += "psaleprice格式错误！\\n";
}
if (!PageValidate.IsNumber(txtprealprice.Text) && !PageValidate.IsDecimal(txtprealprice.Text))
{
strErr += "prealprice格式错误！\\n";
}
if (this.txtptype.Text.Trim().Length == 0)
{
strErr += "ptype不能为空！\\n";
}
if (!PageValidate.IsNumber(txtpisgroup.Text))
{
strErr += "pisgroup格式错误！\\n";
}
/*
* if(this.txtpdesc.Text.Trim().Length==0)
* {
* strErr+="pdesc不能为空！\\n";
* }
* if(this.txtps1.Text.Trim().Length==0)
* {
* strErr+="ps1不能为空！\\n";
* }
* if(this.txtps2.Text.Trim().Length==0)
* {
* strErr+="ps2不能为空！\\n";
* }
* if(this.txtps3.Text.Trim().Length==0)
* {
* strErr+="ps3不能为空！\\n";
* }
* if(this.txtps4.Text.Trim().Length==0)
* {
* strErr+="ps4不能为空！\\n";
* }
* if(this.txtps5.Text.Trim().Length==0)
* {
* strErr+="ps5不能为空！\\n";
* }
* if(!PageValidate.IsNumber(txtpd1.Text))
* {
* strErr+="pd1格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpd2.Text))
* {
* strErr+="pd2格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpd3.Text))
* {
* strErr+="pd3格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpd4.Text))
* {
* strErr+="pd4格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpd5.Text))
* {
* strErr+="pd5格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpdc1.Text))
* {
* strErr+="pdc1格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpdc2.Text))
* {
* strErr+="pdc2格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpdc3.Text))
* {
* strErr+="pdc3格式错误！\\n";
* }
*/
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int id = int.Parse(this.lblid.Text);
string pcode = this.txtpcode.Text;
string pname = this.txtpname.Text;
decimal psaleprice = decimal.Parse(this.txtpsaleprice.Text);
decimal prealprice = decimal.Parse(this.txtprealprice.Text);
string ptype = this.txtptype.Text;
int pisgroup = int.Parse(this.txtpisgroup.Text);
string pdesc = this.txtpdesc.Text;
string ps1 = this.txtps1.Text;
string ps2 = this.txtps2.Text;
string ps3 = this.txtps3.Text;
string ps4 = this.txtps4.Text;
string ps5 = this.txtps5.Text;
int pd1 = string.IsNullOrWhiteSpace(this.txtpd1.Text)? 0:int.Parse(this.txtpd1.Text);
int pd2 = string.IsNullOrWhiteSpace(this.txtpd2.Text) ? 0 : int.Parse(this.txtpd2.Text);
int pd3 = string.IsNullOrWhiteSpace(this.txtpd3.Text) ? 0 : int.Parse(this.txtpd3.Text);
int pd4 = string.IsNullOrWhiteSpace(this.txtpd4.Text) ? 0 : int.Parse(this.txtpd4.Text);
int pd5 = string.IsNullOrWhiteSpace(this.txtpd5.Text) ? 0 : int.Parse(this.txtpd5.Text);
decimal pdc1 = string.IsNullOrWhiteSpace(this.txtpdc1.Text) ? 0 : decimal.Parse(this.txtpdc1.Text);
decimal pdc2 = string.IsNullOrWhiteSpace(this.txtpdc2.Text) ? 0 : decimal.Parse(this.txtpdc2.Text);
decimal pdc3 = string.IsNullOrWhiteSpace(this.txtpdc3.Text) ? 0 : decimal.Parse(this.txtpdc3.Text);
Jium.Model.product model = new Jium.Model.product();
model.id = id;
model.pcode = pcode;
model.pname = pname;
model.psaleprice = psaleprice;
model.prealprice = prealprice;
model.ptype = ptype;
model.pisgroup = pisgroup;
model.pdesc = pdesc;
model.ps1 = ps1;
model.ps2 = ps2;
model.ps3 = ps3;
model.ps4 = ps4;
model.ps5 = ps5;
model.pd1 = pd1;
model.pd2 = pd2;
model.pd3 = pd3;
model.pd4 = pd4;
model.pd5 = pd5;
model.pdc1 = pdc1;
model.pdc2 = pdc2;
model.pdc3 = pdc3;
Jium.BLL.product bll = new Jium.BLL.product();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
var bres = true;
do
{
string strErr = "";
//if(this.txtptime.Text.Trim().Length==0)
//{
// strErr+="ptime不能为空！\\n";
//}
if (this.txtpcode.Text.Trim().Length == 0)
{
strErr += "pcode不能为空！\\n";
}
if (!PageValidate.IsNumber(txtpcnt.Text))
{
strErr += "pcnt格式错误！\\n";
}
if (!PageValidate.IsNumber(txtpsaleprice.Text) && !PageValidate.IsDecimal(txtpsaleprice.Text))
{
strErr += "psaleprice格式错误！\\n";
}
if (!PageValidate.IsNumber(txtprealprice.Text) && !PageValidate.IsDecimal(txtprealprice.Text))
{
strErr += "prealprice格式错误！\\n";
}
if (!PageValidate.IsNumber(/*txtptype.Text*/ dropptype.SelectedValue))
{
strErr += "ptype格式错误！\\n";
}
if (!PageValidate.IsNumber(txtpzekou.Text) && !PageValidate.IsDecimal(txtpzekou.Text))
{
strErr += "pzekou格式错误！\\n";
}
//if(this.txtpremark.Text.Trim().Length==0)
//{
// strErr+="premark不能为空！\\n";
//}
if (!PageValidate.IsNumber(txtpguestid.Text))
{
strErr += "pguestid格式错误！\\n";
}
if (!PageValidate.IsNumber(txtpsalerid.Text))
{
strErr += "psalerid格式错误！\\n";
}
if (this.txtpios1.Text.Trim().Length == 0)
{
strErr += "pios1不能为空！\\n";
}
if (this.txtpios2.Text.Trim().Length == 0)
{
strErr += "pios2不能为空！\\n";
}
//if(this.txtpios3.Text.Trim().Length==0)
//{
// strErr+="pios3不能为空！\\n";
//}
/*
* if(this.txtpios4.Text.Trim().Length==0)
* {
* strErr+="pios4不能为空！\\n";
* }
* if(this.txtpios5.Text.Trim().Length==0)
* {
* strErr+="pios5不能为空！\\n";
* }
* if(!PageValidate.IsNumber(txtpiod1.Text))
* {
* strErr+="piod1格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpiod2.Text))
* {
* strErr+="piod2格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpiod3.Text))
* {
* strErr+="piod3格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpiod5.Text))
* {
* strErr+="piod5格式错误！\\n";
* }
* if(!PageValidate.IsNumber(txtpiod4.Text))
* {
* strErr+="piod4格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpiodc1.Text))
* {
* strErr+="piodc1格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpiodc2.Text))
* {
* strErr+="piodc2格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpiodc3.Text))
* {
* strErr+="piodc3格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpiodc4.Text))
* {
* strErr+="piodc4格式错误！\\n";
* }
* if(!PageValidate.IsDecimal(txtpiodc5.Text))
* {
* strErr+="piodc5格式错误！\\n";
* }
*/
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string ptime = DateTime.Now.ToString("yyyyMMddHHmmss");// ,this.txtptime.Text;
string pcode = this.txtpcode.Text;
int pcnt = int.Parse(this.txtpcnt.Text);
decimal psaleprice = decimal.Parse(this.txtpsaleprice.Text);
decimal prealprice = decimal.Parse(this.txtprealprice.Text);
int ptype = int.Parse(/*txtptype.Text*/ dropptype.SelectedValue);
decimal pzekou = decimal.Parse(this.txtpzekou.Text);
string premark = this.txtpremark.Text;
int pguestid = int.Parse(this.txtpguestid.Text);
int psalerid = int.Parse(this.txtpsalerid.Text);
string pios1 = this.txtpios1.Text;
string pios2 = this.txtpios2.Text;
string pios3 = this.txtpios3.Text;
//string pios4=this.txtpios4.Text;
//string pios5=this.txtpios5.Text;
//int piod1=int.Parse(this.txtpiod1.Text);
//int piod2=int.Parse(this.txtpiod2.Text);
//int piod3=int.Parse(this.txtpiod3.Text);
//int piod5=int.Parse(this.txtpiod5.Text);
//int piod4=int.Parse(this.txtpiod4.Text);
//decimal piodc1=decimal.Parse(this.txtpiodc1.Text);
//decimal piodc2=decimal.Parse(this.txtpiodc2.Text);
//decimal piodc3=decimal.Parse(this.txtpiodc3.Text);
//decimal piodc4=decimal.Parse(this.txtpiodc4.Text);
//decimal piodc5=decimal.Parse(this.txtpiodc5.Text);
Jium.Model.piorecord model = new Jium.Model.piorecord();
model.ptime = ptime;
model.pcode = pcode;
model.pcnt = pcnt;
model.psaleprice = psaleprice;
model.prealprice = prealprice;
model.ptype = ptype;
model.pzekou = pzekou;
model.premark = premark;
model.pguestid = pguestid;
model.psalerid = psalerid;
model.pios1 = pios1;
model.pios2 = pios2;
model.pios3 = pios3;
//model.pios4=pios4;
//model.pios5=pios5;
//model.piod1=piod1;
//model.piod2=piod2;
//model.piod3=piod3;
//model.piod5=piod5;
//model.piod4=piod4;
//model.piodc1=piodc1;
//model.piodc2=piodc2;
//model.piodc3=piodc3;
//model.piodc4=piodc4;
//model.piodc5=piodc5;
Jium.BLL.product bllProduct = new Jium.BLL.product();
Jium.BLL.plib bllPlib = new Jium.BLL.plib();
var where = string.Format("pcode='{0}'", pcode);
if (bllProduct.GetRecordCount(where) == 0)
{
if (this.txtpios3.Text.Trim().Length == 0)
{
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "新品请输入货品名称！", "add.aspx");
return;
}
Jium.Model.product pmodel = new Jium.Model.product();
pmodel.pcode = model.pcode;
pmodel.pname = model.pios3;
pmodel.pdesc = model.premark;
pmodel.psaleprice = model.psaleprice;
pmodel.prealprice = model.prealprice;
pmodel.ptype = "-";
pmodel.pisgroup = 0;
bllProduct.Add(pmodel);
}
Jium.BLL.piorecord bll = new Jium.BLL.piorecord();
if (!bll.Add(model))
{
break;
}
var pllst = bllPlib.GetModelList(where);
if (pllst.Count == 0)
{
Jium.Model.plib plmodel = new Jium.Model.plib();
plmodel.pcode = model.pcode;
plmodel.pname = model.pios3;
plmodel.psalecnt = 0;
plmodel.psumcnt = 0;
plmodel.pleftcnt = 0;
plmodel.pdesc = model.premark;
plmodel.plupdatetime = DateTime.Now.ToString("yyyyMMddHHmmss");
plmodel.pls1 = "";
plmodel.pld1 = 0;
switch (model.ptype)
{
case 0: //销售
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case 1: //进货
plmodel.psumcnt += model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 8: //退回厂商
plmodel.psumcnt -= model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case 2: //订单
plmodel.pld1 += model.pcnt;
break;
case 3: //盘赢
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 4: //盘亏
plmodel.pleftcnt -= model.pcnt;
break;
case 5: //退货
//plmodel.psalecnt -= model.pcnt;
//plmodel.pleftcnt += model.pcnt;
//break;
case 6: //换货进
plmodel.psalecnt -= model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 7: //换货出
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
}
bllPlib.Add(plmodel);
}
else
{
Jium.Model.plib plmodel = pllst[0];
plmodel.plupdatetime = DateTime.Now.ToString("yyyyMMddHHmmss");
switch (model.ptype)
{
case 0: //销售
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case 1: //进货
plmodel.psumcnt += model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 8: //退回厂商
plmodel.psumcnt -= model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case 2: //订单
plmodel.pld1 += model.pcnt;
break;
case 3: //盘赢
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 4: //盘亏
plmodel.pleftcnt -= model.pcnt;
break;
case 5: //退货
//plmodel.psalecnt -= model.pcnt;
//plmodel.pleftcnt += model.pcnt;
//break;
case 6: //换货进
plmodel.psalecnt -= model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case 7: //换货出
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
}
bllPlib.Update(plmodel);
}
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
return;
} while (false);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存失败！", "add.aspx");
}
catch (Exception ex)
{
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "Error！" + ex.Message, "add.aspx");
}
}
public static bool AddPiorecord(Jium.Model.piorecord model)
{
var bres = true;
try
{
do
{
Jium.BLL.product bllProduct = new Jium.BLL.product();
Jium.BLL.plib bllPlib = new Jium.BLL.plib();
var where = string.Format("pcode='{0}'", model.pcode);
if (bllProduct.GetRecordCount(where) == 0)
{
Jium.Model.product pmodel = new Jium.Model.product();
pmodel.pcode = model.pcode;
pmodel.pname = model.pios3;
pmodel.pdesc = model.premark;
pmodel.psaleprice = model.psaleprice;
pmodel.prealprice = model.prealprice;
pmodel.ptype = model.pios5; //系列
pmodel.ps1 = model.pios4; //单位
pmodel.pisgroup = 0;
bres = bllProduct.Add(pmodel);
if (!bres)
{
break;
}
}
Jium.BLL.piorecord bll = new Jium.BLL.piorecord();
bres = bll.Add(model);
if (!bres)
{
break;
}
var pllst = bllPlib.GetModelList(where);
if (pllst.Count == 0)
{
Jium.Model.plib plmodel = new Jium.Model.plib();
plmodel.pcode = model.pcode;
plmodel.pname = model.pios3;
plmodel.psalecnt = 0;
plmodel.psumcnt = 0;
plmodel.pleftcnt = 0;
plmodel.pdesc = model.premark;
plmodel.plupdatetime = DateTime.Now.ToString("yyyyMMddHHmmss");
plmodel.pls1 = "";
plmodel.pls2 = model.pios4;
plmodel.pld1 = 0;
switch ((PRODUCT_IO_TYPE)model.ptype)
{
case PRODUCT_IO_TYPE.SALE: //销售
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.ORDERIN: //进货
plmodel.psumcnt += model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.RETURN: //退回厂商
plmodel.psumcnt -= model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.ORDERPLAN: //订单
plmodel.pld1 += model.pcnt;
break;
case PRODUCT_IO_TYPE.SUMADD: //盘赢
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.SUMPLUS: //盘亏
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.REJECT: //退货
//plmodel.psalecnt -= model.pcnt;
//plmodel.pleftcnt += model.pcnt;
//break;
case PRODUCT_IO_TYPE.RECHARGEIN: //换货进
plmodel.psalecnt -= model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.RECHARGEOUT: //换货出
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
}
bres = bllPlib.Add(plmodel);
}
else
{
Jium.Model.plib plmodel = pllst[0];
plmodel.plupdatetime = DateTime.Now.ToString("yyyyMMddHHmmss");
switch ((PRODUCT_IO_TYPE)model.ptype)
{
case PRODUCT_IO_TYPE.SALE: //销售
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.ORDERIN: //进货
plmodel.psumcnt += model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.RETURN: //退回厂商
plmodel.psumcnt -= model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.ORDERPLAN: //订单
plmodel.pld1 += model.pcnt;
break;
case PRODUCT_IO_TYPE.SUMADD: //盘赢
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(model.pios2))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.SUMPLUS: //盘亏
plmodel.pleftcnt -= model.pcnt;
break;
case PRODUCT_IO_TYPE.REJECT: //退货
//plmodel.psalecnt -= model.pcnt;
//plmodel.pleftcnt += model.pcnt;
//break;
case PRODUCT_IO_TYPE.RECHARGEIN: //换货进
plmodel.psalecnt -= model.pcnt;
plmodel.pleftcnt += model.pcnt;
if (!plmodel.pls1.Contains(plmodel.pls1))
{
plmodel.pls1 += model.pios2 + ";";
}
break;
case PRODUCT_IO_TYPE.RECHARGEOUT: //换货出
plmodel.psalecnt += model.pcnt;
plmodel.pleftcnt -= model.pcnt;
break;
}
bres = bllPlib.Update(plmodel);
}
return(bres);
} while (false);
}
catch (Exception ex)
{
bres = false;
}
return(false);;
}
