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; } } }