protected void tbxFLogisticsNumber_OnTextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(tbxFLogisticsNumber.Text.Trim())) { var passCard = PassCardService.Where(p => p.KeyId == tbxFLogisticsNumber.Text.Trim()).FirstOrDefault(); if (passCard != null) { //ddlDeliveryMethod.SelectedValue = "配送";// txtFCode.Text = passCard.FCode; tbxFCustomer.Text = passCard.FName; txtFMemo.Text = passCard.FMemo; txtFLinkman.Text = passCard.FLinkman; txtFPhone.Text = passCard.FPhone; txtFAddress.Text = passCard.FAddress; var dis = new DispatchCenterService().Where(p => p.KeyId == passCard.FDispatchNum).FirstOrDefault(); if (dis != null) { if (!string.IsNullOrEmpty(dis.FDriver)) { ddlFDriver.SelectedValueArray = dis.FDriver.Split(','); } //if (!string.IsNullOrEmpty(passCard.FShipper)) // ddlFShipper.SelectedValueArray = passCard.FShipper.Split(','); if (!string.IsNullOrEmpty(dis.FSupercargo)) { ddlFSupercargo.SelectedValueArray = dis.FSupercargo.Split(','); } //if (!string.IsNullOrEmpty(StockOut.FSalesman)) // ddlFSalesman.SelectedValueArray = passCard.FSalesman.Split(','); ddlFVehicleNum.SelectedValue = dis.FVehicleNum; } var pamrs = new Dictionary <string, object>(); pamrs.Clear(); pamrs.Add("@FCode", passCard.FCode); pamrs.Add("@SalesKeyId", txtKeyId.Text.Trim()); pamrs.Add("@FCompanyId", CurrentUser.AccountComId); pamrs.Add("@KeyId", tbxFLogisticsNumber.Text.Trim()); SqlService.ExecuteProcedureCommand("proc_PassCardToPurchase", pamrs); BindDataGrid(); } } }
/// <summary> /// 运送列表 /// </summary> /// <param name="context"></param> /// <param name="model"></param> public void mainList(HttpContext context, WeReturnModel model) { string fdate = context.Request["fdate"]; string person = context.Request["person"]; try { var starttime = DateTime.Parse(fdate + " 00:00:00"); IQueryable <LHDispatchCenter> dispatchCenters = new DispatchCenterService().Where(p => p.FDate == starttime && (p.FDriver.Contains(person) || p.FSupercargo.Contains(person))); model.status = 0; model.data = dispatchCenters.ToList(); model.msg = "登录成功"; } catch (System.Exception ex) { model.status = 1; model.errmsg = ex.Message; model.msg = "登录失败"; } }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { //生成调度单 LHDispatchCenter dispatch = new LHDispatchCenter(); //调度单号生成 string newKeyId = SequenceService.CreateSequence("PC", CurrentUser.AccountComId); dispatch.KeyId = newKeyId; lblKeyId.Text = newKeyId; dispatch.FCompanyId = CurrentUser.AccountComId; dispatch.FBeginDate = dptBeginDate.SelectedDate; dispatch.FBeginTime = dpBeginTime.Text.Trim(); dispatch.FEndDate = dptEnd.SelectedDate; dispatch.FEndTime = dpEndTime.Text.Trim(); dispatch.FDate = DateTime.Now; dispatch.FVehicleNum = ddlFVehicleNum.SelectedValue; dispatch.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); dispatch.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); dispatch.CreateBy = CurrentUser.AccountName; dispatch.FFlag = 1; dispatch.FLogistics = ddlLogistics.SelectedText; dispatch.FLogisticsCode = ddlLogistics.SelectedValue; dispatch.FActual = string.IsNullOrEmpty(txtFActual.Text.Trim()) ? 0M : Convert.ToDecimal(txtFActual.Text.Trim()); dispatch.FTrailerPlate = ddlFTrailerPlate.SelectedValue; dispatch.FFrom = ddlFrom.SelectedValue; dispatch.FTo = ddlTo.SelectedValue; dispatch.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; dispatch.FAuditFlag = 0; DispatchCenterService.Add(dispatch); string[] keys = KeyId.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string[] patch = patchid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); foreach (string key in keys) { if (!string.IsNullOrEmpty(key)) { //状态 LHBillStatus flow = new LHBillStatus { KeyId = key, FCompanyId = CurrentUser.AccountComId, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FDate = Convert.ToDateTime(dptBeginDate.SelectedDate), FActionName = "配车", FMemo = string.Format(@"单据号{0}被{1}作配车业务处理。", key, CurrentUser.AccountName) }; BillStatusService.Add(flow); LHStockOut info = new StockOutService().FirstOrDefault(p => p.KeyId == key && p.FCompanyId == CurrentUser.AccountComId); if (info != null) { Dictionary <string, object> infoParms = new Dictionary <string, object>(); infoParms.Clear(); infoParms.Add("@keyid", info.FLogisticsNumber); infoParms.Add("@companyId", CurrentUser.AccountComId); infoParms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue); infoParms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray)); infoParms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray)); infoParms.Add("@FDispatchNum", newKeyId); //调度单号 SqlService.ExecuteProcedureCommand("proc_DispatchCenter", infoParms); } //变更单据上的司机、押韵员、车牌号 Dictionary <string, object> parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyid", key); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue); parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray)); parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray)); parms.Add("@FDispatchNum", newKeyId); //调度单号 SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms); List <LHStockOut> outs = new List <LHStockOut>(); List <LHPassCard> cards = new List <LHPassCard>(); } } foreach (var item in patch) { LHStockOutDispatch dis = StockoutDispatchServices.Where(p => p.KeyId == item).FirstOrDefault(); if (dis != null) { dis.FState = 1; StockoutDispatchServices.SaveChanges(); } } return(true); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (DispatchCenter != null) { DispatchCenter.FAccount = string.IsNullOrEmpty(txtAmount.Text) ? 0 : Convert.ToDecimal(txtAmount.Text); DispatchCenter.FBeginDate = dptBeginDate.SelectedDate; DispatchCenter.FVehicleNum = ddlFVehicleNum.SelectedValue; DispatchCenter.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); DispatchCenter.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); DispatchCenter.FBeginTime = dpBeginTime.Text.Trim(); DispatchCenter.FEndTime = dpEndTime.Text.Trim(); DispatchCenter.FEndDate = dptEnd.SelectedDate; DispatchCenter.FFuelingDate = dptFFuelingDate.SelectedDate; DispatchCenter.FMileage = string.IsNullOrEmpty(txtFMileage.Text) ? 0 : Convert.ToDecimal(txtFMileage.Text); DispatchCenter.FPrice = string.IsNullOrEmpty(txtPrice.Text) ? 0 : Convert.ToDecimal(txtPrice.Text); DispatchCenter.FQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text); DispatchCenter.Memo = txtFMemo.Text; DispatchCenter.FLogistics = ddlLogistics.SelectedText; DispatchCenter.FLogisticsCode = ddlLogistics.SelectedValue; DispatchCenter.FActual = string.IsNullOrEmpty(txtFActual.Text.Trim()) ? 0M : Convert.ToDecimal(txtFActual.Text.Trim()); DispatchCenter.FTrailerPlate = ddlFTrailerPlate.SelectedValue; DispatchCenter.FFrom = ddlFrom.SelectedValue; DispatchCenter.FTo = ddlTo.SelectedValue; DispatchCenter.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; //变更单据上的司机、押韵员、车牌号 Dictionary <string, object> parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyid", lblKeyId.Text); parms.Add("@FCompanyId", CurrentUser.AccountComId); DataTable data = SqlService.ExecuteProcedureCommand("proc_DispatchDetails", parms).Tables[0]; EnumerableRowCollection <object> keys = (from x in data.AsEnumerable() select x["keyid"]); foreach (string item in keys) { parms.Clear(); parms.Add("@keyid", item); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue); parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray)); parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray)); parms.Add("@FDispatchNum", lblKeyId.Text); //调度单号 SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms); } return(DispatchCenterService.SaveChanges() >= 0); } return(false); }
protected void btnSubmit_Click(object sender, EventArgs e) { bool isSucceed = false; try { switch (Actions) { case WebAction.Add: isSucceed = SubmintAdd(); break; case WebAction.Edit: isSucceed = SubmintEdit(); break; } tmsModel t = new tmsModel(); try { IQueryable <LHDispatchCenter> center = DispatchCenterService.Where(p => p.KeyId == lblKeyId.Text); if (center.Count() > 0) { t.dispatchCenterList = center.ToList(); } IQueryable <LHStockOut> iP = new StockOutService().Where(p => p.FDispatchNum == lblKeyId.Text); t.stockOutList = iP.ToList <LHStockOut>(); t.stockOutDetailsList = new List <LHStockOutDetails>(); foreach (LHStockOut item in iP) { IQueryable <LHStockOutDetails> li = new StockOutDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHStockOutDetails outDetails in li) { t.stockOutDetailsList.Add(outDetails); } } IQueryable <LHPassCard> lHPasses = PassCardService.Where(p => p.FDispatchNum == lblKeyId.Text); if (lHPasses != null) { t.passCardList = lHPasses.ToList(); } t.passCardDetailsList = new List <LHPassCardDetails>(); foreach (LHPassCard item in t.passCardList) { IQueryable <LHPassCardDetails> cardDetails = new PassCardDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHPassCardDetails details in cardDetails) { t.passCardDetailsList.Add(details); } } IQueryable <LHStockIn> skin = new StockInService().Where(p => p.FDispatchNum == lblKeyId.Text); if (skin != null && skin.Count() > 0) { t.stockInList = skin.ToList(); t.stockInDetailsList = new List <LHStockInDetails>(); foreach (LHStockIn item in skin) { IQueryable <LHStockInDetails> inDetails = new StockInDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHStockInDetails inDetail in inDetails) { t.stockInDetailsList.Add(inDetail); } } } new HttpRequest().httpRequest(t, "open/dbo/dboData"); } catch (Exception) { } } catch (DbEntityValidationException ex) { string msg = string.Empty; List <ICollection <DbValidationError> > errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList(); foreach (ICollection <DbValidationError> item in errors) { msg += item.FirstOrDefault().ErrorMessage; } isSucceed = false; } finally { if (isSucceed) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.Show("提交失败!", MessageBoxIcon.Error); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string backouts = context.Request["params"]; TmsReturnModel returnModel = new TmsReturnModel(); StockOutDetailsService service = new StockOutDetailsService(); DispatchCenterService centerService = new DispatchCenterService(); StockInDetailsService stockInDetails = new StockInDetailsService(); try { using (TransactionScope trans = new TransactionScope()) { tmsModel outs = JsonConvert.DeserializeObject <tmsModel>(backouts); if (outs.stockOutDetailsList != null) { foreach (LHStockOutDetails items in outs.stockOutDetailsList) { LHStockOutDetails details = service.Where(p => p.KeyId == items.KeyId && p.FId == items.FId).FirstOrDefault(); if (details != null) { details.FRecycleQty = items.FRecycleQty; details.FReturnQty = items.FReturnQty; details.FDevice = items.FDevice; details.FDeviceValue = string.IsNullOrEmpty(items.FDeviceValue.ToString()) ? 0 : Convert.ToDecimal(items.FDeviceValue); details.FInTemperature = string.IsNullOrEmpty(items.FInTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FInTemperature.ToString()); details.FInPressure = string.IsNullOrEmpty(items.FInPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FInPressure.ToString()); details.FOutTemperature = string.IsNullOrEmpty(items.FOutTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FOutTemperature.ToString()); details.FOutPressure = string.IsNullOrEmpty(items.FOutPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FOutPressure.ToString()); details.FPayTemperature = string.IsNullOrEmpty(items.FPayTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FPayTemperature.ToString()); details.FPayPressure = string.IsNullOrEmpty(items.FPayPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FPayPressure.ToString()); details.FReceiveTemperature = string.IsNullOrEmpty(items.FReceiveTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FReceiveTemperature.ToString()); details.FReceivePressure = string.IsNullOrEmpty(items.FReceivePressure.ToString()) // ? 0 : Convert.ToDecimal(items.FReceivePressure.ToString()); //数量计算 LHStockOut StockOut = new StockOutService().Where(p => p.KeyId == items.KeyId).FirstOrDefault(); string FCode = StockOut.FCode; //计算公式 LHTubePrice v1 = new TubePriceService().Where(p => p.FBill == "销售" &&// p.FCode == FCode &&// p.FItemCode == details.FItemCode).FirstOrDefault(); if (v1 != null) { //< font color = "red" >$W1:进厂温度、$W2:出厂温度、$W3: 交付温度、$W4: 接收温度、$V: 水容积 </ font >< br /> //< font color = "red" >$Y1:进厂压力、$Y2:出厂压力、$Y3: 交付压力、$Y4: 接收压力 </ font >< br /> string inW = Convert.ToDecimal(details.FInTemperature).ToString(CultureInfo.InvariantCulture); string inY = Convert.ToDecimal(details.FInPressure).ToString(CultureInfo.InvariantCulture); string outW = Convert.ToDecimal(details.FOutTemperature).ToString(CultureInfo.InvariantCulture); string outY = Convert.ToDecimal(details.FOutPressure).ToString(CultureInfo.InvariantCulture);; string payW = Convert.ToDecimal(details.FPayTemperature).ToString(CultureInfo.InvariantCulture); string payY = Convert.ToDecimal(details.FPayPressure).ToString(CultureInfo.InvariantCulture); string recW = Convert.ToDecimal(details.FReceiveTemperature).ToString(CultureInfo.InvariantCulture); string recY = Convert.ToDecimal(details.FReceivePressure).ToString(CultureInfo.InvariantCulture); //水溶积 string v = Convert.ToDecimal(details.FDeviceValue).ToString(CultureInfo.InvariantCulture); //数量 string s1 = v1.FFormula.Replace("$W1", inW) // .Replace("$W2", outW) .Replace("$W3", payW) // .Replace("$W4", recW) // .Replace("$Y1", inY) // .Replace("$Y2", outY) // .Replace("$Y3", payY) // .Replace("$Y4", recY) // .Replace("$V", v); //数量 details.FQty = Convert.ToDecimal(FormulaCalculator.Eval(s1)); //金额 details.FAmount = details.FQty * details.FPrice; } service.SaveChanges(); } } } if (outs.dispatchCenterList != null) { foreach (LHDispatchCenter item in outs.dispatchCenterList) { LHDispatchCenter lH = centerService.Where(p => p.KeyId == item.KeyId & p.FAuditFlag == 0).FirstOrDefault(); if (lH != null) { lH.FDriver = item.FDriver; lH.FSupercargo = item.FSupercargo; lH.FMileage = item.FMileage; } centerService.SaveChanges(); } } trans.Complete(); } returnModel.code = "200"; returnModel.msg = "成功"; } catch (Exception ex) { returnModel.code = "500"; returnModel.msg = "失败"; returnModel.msg = ex.Message; } context.Response.Write(JsonConvert.SerializeObject(returnModel)); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (DispatchCenter != null) { DispatchCenter.FBeginDate = dptBeginDate.SelectedDate; DispatchCenter.FVehicleNum = ddlFVehicleNum.SelectedValue; DispatchCenter.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); DispatchCenter.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); DispatchCenter.FMileage = string.IsNullOrEmpty(txtFMileage.Text) ? 0 : Convert.ToDecimal(txtFMileage.Text); DispatchCenter.FFrom = ddlFrom.SelectedValue; DispatchCenter.FTo = ddlTo.SelectedValue; //记录数 DispatchCenter.TaskQty = txtTaskQty.Text == "" ? 0 : decimal.Parse(txtTaskQty.Text); DispatchCenter.FDriverYQty = txtFDriverYQty.Text == "" ? 0 : decimal.Parse(txtFDriverYQty.Text); DispatchCenter.FDriverQty = txtFDriverQty.Text == "" ? 0 : decimal.Parse(txtFDriverQty.Text); DispatchCenter.FDriverJQty = txtFDriverJQty.Text == "" ? 0 : decimal.Parse(txtFDriverJQty.Text); //司机 DispatchCenter.FDriverYAmount = DispatchCenter.FDriverYPrice * DispatchCenter.FDriverYQty; DispatchCenter.FDriverAmount = DispatchCenter.FDriverPrice * DispatchCenter.FDriverQty; DispatchCenter.FDriverJAmount = DispatchCenter.FDriverJPrice * DispatchCenter.FDriverJQty; DispatchCenter.FDriverMileageAmt = txtFDriverMileageAmt.Text == "" ? 0 : decimal.Parse(txtFDriverMileageAmt.Text); //押运 DispatchCenter.FSupercargoYAmount = DispatchCenter.FSupercargoYPrice * DispatchCenter.FDriverYQty; DispatchCenter.FSupercargoAmount = DispatchCenter.FSupercargoPrice * DispatchCenter.FDriverQty; DispatchCenter.FSupercargoJAmount = DispatchCenter.FSupercargoJPrice * DispatchCenter.FDriverJQty; DispatchCenter.FSupercargoMileageAmt = txtFSupercargoMileageAmt.Text == "" ? 0 : decimal.Parse(txtFSupercargoMileageAmt.Text); //变更单据上的司机、押韵员、车牌号 Dictionary <string, object> parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyid", lblKeyId.Text); parms.Add("@FCompanyId", CurrentUser.AccountComId); DataTable data = SqlService.ExecuteProcedureCommand("proc_DispatchDetails", parms).Tables[0]; EnumerableRowCollection <object> keys = (from x in data.AsEnumerable() select x["keyid"]); foreach (string item in keys) { parms.Clear(); parms.Add("@keyid", item); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@FVehicleNum", ddlFVehicleNum.SelectedValue); parms.Add("@FDriver", GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray)); parms.Add("@FSupercargo", GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray)); parms.Add("@FDispatchNum", lblKeyId.Text); //调度单号 SqlService.ExecuteProcedureCommand("proc_DispatchCenter", parms); } return(DispatchCenterService.SaveChanges() >= 0); } return(false); }