public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; Entity.SaleBinding mBinding = new Entity.SaleBinding(); DataAccess.SaleBinding dalBinding = new DataAccess.SaleBinding(); DataTable dtBindList = dalBinding.GetList("SaleID='" + context.Request.Form["jobID"] + "'").Tables[0]; if (dtBindList.Rows.Count > 0) { mBinding = dalBinding.GetEntity(dtBindList.Rows[0][0].ToString()); mBinding.JobID = context.Request.Form["jobList"]; dalBinding.Update(mBinding); } else { mBinding.Guid = Guid.NewGuid().ToString(); mBinding.SaleID = context.Request.Form["jobID"]; mBinding.JobID = context.Request.Form["jobList"]; dalBinding.Add(mBinding); } context.Response.Write(""); } catch (Exception ex) { context.Response.Write("保存绑定信息错误!" + ex.ToString()); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string jobID = context.Request.Form["jobID"]; string[] jobList = context.Request.Form["jobList"].Split(';'); int[] carNum = new int[4]; if (!string.IsNullOrEmpty(jobID)) { //SaleBinding数据 Entity.SaleBinding mBinding = new Entity.SaleBinding(); DataAccess.SaleBinding dalBinding = new DataAccess.SaleBinding(); DataTable dtBindList = dalBinding.GetList("SaleID='" + jobID + "'").Tables[0]; if (dtBindList.Rows.Count > 0) { mBinding = dalBinding.GetEntity(dtBindList.Rows[0][0].ToString()); mBinding.JobID = context.Request.Form["jobList"]; dalBinding.Update(mBinding); } else { mBinding.Guid = Guid.NewGuid().ToString(); mBinding.SaleID = jobID; mBinding.JobID = context.Request.Form["jobList"]; dalBinding.Add(mBinding); } } //获取所需安全产品数量 foreach (string job in jobList) { if (!string.IsNullOrEmpty(job)) { DataTable dt = new DataAccess.RunProcedure().SelectCardNum(job).Tables[0]; if (dt.Rows.Count > 0) { carNum[0] += int.Parse(dt.Rows[0][0].ToString()); carNum[1] += int.Parse(dt.Rows[0][1].ToString()); carNum[2] += int.Parse(dt.Rows[0][2].ToString()); carNum[3] += int.Parse(dt.Rows[0][3].ToString()); } } } context.Response.Write(string.Format("{0}张法人卡,{1}张操作员IC卡,{2}张操作员IKEY,{3}张报关员卡。", carNum[0], carNum[1], carNum[2], carNum[3])); }
protected void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = (DataRowView)e.Item.DataItem; string jobid = drv.Row.ItemArray[0].ToString(); HtmlInputCheckBox cb = e.Item.FindControl("cbIsBind") as HtmlInputCheckBox; DataTable dt = new DataAccess.SaleBinding().GetList(string.Format("SaleID='{0}' and JobID like '%{1}%'", jobID, jobid)).Tables[0]; if (dt.Rows.Count > 0) { cb.Checked = true; } else { if (jobid == ZWL.ObjectOperation.QueryStringHelper.GetQuery("bindid")) { cb.Checked = true; } } } }
protected void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { if (type.Equals("view")) { HtmlTableCell td = e.Item.FindControl("tdCheck") as HtmlTableCell; td.Visible = false; } else if (type.Equals("edit")) { DataRowView drv = (DataRowView)e.Item.DataItem; string jobid = drv.Row.ItemArray[0].ToString(); DataTable dt = new DataAccess.SaleBinding().GetList(string.Format("SaleID='{0}' and JobID like '%{1}%'", jobID, jobid)).Tables[0]; HtmlInputCheckBox cb = e.Item.FindControl("cbIsBind") as HtmlInputCheckBox; if (dt.Rows.Count > 0) { cb.Checked = true; } } } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string jobID = context.Request.Form["hjobID"]; string saleID = string.Empty; Entity.JobInfo job = new Entity.JobInfo(); Entity.JobInfo sJob = new Entity.JobInfo(); DateTime time = DateTime.Now; DataAccess.TranHelper.BeginTran(); if (string.IsNullOrEmpty(jobID)) { DataAccess.RunProcedure procedure = new DataAccess.RunProcedure(); //JobInfo数据 job.JobID = context.Request.Form["jobSelect"] + "-" + DataAccess.CardCenterHelper.GetCardNo(); job.JobType = context.Request.Form["jobSelect"]; job.EnterpriseName = context.Request.Form["companyName"]; job.AgentPhone = context.Request.Form["txtPhone"]; job.CreateTime = time; job.CreateUser = context.Request.Form["customCode"]; job.IsDelete = false; job.Remark = context.Request.Form["txtRemark"]; job.CustomsCode = context.Request.Form["customCode"].Length == 10 ? context.Request.Form["customCode"] : null; job.IsOnline = false; job.ExpressFlat = false; if (job.JobType == "SL") { job.Fee = new DataAccess.Stock_Commodity().GetEntity(context.Request.Form["saleSelect"]).SellingPrice *int.Parse(context.Request.Form["txtNum"]); job.FeeFlat = "待缴费"; } else { job.Fee = 0; job.FeeFlat = "无须缴费"; } new DataAccess.JobInfo().Add(job); if (job.JobType == "NA" || job.JobType == "RI" || job.JobType == "RM") { sJob.JobID = "SL-" + DataAccess.CardCenterHelper.GetCardNo(); sJob.JobType = "SL"; sJob.EnterpriseName = job.EnterpriseName; sJob.AgentPhone = job.AgentPhone; sJob.CreateTime = job.CreateTime; sJob.CreateUser = job.CreateUser; sJob.IsDelete = false; sJob.Remark = job.Remark; sJob.CustomsCode = job.CustomsCode; sJob.IsOnline = false; sJob.Fee = new DataAccess.Stock_Commodity().GetEntity(context.Request.Form["saleSelect"]).SellingPrice *int.Parse(context.Request.Form["txtNum"]); sJob.FeeFlat = "待缴费"; sJob.ExpressFlat = false; new DataAccess.JobInfo().Add(sJob); Entity.SaleBinding saleBind = new Entity.SaleBinding(); saleBind.Guid = Guid.NewGuid().ToString(); saleBind.JobID = job.JobID; saleBind.SaleID = sJob.JobID; new DataAccess.SaleBinding().Add(saleBind); saleID = saleBind.SaleID; } //FlowInfo数据 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = int.Parse(new DataAccess.Flow().GetList(string.Format("FlowOrder=2 and JobType='{0}'", job.JobType)).Tables[0].Rows[0]["FlowStatus"].ToString()); flow.SubmitDate = time; flow.SubmitUser = PageBase.CommonObject.ManagerUserInfo.guid; flow.Content = "现场交单."; flow.IsDelete = false; flow.Remark = string.Empty; new DataAccess.FlowInfo().Add(flow); if (job.JobType == "NA" || job.JobType == "RI" || job.JobType == "RM") { Entity.FlowInfo sFlow = new Entity.FlowInfo(); sFlow.Guid = Guid.NewGuid().ToString(); sFlow.JobID = sJob.JobID; sFlow.FlowID = int.Parse(new DataAccess.Flow().GetList("FlowOrder=2 and JobType='SL'").Tables[0].Rows[0]["FlowStatus"].ToString()); sFlow.SubmitDate = flow.SubmitDate; sFlow.SubmitUser = flow.SubmitUser; sFlow.Content = flow.Content; sFlow.IsDelete = false; sFlow.Remark = string.Empty; new DataAccess.FlowInfo().Add(sFlow); } //绑定文件袋 if (!string.IsNullOrEmpty(context.Request.Form["hBar"])) { new DataAccess.JobBar().BindFile(context.Request.Form["hBar"], job.JobID); if (job.JobType == "NA" || job.JobType == "RI" || job.JobType == "RM") { new DataAccess.JobBar().BindFile(context.Request.Form["hBar"], sJob.JobID); } } } else { job = new DataAccess.JobInfo().GetModel(jobID); if (job.JobType == "SL") { job.Fee += new DataAccess.Stock_Commodity().GetEntity(context.Request.Form["saleSelect"]).SellingPrice *int.Parse(context.Request.Form["txtNum"]); new DataAccess.JobInfo().Update(job); } else if (job.JobType == "NA" || job.JobType == "RI" || job.JobType == "RM") { saleID = new DataAccess.SaleBinding().GetList(string.Format("JobID='{0}'", jobID)).Tables[0].Rows[0]["SaleID"].ToString(); sJob = new DataAccess.JobInfo().GetModel(saleID); sJob.Fee += new DataAccess.Stock_Commodity().GetEntity(context.Request.Form["saleSelect"]).SellingPrice *int.Parse(context.Request.Form["txtNum"]); new DataAccess.JobInfo().Update(sJob); } } //工单项信息 int random = new Random().Next(1, 9999); switch (job.JobType) { case "MD": for (int i = 0; i < int.Parse(context.Request.Form["txtNum"]); i++) { Entity.ModifyList md = new Entity.ModifyList(); md.JobType = context.Request.Form["businessSelect"]; md.ListID = md.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + (random + i).ToString().PadLeft(4, '0'); md.JobID = job.JobID; md.CardType = new DataAccess.Para_JobType().GetModel(md.JobType).CardType; md.IsChangeName = false; md.IsDelete = false; md.Remark = "现场交单."; new DataAccess.ModifyList().Add(md); } break; case "NA": for (int i = 0; i < int.Parse(context.Request.Form["txtNum"]); i++) { Entity.NewlyAddedList na = new Entity.NewlyAddedList(); na.JobType = context.Request.Form["businessSelect"]; na.ListID = na.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + (random + i).ToString().PadLeft(4, '0'); na.JobID = job.JobID; na.CardType = new DataAccess.Para_JobType().GetModel(na.JobType).CardType; na.CardholderIdentificationType = 1; na.IsDelete = false; na.Remark = "现场交单."; new DataAccess.NewlyAddedList().Add(na); } Entity.SaleList naSl = new Entity.SaleList(); if (new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows.Count == 0) { naSl.JobType = "SL001"; naSl.ListID = naSl.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + random.ToString().PadLeft(4, '0'); naSl.JobID = saleID; naSl.ProductType = context.Request.Form["saleSelect"]; naSl.Num = int.Parse(context.Request.Form["txtNum"]); naSl.IsDelete = false; naSl.Remark = "现场交单."; new DataAccess.SaleList().Add(naSl); } else { naSl = new DataAccess.SaleList().GetModel(new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows[0]["ListID"].ToString()); naSl.Num += int.Parse(context.Request.Form["txtNum"]); new DataAccess.SaleList().Update(naSl); } break; case "RI": for (int i = 0; i < int.Parse(context.Request.Form["txtNum"]); i++) { Entity.ReIssueList ri = new Entity.ReIssueList(); ri.JobType = context.Request.Form["businessSelect"]; ri.ListID = ri.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + (random + i).ToString().PadLeft(4, '0'); ri.JobID = job.JobID; ri.CardType = new DataAccess.Para_JobType().GetModel(ri.JobType).CardType; ri.IsDelete = false; ri.Remark = "现场交单."; new DataAccess.ReIssueList().Add(ri); } Entity.SaleList riSl = new Entity.SaleList(); if (new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows.Count == 0) { riSl.JobType = "SL001"; riSl.ListID = riSl.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + random.ToString().PadLeft(4, '0'); riSl.JobID = saleID; riSl.ProductType = context.Request.Form["saleSelect"]; riSl.Num = int.Parse(context.Request.Form["txtNum"]); riSl.IsDelete = false; riSl.Remark = "现场交单."; new DataAccess.SaleList().Add(riSl); } else { riSl = new DataAccess.SaleList().GetModel(new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows[0]["ListID"].ToString()); riSl.Num += int.Parse(context.Request.Form["txtNum"]); new DataAccess.SaleList().Update(riSl); } break; case "RM": for (int i = 0; i < int.Parse(context.Request.Form["txtNum"]); i++) { Entity.ReMakeList rm = new Entity.ReMakeList(); rm.JobType = context.Request.Form["businessSelect"]; rm.ListID = rm.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + (random + i).ToString().PadLeft(4, '0'); rm.JobID = job.JobID; rm.CardType = new DataAccess.Para_JobType().GetModel(rm.JobType).CardType; rm.IsDelete = false; rm.Remark = "现场交单."; new DataAccess.ReMakeList().Add(rm); } Entity.SaleList rmSl = new Entity.SaleList(); if (new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows.Count == 0) { rmSl.JobType = "SL001"; rmSl.ListID = rmSl.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + random.ToString().PadLeft(4, '0'); rmSl.JobID = saleID; rmSl.ProductType = context.Request.Form["saleSelect"]; rmSl.Num = int.Parse(context.Request.Form["txtNum"]); rmSl.IsDelete = false; rmSl.Remark = "现场交单."; new DataAccess.SaleList().Add(rmSl); } else { rmSl = new DataAccess.SaleList().GetModel(new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows[0]["ListID"].ToString()); rmSl.Num += int.Parse(context.Request.Form["txtNum"]); new DataAccess.SaleList().Update(rmSl); } break; case "SL": Entity.SaleList sl = new Entity.SaleList(); if (new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows.Count == 0) { sl.JobType = "SL001"; sl.ListID = sl.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + random.ToString().PadLeft(4, '0'); sl.JobID = job.JobID; sl.ProductType = context.Request.Form["saleSelect"]; sl.Num = int.Parse(context.Request.Form["txtNum"]); sl.IsDelete = false; sl.Remark = "现场交单."; sl.ManagerFlag = 0; sl.ManagerUser = PageBase.CommonObject.ManagerUserInfo.guid; sl.ManagerTime = DateTime.Now; new DataAccess.SaleList().Add(sl); } else { sl = new DataAccess.SaleList().GetModel(new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and ProductType='{1}' and IsDelete=0", saleID, context.Request.Form["saleSelect"])).Tables[0].Rows[0]["ListID"].ToString()); sl.Num += int.Parse(context.Request.Form["txtNum"]); new DataAccess.SaleList().Update(sl); } break; case "UU": for (int i = 0; i < int.Parse(context.Request.Form["txtNum"]); i++) { Entity.UpdateUnlockList uu = new Entity.UpdateUnlockList(); uu.JobType = context.Request.Form["businessSelect"]; uu.ListID = uu.JobType + "-" + time.ToString("yyyyMMddhhmmssfff") + (random + i).ToString().PadLeft(4, '0'); uu.JobID = job.JobID; uu.CardType = new DataAccess.Para_JobType().GetModel(uu.JobType).CardType; uu.IsDelete = false; uu.Remark = "现场交单."; new DataAccess.UpdateUnlockList().Add(uu); } break; } try { if (job.JobType != "UU" && job.JobType != "MD") { //减少显示库存 Entity.Stock_Commodity mCommodity = new DataAccess.Stock_Commodity().GetEntity(context.Request.Form["saleSelect"]); mCommodity.StockDesplay -= int.Parse(context.Request.Form["txtNum"]); if (mCommodity.StockDesplay < 0) { throw new Exception(string.Format("{0}{1}({2})库存不足,请更换库存充足的安全产品厂商或稍后再试!", mCommodity.AdditionalAttributes, mCommodity.CommodityName, mCommodity.CommodityType)); } else { new DataAccess.Stock_Commodity().Update(mCommodity); } } DataAccess.TranHelper.CommitTran(); DataAccess.TranHelper.BeginTran(); //处理列表信息 switch (job.JobType) { case "MD": new DataAccess.MDDataAccess().InsertHandleList(job); break; case "NA": new DataAccess.NADataAccess().InsertHandleList(job); new DataAccess.SLDataAccess().InsertHandleList(sJob); break; case "RI": new DataAccess.RIDataAccess().InsertHandleList(job); new DataAccess.SLDataAccess().InsertHandleList(sJob); break; case "RM": new DataAccess.RMDataAccess().InsertHandleList(job); new DataAccess.SLDataAccess().InsertHandleList(sJob); break; case "SL": new DataAccess.SLDataAccess().InsertHandleList(job); break; case "UU": new DataAccess.UUDataAccess().InsertHandleList(job); break; } DataAccess.TranHelper.CommitTran(); context.Response.Write(JsonConvert.SerializeObject(new Data("", job.JobID))); } catch (Exception ex) { context.Response.Write(JsonConvert.SerializeObject(new Data(ex.Message, ""))); } } catch (Exception ex) { context.Response.Write(JsonConvert.SerializeObject(new Data(ex.Message, ""))); } }
public void DataInit() { jobID = ZWL.ObjectOperation.QueryStringHelper.GetQuery("jobID"); type = ZWL.ObjectOperation.QueryStringHelper.GetQuery("type"); hJobID.Value = jobID; DataAccess.RunProcedure run = new DataAccess.RunProcedure(); repeater.DataSource = run.SaleJobList(CommonObject.LoginUserInfo.companyId).Tables[0]; repeater.DataBind(); if (!string.IsNullOrEmpty(jobID)) { DataSet ds = run.JobView(jobID, "SaleList"); if (ds.Tables[3].Rows[0]["StatusName"].Equals("未提交.")) { //2016-4-5 companyName.Value = ds.Tables[0].Rows[0]["EnterpriseName"].ToString(); companyAddress.Value = ds.Tables[0].Rows[0]["EnterpriseAddress"].ToString(); companyCode.Value = ds.Tables[0].Rows[0]["EnterpriseCode"].ToString(); if (companyCode.Value.Length == 18) { typeSelect.SelectedIndex = 1; } agentName.Value = ds.Tables[0].Rows[0]["AgentName"].ToString(); agentPhone.Value = ds.Tables[0].Rows[0]["AgentPhone"].ToString(); if (bool.Parse(ds.Tables[0].Rows[0]["ExpressFlat"].ToString())) { expressTrue.Checked = true; expresssFalse.Checked = false; } else { expressTrue.Checked = false; expresssFalse.Checked = true; } consigneeName.Value = ds.Tables[0].Rows[0]["ConsigneeName"].ToString(); consigneePhone.Value = ds.Tables[0].Rows[0]["ConsigneePhone"].ToString(); consigneeAddress.Value = ds.Tables[0].Rows[0]["ConsigneeAddress"].ToString(); txtInvoiceName.Value = ds.Tables[0].Rows[0]["InvoiceName"].ToString(); txtInvoicePhone.Value = ds.Tables[0].Rows[0]["InvoicePhone"].ToString(); txtInvoiceAddress.Value = ds.Tables[0].Rows[0]["InvoiceAddress"].ToString(); txtInvoicePostCode.Value = ds.Tables[0].Rows[0]["InvoicePostCode"].ToString(); txtInvoiceEmail.Value = ds.Tables[0].Rows[0]["InvoiceEmail"].ToString(); txtInvoiceCode.Value = ds.Tables[0].Rows[0]["InvoiceCode"].ToString(); GetFileType(ds); repeater1.DataSource = ds.Tables[1]; repeater1.DataBind(); DataTable jobDs = new DataAccess.SaleBinding().GetList("SaleID='" + jobID + "'").Tables[0]; if (jobDs.Rows.Count > 0) { hJobList.Value = jobDs.Rows[0]["JobID"].ToString(); } } else { Response.Redirect("../Manager/JobList.aspx"); } } else { GetFileType(null); ETGData(); hJobList.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("bindid"); agentName.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("name"); agentPhone.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("phone"); consigneeName.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("name"); consigneePhone.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("phone"); txtInvoiceName.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("name"); txtInvoicePhone.Value = ZWL.ObjectOperation.QueryStringHelper.GetQuery("phone"); } }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; string jobID = context.Request.Form["hJobID"]; DataAccess.RunProcedure procedure = new DataAccess.RunProcedure(); bool flat = true; if (!string.IsNullOrEmpty(jobID)) { DataSet view = procedure.JobView(jobID, "SaleList"); if (!view.Tables[3].Rows[0]["StatusName"].Equals("未提交.")) { flat = false; } } if (flat) { //JobInfo数据 Entity.JobInfo job = new Entity.JobInfo(); DateTime time = DateTime.Now; job.JobID = string.IsNullOrEmpty(jobID) ? "SL-" + CardCenter.DataAccess.CardCenterHelper.GetCardNo() : jobID; job.JobType = "SL"; job.CreateTime = time; job.CreateUser = PageBase.CommonObject.LoginUserInfo.companyId; job.IsDelete = false; job.EnterpriseName = CommonObject.LoginCompanyInfo.FULL_NAME; job.EnterpriseAddress = CommonObject.LoginCompanyInfo.ADDR_CO; job.EnterpriseCode = CommonObject.LoginCompanyInfo.COP_GB_CODE; job.AgentName = context.Request.Form["agentName"]; job.AgentPhone = context.Request.Form["agentPhone"]; job.ConsigneeName = context.Request.Form["consigneeName"]; job.ConsigneeAddress = context.Request.Form["consigneeAddress"]; job.ConsigneePhone = context.Request.Form["consigneePhone"]; job.ExpressFlat = context.Request.Form["expressflat"] == "快递" ? true : false; job.Remark = string.Empty; DataTable feeDt = procedure.JobFeeDetal(job.JobID, "SaleList").Tables[0]; job.Fee = decimal.Parse(feeDt.Rows[0]["Fee"].ToString()); if (job.Fee == 0) { job.FeeFlat = "无须缴费"; } else { job.FeeFlat = "待缴费"; } job.CustomsCode = CommonObject.LoginUserInfo.companyId; job.IsOnline = true; job.InvoiceName = context.Request.Form["txtInvoiceName"]; job.InvoicePhone = context.Request.Form["txtInvoicePhone"]; job.InvoiceAddress = context.Request.Form["txtInvoiceAddress"]; job.InvoicePostCode = context.Request.Form["txtInvoicePostCode"]; job.InvoiceEmail = context.Request.Form["txtInvoiceEmail"]; job.InvoiceCode = context.Request.Form["txtInvoiceCode"]; //FileList数据 List <Entity.FileList> fileList = new List <Entity.FileList>(); DataSet ds = procedure.SelectFileTypeByJobType("SL"); string fileErr = string.Empty; foreach (DataRow dr in ds.Tables[0].Rows) { string guid = context.Request.Form["h" + dr["FileTypeID"].ToString()]; string fileName = context.Request.Form["txt" + dr["FileTypeID"].ToString()]; if (!string.IsNullOrEmpty(guid)) { Entity.FileList file = new Entity.FileList(); file.Guid = guid; file.FileType = dr["FileTypeID"].ToString(); file.FileName = fileName; file.JobID = job.JobID; file.ListID = string.Empty; file.IsDelete = false; file.Remark = string.Empty; fileList.Add(file); } else { fileErr += "\n工单随附资料【" + dr["FileTypeName"] + "】未上传!"; } } DataSet list = new DataAccess.SaleList().GetList("JobID='" + job.JobID + "' and IsDelete=0"); foreach (DataRow dr in list.Tables[0].Rows) { DataSet typeDs = procedure.SelectFileTypeByJobType(dr["JobType"].ToString()); foreach (DataRow typeDr in typeDs.Tables[0].Rows) { string guid = context.Request.Form["h" + typeDr["FileTypeID"].ToString() + dr["ListID"].ToString()]; string fileName = context.Request.Form["txt" + typeDr["FileTypeID"].ToString() + dr["ListID"].ToString()]; if (!string.IsNullOrEmpty(guid)) { Entity.FileList file = new Entity.FileList(); file.Guid = guid; file.FileType = typeDr["FileTypeID"].ToString(); file.FileName = fileName; file.JobID = job.JobID; file.ListID = dr["ListID"].ToString(); file.IsDelete = false; file.Remark = string.Empty; fileList.Add(file); } else { fileErr += "\n工单项【业务类型:" + new DataAccess.Para_JobType().GetModel(dr["JobType"].ToString()).JobName + ",持卡人姓名:" + dr["CardholderName"] + "】随附资料【" + typeDr["FileTypeName"] + "】未上传!"; } } } if (context.Request.Form["type"] == "complete") { //判断是否添加附件 if (fileErr != "") { context.Response.Write(JsonConvert.SerializeObject(new Data(fileErr, ""))); return; } //判断是否添加工单项 ds = procedure.JobView(job.JobID, "SaleList"); if (ds.Tables[1].Rows.Count == 0) { context.Response.Write(JsonConvert.SerializeObject(new Data("\n请添加至少一条工单项记录!", ""))); return; } } //FlowInfo数据 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = context.Request.Form["hSaveType"] == "add" ? 1 : int.Parse(new CardCenter.DataAccess.Flow().GetList("JobType='SL' and FlowOrder=2").Tables[0].Rows[0]["FlowStatus"].ToString()); flow.SubmitDate = time; flow.SubmitUser = PageBase.CommonObject.LoginUserInfo.companyId; flow.Content = context.Request.Form["hSaveType"] == "add" ? PageBase.CommonObject.LoginCompanyInfo.FULL_NAME + "暂存数据." : PageBase.CommonObject.LoginCompanyInfo.FULL_NAME + "提交工单."; flow.IsDelete = false; flow.Remark = string.Empty; //SaleBinding数据 Entity.SaleBinding mBinding = new Entity.SaleBinding(); DataAccess.SaleBinding dalBinding = new DataAccess.SaleBinding(); DataTable dtBindList = dalBinding.GetList("SaleID='" + job.JobID + "'").Tables[0]; if (dtBindList.Rows.Count > 0) { mBinding = dalBinding.GetEntity(dtBindList.Rows[0][0].ToString()); mBinding.JobID = context.Request.Form["hJobList"]; dalBinding.Update(mBinding); } else { mBinding.Guid = Guid.NewGuid().ToString(); mBinding.SaleID = job.JobID; mBinding.JobID = context.Request.Form["hJobList"]; dalBinding.Add(mBinding); } //提交数据到后台存储过程事务 DataAccess.TranHelper.BeginTran(); DataAccess.SLDataAccess sl = new DataAccess.SLDataAccess(); sl.InsertHeadData(job, fileList, flow); if (context.Request.Form["hSaveType"] == "complete") { sl.InsertHandleList(job); //减少显示库存 ds = new DataAccess.RunProcedure().JobView(jobID, "SaleList"); foreach (DataRow dr in ds.Tables[1].Rows) { Entity.Stock_Commodity commodityEntity = new DataAccess.Stock_Commodity().GetEntity(dr["ProductType"].ToString()); commodityEntity.StockDesplay -= int.Parse(dr["Num"].ToString()); if (commodityEntity.StockDesplay < 0) { context.Response.Write(JsonConvert.SerializeObject(new Data(string.Format("\n{0}{1}({2})库存不足,请更换库存充足的安全产品厂商或稍后再试!", commodityEntity.AdditionalAttributes, commodityEntity.CommodityName, commodityEntity.CommodityType), ""))); return; } else { new DataAccess.Stock_Commodity().Update(commodityEntity); } } } try { DataAccess.TranHelper.CommitTran(); DataAccess.CardCenterHelper.SendMessage(job.JobID); context.Response.Write(JsonConvert.SerializeObject(new Data("", job.JobID))); } catch (Exception ex) { context.Response.Write(JsonConvert.SerializeObject(new Data("\n数据提交出错!" + ex.Message, ""))); } } else { context.Response.Write(JsonConvert.SerializeObject(new Data("该工单状态为已提交,无法继续修改工单信息!", ""))); } } catch (Exception ex) { context.Response.Write(JsonConvert.SerializeObject(new Data("\n" + ex.Message, ""))); } }