void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.txtMatMainName.Text) && !string.IsNullOrEmpty(this.txtMatMainCode.Text)) { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //检查唯一性 var temp = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeCode == this.txtMatMainCode.Text.Trim()); if (temp == null) { MaterialMainType ei = new MaterialMainType(); ei.MaterialMainTypeName = this.txtMatMainName.Text.Trim(); ei.MaterialMainTypeCode = this.txtMatMainCode.Text.Trim(); if (this.ddlMatMain.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择所属主类!')</script>"); return; } ei.MaterialTypeID = int.Parse(this.ddlMatMain.SelectedValue); // ei.Remark = this.txtRemark.Text.Trim(); db.MaterialMainType.InsertOnSubmit(ei); db.SubmitChanges(); Response.Redirect("MatMainManager.aspx"); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('大类编码已存在')</script>"); } } } }
void InsertRow() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { MaterialMainType ei = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeID == int.Parse(Request.QueryString["MaterialMainTypeID"])); if (ei != null) { ei.MaterialMainTypeName = this.txtMatMainName.Text.Trim(); ei.MaterialMainTypeCode = this.txtMatMainCode.Text.Trim(); if (this.ddlMatMain.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择所属物料主类!')</script>"); return; } ei.MaterialTypeID = int.Parse(this.ddlMatMain.SelectedValue); //ei.Remark = this.txtRemark.Text.Trim(); db.SubmitChanges(); Response.Redirect("MatMainManager.aspx"); } } }
private void BindData() { int intID = 0; if (int.TryParse(Request.QueryString["MaterialMainTypeID"], out intID)) { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { MaterialMainType di = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeID == intID); if (di != null) { this.txtMatMainName.Text = di.MaterialMainTypeName; this.txtMatMainCode.Text = di.MaterialMainTypeCode; this.ddlMatMain.SelectedValue = di.MaterialTypeID.ToString(); // this.txtRemark.Text = di.Remark; } } } else { Response.Redirect("MatMainManager.aspx"); } }
private string InsertData(Net.SourceForge.Koogra.Excel.Row row) { string strResult = ""; using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //分段获取4种值,父类无值直接跳出 //获取主类 if (row.Cells[0] == null || row.Cells[1] == null) { return("主类信息不完整"); } MaterialType Temp; //检查大类是否存在 if (!db.MaterialType.Any(a => a.MaterialTypeCode == row.Cells[0].Value.ToString())) { Temp = new MaterialType(); //MT.MaterialMainTypeCode = Temp.MaterialTypeCode = row.Cells[0].Value.ToString(); Temp.MaterialTypeName = row.Cells[1].Value.ToString(); db.MaterialType.InsertOnSubmit(Temp); db.SubmitChanges(); } else { Temp = db.MaterialType.SingleOrDefault(a => a.MaterialTypeCode == row.Cells[0].Value.ToString()); Temp.MaterialTypeCode = row.Cells[0].Value.ToString(); Temp.MaterialTypeName = row.Cells[1].Value.ToString(); db.SubmitChanges(); } //获取大类 if (row.Cells[2] == null || row.Cells[3] == null) { return("大类信息不完整"); } MaterialMainType MT; //检查大类是否存在 if (!db.MaterialMainType.Any(a => a.MaterialMainTypeCode == row.Cells[2].Value.ToString())) { MT = new MaterialMainType(); //MT.MaterialMainTypeCode = MT.MaterialMainTypeCode = row.Cells[2].Value.ToString(); MT.MaterialMainTypeName = row.Cells[3].Value.ToString(); MT.MaterialTypeID = Temp.MaterialTypeID; db.MaterialMainType.InsertOnSubmit(MT); db.SubmitChanges(); } else { MT = db.MaterialMainType.SingleOrDefault(a => a.MaterialMainTypeCode == row.Cells[2].Value.ToString()); MT.MaterialMainTypeCode = row.Cells[2].Value.ToString(); MT.MaterialMainTypeName = row.Cells[3].Value.ToString(); MT.MaterialTypeID = Temp.MaterialTypeID; db.SubmitChanges(); } //获取中类 if (row.Cells[4] == null || row.Cells[5] == null) { return(""); } MaterialChildType mct; if (!db.MaterialChildType.Any(a => a.MaterialChildTypeCode == row.Cells[4].Value.ToString())) { mct = new MaterialChildType(); mct.MaterialChildTypeCode = row.Cells[4].Value.ToString(); mct.MaterialChildTypeName = row.Cells[5].Value.ToString(); mct.MaterialMainTypeID = MT.MaterialMainTypeID; db.MaterialChildType.InsertOnSubmit(mct); db.SubmitChanges(); } else { mct = db.MaterialChildType.SingleOrDefault(a => a.MaterialChildTypeCode == row.Cells[4].Value.ToString()); mct.MaterialChildTypeCode = row.Cells[4].Value.ToString(); mct.MaterialChildTypeName = row.Cells[5].Value.ToString(); mct.MaterialMainTypeID = MT.MaterialMainTypeID; db.SubmitChanges(); } //获取小类 if (row.Cells[6] == null || row.Cells[7] == null) { return(""); } MaterialInfo mi; if (!db.MaterialInfo.Any(a => a.FinanceCode == row.Cells[6].Value.ToString())) { mi = new MaterialInfo(); mi.MaterialchildTypeID = mct.MaterialChildTypeID; mi.FinanceCode = row.Cells[6].Value.ToString(); mi.MaterialName = row.Cells[7].Value.ToString(); mi.SpecificationModel = row.Cells[8].Value.ToString() ?? ""; mi.Remark = row.Cells[9].Value.ToString() ?? ""; db.MaterialInfo.InsertOnSubmit(mi); db.SubmitChanges(); } else { mi = db.MaterialInfo.SingleOrDefault(a => a.FinanceCode == row.Cells[6].Value.ToString()); mi.MaterialchildTypeID = mct.MaterialChildTypeID; mi.FinanceCode = row.Cells[6].Value.ToString(); mi.MaterialName = row.Cells[7].Value.ToString(); mi.SpecificationModel = row.Cells[8].Value.ToString() ?? ""; mi.Remark = row.Cells[9].Value.ToString() ?? ""; db.SubmitChanges(); } } return(strResult); }