public void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.txtName.Text) && !string.IsNullOrEmpty(this.txtCode.Text)) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["DeliveredTypeID"]); DeliveredTypeInfo DTI = db.DeliveredTypeInfo.SingleOrDefault(a => a.DeliveredTypeID == id); DTI.DeliveredTypeName = this.txtName.Text.Trim(); DeliveredTypeInfo code = db.DeliveredTypeInfo.SingleOrDefault(u => u.DeliveredTypeCode == this.txtCode.Text.Trim()); if (code == null) { DTI.DeliveredTypeCode = this.txtCode.Text.Trim(); } else { if (DTI.DeliveredTypeID == code.DeliveredTypeID) { DTI.DeliveredTypeCode = this.txtCode.Text.Trim(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('出库类型编码重复!')</script>"); return; } } db.SubmitChanges(); Response.Redirect("DeliveredTypeManage.aspx"); } } }
private void LoadData() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["DeliveredTypeID"]); DeliveredTypeInfo DTI = db.DeliveredTypeInfo.SingleOrDefault(a => a.DeliveredTypeID == id); if (DTI != null) { this.txtName.Text = DTI.DeliveredTypeName.ToString(); this.txtCode.Text = DTI.DeliveredTypeCode.ToString(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>"); Response.Redirect("DeliveredTypeManage.aspx"); } } }