/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); StockIn.FSalesman = ddlFSalesman.SelectedValue; StockIn.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; StockIn.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; StockIn.FFreight = 0; StockIn.FLinkman = ""; StockIn.FMemo = txtFMemo.Text.Trim(); StockIn.FT6Warehouse = ddlFWarehouse.SelectedValue; StockIn.FGroup = ddlFGroup.SelectedValue; var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.FDate = txtFDate.SelectedDate; StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue; StockIn.FCate = ddlFCate.SelectedValue; //StockIn.CreateBy = CurrentUser.AccountName; return(StockInService.SaveChanges() >= 0); } return(false); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); StockIn.FCompanyId = CurrentUser.AccountComId; StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue; StockIn.FMemo = txtFMemo.Text.Trim(); StockIn.FDate = txtFDate.SelectedDate; var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.CreateBy = CurrentUser.AccountName; return(StockInService.SaveChanges() >= 0); } return(false); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); StockIn.FCate = "内部"; StockIn.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture); StockIn.FName = ""; StockIn.FMemo = txtFMemo.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.FBatchNumber = txtFBatchNumber.Text.Trim(); StockIn.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : ""; StockIn.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray); StockIn.FProductionWorkshop = ddlWorkShop.SelectedValue; StockIn.FDate = txtFDate.SelectedDate; StockIn.CreateBy = CurrentUser.AccountName; StockInService.SaveChanges(); var prod = StockInDetailsService.FirstOrDefault( p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId); if (prod != null) { prod.FItemCode = txtFCode.Text; prod.FQty = Convert.ToDecimal(txtFQty.Text); prod.FBottle = tbxFBottle.SelectedValue; prod.FBottleQty = Convert.ToInt16(txtFBottleQty.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); StockInDetailsService.SaveChanges(); } var orders = new Dictionary <string, object>(); orders.Clear(); orders.Add("@KeyId", StockIn.KeyId); orders.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders); return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim()).FirstOrDefault(); if (stock != null) { ModifiedGrid(); stock.FCompanyId = CurrentUser.AccountComId; stock.FDeleteFlag = 0; stock.FMemo = txtFMemo.Text.Trim(); stock.FDate = txtFDate.SelectedDate; stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue; 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_PurchaseAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; StockInService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PY", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "10"); 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); } return(true); } return(false); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); StockIn.FCode = txtFCode.Text; StockIn.FName = tbxFCustomer.Text; StockIn.FAddress = txtFAddress.Text.Trim(); StockIn.FCompanyId = CurrentUser.AccountComId; StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue; //StockIn.FDriver = !ddlFDriver.SelectedValue.Equals("-1") ? ddlFDriver.SelectedText : ""; StockIn.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; //StockIn.FSupercargo = !ddlFSupercargo.SelectedValue.Equals("-1") ? ddlFSupercargo.SelectedText : ""; StockIn.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; StockIn.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; StockIn.FFlag = 1; StockIn.FFreight = 0;//Convert.ToDecimal(txtFFreight.Text.Trim()); StockIn.FLinkman = txtFLinkman.Text.Trim(); StockIn.FMemo = txtFMemo.Text.Trim(); StockIn.FPhone = txtFPhone.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesReturnAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); StockIn.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); StockIn.FClass = ddlReturn.SelectedValue; LHCustomer custmernodel = new CustomerService().FirstOrDefault(p => p.FCode == txtFCode.Text.Trim()); if (custmernodel != null) { hfdCate.Text = "客户"; } else { hfdCate.Text = "供应商"; } StockIn.FCate = hfdCate.Text; StockIn.CreateBy = CurrentUser.AccountName; StockIn.FDate = txtFDate.SelectedDate; return(StockInService.SaveChanges() >= 0); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); var prod = StockInDetailsService.FirstOrDefault( p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId); if (prod == null) { //生产产品入库 var product = new LHStockInDetails { KeyId = txtKeyId.Text, FItemCode = txtFCode.Text, FPrice = 0, FAmount = 0, FQty = Convert.ToDecimal(txtFQty.Text), FBottle = tbxFBottle.SelectedValue, FBottleQty = Convert.ToInt16(txtFBottleQty.Text), FBottleOweQty = 0, FCompanyId = CurrentUser.AccountComId, FCateId = 2000, FMemo = "生产入库", FCostPrice = Convert.ToDecimal(txtFCostPrice.Text), FBalance = Convert.ToDecimal(txtFBalance.Text), }; StockInDetailsService.Add(product); } else { prod.FItemCode = txtFCode.Text; prod.FQty = Convert.ToDecimal(txtFQty.Text); prod.FBottle = tbxFBottle.SelectedValue; prod.FBottleQty = Convert.ToInt32(txtFBottleQty.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); StockInDetailsService.SaveChanges(); } //------------------------------------------------------------------- stock.FCompanyId = CurrentUser.AccountComId; stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FMemo = txtFMemo.Text.Trim(); 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_PurchaseAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : ""; stock.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray); stock.FBatchNumber = txtFBatchNumber.Text.Trim(); stock.FProductionWorkshop = ddlWorkShop.SelectedValue; stock.FCate = "内部"; stock.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture); stock.FName = ""; stock.FDate = txtFDate.SelectedDate; StockInService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PR", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "6"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; var orders = new Dictionary <string, object>(); orders.Clear(); orders.Add("@KeyId", newKeyId); orders.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders); //新增日志 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); } return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); //stock.FClass = ddlFCate.SelectedValue; stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; stock.FAddress = txtFAddress.Text.Trim(); stock.FCompanyId = CurrentUser.AccountComId; stock.FFlag = 1; stock.FDeleteFlag = 0; if (!string.IsNullOrEmpty(txtFFreight.Text.Trim())) { 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_PurchaseAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FDate = txtFDate.SelectedDate; stock.FReconciliation = txtFReconciliation.Text; stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; stock.FLogisticsNumber = tbxFLogisticsNumber.Text; stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim()); stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); stock.FSubjectCode = ddlSubject.SelectedValue; stock.FSubjectName = ddlSubject.SelectedText; stock.FDate = txtFDate.SelectedDate; #region T6 对接接口 //--------------------------------------------------------- //收发类型 stock.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; //部门名称 stock.FT6Department = ""; //部门代码 stock.FT6DepartmentNum = ""; //业务员代码 stock.FT6SalesmanNum = ""; //币种 stock.FT6Currency = ddlFT6Currency.SelectedValue; //汇率 stock.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text); //销售类型 stock.FT6PurchaseType = ddlFT6PurchaseType.SelectedText; stock.FT6PurchaseTypeNum = ddlFT6PurchaseType.SelectedValue; //T6同步 stock.FT6Status = "未同步"; stock.FT6Warehouse = ddlWarehouse.SelectedValue; //--------------------------------------------------------- #endregion stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue; StockInService.SaveChanges(); //订单出库 var passCard = PassCardService.Where(p => p.KeyId == tbxFLogisticsNumber.Text.Trim()).FirstOrDefault(); if (passCard != null) { passCard.FOutFlag = "已出库"; PassCardService.SaveChanges(); } if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "WC", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "4"); 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 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", string.IsNullOrEmpty(stock.FSKNum) ? "" : stock.FSKNum); SqlService.ExecuteProcedureCommand("proc_FKOrderAuto", parmsAuto); } return(true); } return(false); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); //StockIn.FClass = ddlFCate.SelectedValue; StockIn.FCode = txtFCode.Text; StockIn.FName = tbxFCustomer.Text; StockIn.FAddress = txtFAddress.Text.Trim(); StockIn.FCompanyId = CurrentUser.AccountComId; StockIn.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; StockIn.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; StockIn.FFlag = 1; if (!string.IsNullOrEmpty(txtFFreight.Text.Trim())) { StockIn.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); } StockIn.FLinkman = txtFLinkman.Text.Trim(); StockIn.FMemo = txtFMemo.Text.Trim(); StockIn.FPhone = txtFPhone.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.FDate = txtFDate.SelectedDate; StockIn.FSalesman = ddlFSalesman.SelectedValue; StockIn.FArea = ddlFArea.SelectedValue; StockIn.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim()); StockIn.FReconciliation = txtFReconciliation.Text; StockIn.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; StockIn.FLogisticsNumber = tbxFLogisticsNumber.Text; StockIn.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); StockIn.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); StockIn.FSubjectCode = ddlSubject.SelectedValue; StockIn.FSubjectName = ddlSubject.SelectedText; //StockIn.CreateBy = CurrentUser.AccountName; //--------------------------------------------------------- //收发类型 StockIn.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; StockIn.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; //部门名称 StockIn.FT6Department = ""; //部门代码 StockIn.FT6DepartmentNum = ""; //业务员代码 StockIn.FT6SalesmanNum = ""; //币种 StockIn.FT6Currency = ddlFT6Currency.SelectedValue; //汇率 StockIn.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text); //销售类型 StockIn.FT6PurchaseType = ddlFT6PurchaseType.SelectedText; StockIn.FT6PurchaseTypeNum = ddlFT6PurchaseType.SelectedValue; //T6同步 //StockOut.FT6Status = "未同步"; StockIn.FT6Warehouse = ddlWarehouse.SelectedValue; StockIn.FDistributionPoint = ddlFDistributionPoint.SelectedValue; StockInService.SaveChanges(); //付款部分 var parmsAuto = new Dictionary <string, object>(); parmsAuto.Clear(); parmsAuto.Add("@KeyId", StockIn.KeyId); parmsAuto.Add("@companyId", CurrentUser.AccountComId); parmsAuto.Add("@FCate", "供应商"); parmsAuto.Add("@date", Convert.ToDateTime(StockIn.FDate).ToShortDateString()); parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(StockIn.FSKNum) ? "" : StockIn.FSKNum); SqlService.ExecuteProcedureCommand("proc_FKOrderAuto", parmsAuto); return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.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.FCompanyId = CurrentUser.AccountComId; stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FFreight = 0;// Convert.ToDecimal(txtFFreight.Text.Trim()); stock.FLinkman = txtFLinkman.Text.Trim(); stock.FMemo = txtFMemo.Text.Trim(); stock.FPhone = txtFPhone.Text.Trim(); //stock.FDriver = !ddlFDriver.SelectedValue.Equals("-1") ? ddlFDriver.SelectedText : ""; stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; //stock.FSupercargo = !ddlFSupercargo.SelectedValue.Equals("-1") ? ddlFSupercargo.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_SalesReturnAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; 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.FClass = ddlReturn.SelectedValue; LHCustomer custmernodel = new CustomerService().FirstOrDefault(p => p.FCode == txtFCode.Text.Trim()); if (custmernodel != null) { hfdCate.Text = "客户"; } else { hfdCate.Text = "供应商"; } stock.FCate = hfdCate.Text; stock.FDate = txtFDate.SelectedDate; stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue; stock.FTime1 = DateTime.Now; StockInService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "HK", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "13"); 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); } return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FSalesman = ddlFSalesman.SelectedValue; stock.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; stock.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; stock.FFreight = 0; stock.FLinkman = ""; stock.FMemo = txtFMemo.Text.Trim(); stock.FT6Warehouse = ddlFWarehouse.SelectedValue; stock.FT6Status = "未同步"; stock.FGroup = ddlFGroup.SelectedValue; stock.FDistributionPoint = ddlFDistributionPoint.SelectedValue; 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_SalesReturnAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FDate = txtFDate.SelectedDate; stock.FCate = ddlFCate.SelectedValue; stock.FTime1 = DateTime.Now; StockInService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "IN", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "21"); 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}新增{2}单据。", newKeyId, CurrentUser.AccountName, ddlFCate.SelectedValue) }; GasHelper.AddBillStatus(billStatus); } return(true); } return(false); }