protected void btnUpdate_Click(object sender, EventArgs e)
{
if (this.FormCheck())
{
try
{
string sqlCheck = string.Format("select count(*) from Tb_Inventory where InvName='{0}' and Id<>{1}", txtInvName.Text, Request["Id"]);
if (Convert.ToInt32(DBHelp.ExeScalar(sqlCheck)) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('存货[{0}],已经存在！');</script>", txtInvName.Text));
return;
}
Tb_Inventory per = getModel();
if (this.invSer.Update(per))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改成功！');</script>");
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改失败！');</script>");
}
}
catch (Exception ex)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "！');</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//加载基本信息
ddlNumber.Items.Add(new ListItem {
Text = "", Value = ""
});
ddlRow.Items.Add(new ListItem {
Text = "", Value = ""
});
ddlCol.Items.Add(new ListItem {
Text = "", Value = ""
});
//货架号：1.全部 缺省 2….51 1,..50
for (int i = 1; i < 51; i++)
{
ddlNumber.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
//层数：1.全部 缺省 2….21 1,2,3…20
//部位：1.全部 缺省 2….21 1,2,3…20
if (i <= 21)
{
ddlRow.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
ddlCol.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
}
}
if (base.Request["Id"] != null)
{
this.btnAdd.Visible = false;
Tb_Inventory model = this.invSer.GetModel(Convert.ToInt32(base.Request["Id"]));
this.txtInvName.Text = model.InvName;
this.txtInvNum.Text = model.InvNum.ToString();
this.txtInvUnit.Text = model.InvUnit;
this.txtInvNo.Text = model.InvNo;
txtUser.Text = model.InvUser;
ddlArea.Text = model.GoodArea;
ddlCol.Text = model.GoodCol;
ddlRow.Text = model.GoodRow;
ddlNumber.Text = model.GoodNumber;
}
else
{
txtInvNum.Text = "0";
this.btnUpdate.Visible = false;
}
}
}
