public void btnSave_Click(object sender, EventArgs e) { try { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageProduce SID = db.StorageProduce.SingleOrDefault(u => u.StorageInProduceID == _detailID); SID.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); SID.MaterialID = Convert.ToInt32(this.txtID.Text.Trim()); SID.QuantityGentaojian = Convert.ToDecimal(this.txtGTJ.Text.Trim()); SID.QuantityMetre = Convert.ToDecimal(this.txtMetre.Text.Trim()); SID.QuantityTon = Convert.ToDecimal(this.txtTon.Text.Trim()); if (this.ddlproject.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择预期使用项目!')</script>"); return; } SID.ExpectedProject = Convert.ToInt32(this.ddlproject.SelectedValue.Trim()); SID.ExpectedTime = this.DateTimeStorageIn.SelectedDate; if (this.ddlbatch.SelectedItem.Text == "--请选择--") { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择入库批次')</script>"); return; } SID.BatchIndex = this.ddlbatch.SelectedItem.Text.ToString(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); SID.CreateTime = SevTime.First(); SID.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); SID.Remark = this.txtRemark.Text.Trim(); db.SubmitChanges(); if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"])) { Response.Redirect("StorageDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + ""); } else { Response.Redirect("StorageDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + ""); } } } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR)); } }
private void BindDefaultDate() { int id = 0; if (!string.IsNullOrEmpty(Request.QueryString["StorageInID"])) { id = Convert.ToInt32(Request.QueryString["StorageInID"]); using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageInMain temp = db.StorageInMain.SingleOrDefault(u => u.StorageInID == id); this.txtStorageinNum.Text = temp.StorageInCode.ToString(); this.txtStorageinNum.Enabled = false; //初始化 StorageProduce sp = db.StorageProduce.SingleOrDefault(u => u.StorageInProduceID == _detailID); if (sp != null) { this.txtMaterialCode.Text = sp.MaterialInfo.MaterialName; this.txtMaterialMod.Text = sp.MaterialInfo.SpecificationModel; this.txtID.Text = sp.MaterialID.ToString(); this.txtFinanceCode.Text = sp.MaterialInfo.FinanceCode; this.txtGTJ.Text = sp.QuantityGentaojian.ToString(); this.txtMetre.Text = sp.QuantityMetre.ToString(); this.txtTon.Text = sp.QuantityTon.ToString(); this.ddlproject.SelectedValue = sp.ExpectedProject.ToString(); this.DateTimeStorageIn.SelectedDate = sp.ExpectedTime; this.ddlbatch.Text = sp.BatchIndex.Trim(); this.txtRemark.Text = sp.Remark.Trim(); } } } else { Response.Redirect("StorageManage.aspx"); } }
private bool checkInFlow(string selID) { using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageProduce sid = data.StorageProduce.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && u.StorageInProduceID == Convert.ToInt32(selID)); string CurBatch = sid.BatchIndex; var temp = from a in data.TaskStorageIn where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.StorageInType == "正常入库" && a.QCBatch == CurBatch select a; if (temp.ToList().Count > 0) { return(false); } } return(true); }
//数据导入 private void InsertData(Net.SourceForge.Koogra.Excel.Row row) { //loading图标 //this.img.Visible = true; //Response.AddHeader("Refresh", "0"); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //判断必填字段是否有空数据 for (int i = 0; i < 8; i++) { if (row.Cells[(uint)i] == null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('数据中有必填字段为空')</script>"); return; } } //判断是否有此入库单 StorageInMain si = db.StorageInMain.SingleOrDefault(u => u.StorageInCode == row.Cells[0].Value.ToString().Trim()); if (si == null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('待导入的入库单号[ " + row.Cells[0].Value.ToString().Trim() + " ] 不存在')</script>"); return; } //判断是否有物料编码 MaterialInfo mi = db.MaterialInfo.SingleOrDefault(u => u.FinanceCode == row.Cells[1].Value.ToString().Trim()); if (mi == null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('待导入的物料编码[ " + row.Cells[1].Value.ToString().Trim() + " ] 不存在,请先建立物料后再尝试导入')</script>"); return; } //判断数据格式 //根/套/件 if (!Utility.Security.ValidString(row.Cells[2].Value.ToString().Trim(), Utility.CodeValideType.零或者非零开头的整数)) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('根/套/件数量只能是整数')</script>"); return; } //米 if (!Utility.Security.ValidString(row.Cells[3].Value.ToString().Trim(), Utility.CodeValideType.带两位小数的正实数)) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('米的数量只能是整数或者带两位小数的正实数')</script>"); return; } //吨 if (!Utility.Security.ValidString(row.Cells[4].Value.ToString().Trim(), Utility.CodeValideType.带两位小数的正实数)) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('吨的数量只能是整数或者带两位小数的正实数')</script>"); return; } //判断有无项目信息 ProjectInfo pi = db.ProjectInfo.SingleOrDefault(u => u.ProjectCode == row.Cells[5].Value.ToString().Trim()); if (pi == null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('待导入的项目编码[ " + row.Cells[5].Value.ToString().Trim() + " ] 不存在,请先建立项目信息后再尝试导入')</script>"); return; } //预计到库时间 if (ConvData(row.Cells[6].Value.ToString().Trim()).ToString() != "1900-1-1 0:00:00") { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('入库时间不和规范,请按年-月-日格式,如:2010-10-10')</script>"); return; } //判断批次信息 if (!ValideBatch(row.Cells[7].Value.ToString())) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('" + row.Cells[7].Value.ToString() + "处 格式错误!请按此格式输入,如:第一批,第二批,最多十批')</script>"); return; } //ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('"+row.Cells[7].Value.ToString()+" 检查完毕一切正常')</script>"); //开始数据导入 StorageProduce SID = new StorageProduce(); SID.StorageInID = Convert.ToInt32(Request.QueryString["storageInID"]); //ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('" + SID.StorageInID + "')</script>"); SID.MaterialID = (db.MaterialInfo.SingleOrDefault(u => u.FinanceCode == row.Cells[1].Value.ToString().Trim())).MaterialID; SID.QuantityGentaojian = Convert.ToDecimal(row.Cells[2].Value.ToString().Trim()); SID.QuantityMetre = Convert.ToDecimal(row.Cells[3].Value.ToString().Trim()); SID.QuantityTon = Convert.ToDecimal(row.Cells[4].Value.ToString().Trim()); SID.ExpectedProject = (db.ProjectInfo.SingleOrDefault(u => u.ProjectCode == row.Cells[5].Value.ToString().Trim())).ProjectID; SID.ExpectedTime = ConvData(row.Cells[6].Value.ToString().Trim()); SID.BatchIndex = row.Cells[7].Value.ToString(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); SID.CreateTime = SevTime.First(); SID.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); if (row.Cells.MaxCol > 7) { SID.Remark = row.Cells[8].Value.ToString(); } else { SID.Remark = string.Empty; } db.StorageProduce.InsertOnSubmit(SID); db.SubmitChanges(); } }