/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = LiquidPlanTaskService.Where(p => p.KeyId == txtKeyId.Text.Trim() && // p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; //-------------------------------------------------- stock.FAddress = txtFAddress.Text.Trim(); stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); stock.FLinkman = txtFLinkman.Text.Trim(); stock.FMemo = txtFMemo.Text.Trim(); stock.FPhone = txtFPhone.Text.Trim(); stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; stock.FDate = txtFDate.SelectedDate; stock.FSalesman = ddlFSalesman.SelectedValue; stock.FArea = ddlFArea.SelectedValue; stock.FReconciliation = txtFReconciliation.Text; stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; stock.FLogisticsNumber = txtFLogisticsNumber.Text; stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); stock.FQty = Convert.ToDecimal(txtFQty.Text); stock.FPrice = Convert.ToDecimal(txtFPrice.Text); stock.FAmount = stock.FPrice * stock.FQty; stock.FItemCode = tbxFItemName.SelectedValue; stock.FItemName = tbxFItemName.SelectedText; LiquidPlanTaskService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "CC", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "29"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; //新增日志 var billStatus = new LHBillStatus { KeyId = newKeyId, FCompanyId = CurrentUser.AccountComId, FActionName = "新增", FDate = DateTime.Now, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FMemo = String.Format("单据号{0},{1}新增发货单据。", newKeyId, CurrentUser.AccountName) }; GasHelper.AddBillStatus(billStatus); } if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = BottleDetectionService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; //-------------------------------------------------- stock.FAddress = txtFAddress.Text.Trim(); stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); stock.FLinkman = txtFLinkman.Text.Trim(); stock.FMemo = txtFMemo.Text.Trim(); stock.FPhone = txtFPhone.Text.Trim(); stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", stock.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FDate = txtFDate.SelectedDate; stock.FSalesman = ddlFSalesman.SelectedValue; stock.FArea = ddlFArea.SelectedValue; stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim()); stock.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim()); stock.FReconciliation = txtFReconciliation.Text; stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; stock.FLogisticsNumber = txtFLogisticsNumber.Text; stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); stock.FSubjectCode = ddlSubject.SelectedValue; stock.FSubjectName = ddlSubject.SelectedText; stock.FSKNum = ""; BottleDetectionService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "XS", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "1"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; //新增日志 var billStatus = new LHBillStatus { KeyId = newKeyId, FCompanyId = CurrentUser.AccountComId, FActionName = "新增", FDate = DateTime.Now, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FMemo = String.Format("单据号{0},{1}新增钢瓶检测据。", newKeyId, CurrentUser.AccountName) }; GasHelper.AddBillStatus(billStatus); var bottles = new Dictionary <string, object>(); bottles.Clear(); bottles.Add("@SalesKeyId", newKeyId); bottles.Add("@companyid", CurrentUser.AccountComId); bottles.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd")); SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles); //收款部分 var parmsAuto = new Dictionary <string, object>(); parmsAuto.Clear(); parmsAuto.Add("@KeyId", newKeyId); parmsAuto.Add("@companyId", CurrentUser.AccountComId); parmsAuto.Add("@FCate", "客户"); parmsAuto.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd")); parmsAuto.Add("@FSKNum", stock.FSKNum); SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto); } if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } return(true); } return(false); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockOut != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// StockOut.FCode = txtFCode.Text; StockOut.FName = tbxFCustomer.Text; //------------------------------------------------------ StockOut.FAddress = txtFAddress.Text.Trim(); //StockOut.FCompanyId = CurrentUser.AccountComId; StockOut.FDate = txtFDate.SelectedDate; StockOut.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; StockOut.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; StockOut.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); StockOut.FLinkman = txtFLinkman.Text.Trim(); StockOut.FMemo = txtFMemo.Text.Trim(); StockOut.FPhone = txtFPhone.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockOut.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]); StockOut.FAmount = amt; StockOut.FSalesman = ddlFSalesman.SelectedValue; StockOut.FArea = ddlFArea.SelectedValue; StockOut.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());// StockOut.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim()); StockOut.FReconciliation = txtFReconciliation.Text; StockOut.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; StockOut.FLogisticsNumber = txtFLogisticsNumber.Text; StockOut.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); StockOut.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); StockOut.FSubjectCode = ddlSubject.SelectedValue; StockOut.FSubjectName = ddlSubject.SelectedText; var bottles = new Dictionary <string, object>(); bottles.Clear(); bottles.Add("@SalesKeyId", StockOut.KeyId); bottles.Add("@companyid", CurrentUser.AccountComId); bottles.Add("@date", Convert.ToDateTime(StockOut.FDate).ToString("yyyy-MM-dd")); SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles); //收款部分 var parmsAuto = new Dictionary <string, object>(); parmsAuto.Clear(); parmsAuto.Add("@KeyId", StockOut.KeyId); parmsAuto.Add("@companyId", CurrentUser.AccountComId); parmsAuto.Add("@FCate", "客户"); parmsAuto.Add("@date", Convert.ToDateTime(StockOut.FDate).ToShortDateString()); parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(StockOut.FSKNum) ? "" : StockOut.FSKNum); SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto); if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } //--------------------------------------------------------- //收发类型 StockOut.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; StockOut.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; //部门名称 StockOut.FT6Department = ""; //部门代码 StockOut.FT6DepartmentNum = ""; //业务员代码 StockOut.FT6SalesmanNum = ""; //币种 StockOut.FT6Currency = ddlFT6Currency.SelectedValue; //汇率 StockOut.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text); //销售类型 StockOut.FT6SaleType = ddlFT6SaleType.SelectedText; StockOut.FT6SaleTypeNum = ddlFT6SaleType.SelectedValue; //T6同步 //StockOut.FT6Status = "未同步"; return(StockOutService.SaveChanges() >= 0); } return(false); }