/// <summary> /// 保存 /// </summary> public bool SaveData() { #region 赋值 InOutData inoutData = new InOutData(); inoutData.isIn = true; //出入库类型 inoutData.InOutType = (int)InOutType.OtherIn; //出入库状态 inoutData.InOutStatus = (int)InOutStatus.AllReach; //出入库单号 if (!string.IsNullOrEmpty(textEditInOutCode.Text)) { inoutData.InOutCode = textEditInOutCode.Text; if (inoutHelper.ExistInOutCode(inoutData.InOutCode)) { XtraMessageBox.Show("此单号已存在", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); textEditInOutCode.Focus(); return(false); } } else { inoutData.InOutCode = Guid.NewGuid().ToString(); } //出入库时间 if (string.IsNullOrEmpty(dateEditInTime.Text)) { XtraMessageBox.Show("请填写入库日期", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); dateEditInTime.Focus(); return(false); } inoutData.InOutDateTime = DateTime.Parse(dateEditInTime.Text); //业务员及编号 if (string.IsNullOrEmpty(pceOperator.Text)) { XtraMessageBox.Show("请填写业务员", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); pceOperator.Focus(); return(false); } inoutData.Operator = pceOperator.Text; inoutData.OperatorCode = pceOperator.Tag.ToString(); //付款方式 inoutData.PayType = comboPayType.SelectedIndex; //应付金额 if (!string.IsNullOrEmpty(textEditNeedToPay.Text)) { inoutData.NeedToPay = double.Parse(textEditNeedToPay.EditValue.ToString()); } else { inoutData.NeedToPay = 0.0; } //本次付款金额 if (!string.IsNullOrEmpty(textEditPayThisTime.Text)) { inoutData.PayThisTime = double.Parse(textEditPayThisTime.EditValue.ToString()); } else { inoutData.PayThisTime = 0.0; } //到账日期 if (!string.IsNullOrEmpty(dateEditIncomeTime.Text)) { inoutData.IncomeTime = DateTime.Parse(dateEditIncomeTime.Text); } else { inoutData.IncomeTime = DateTime.MinValue; } //合计金额 if (!string.IsNullOrEmpty(textEditTotalFee.Text)) { inoutData.TotalFee = double.Parse(textEditTotalFee.EditValue.ToString()); } else { inoutData.TotalFee = 0.0; } //税率 inoutData.Tax = 0.0; //税额 if (!string.IsNullOrEmpty(textEditAmountTax.Text)) { inoutData.AmountTax = double.Parse(textEditAmountTax.EditValue.ToString()); } else { inoutData.AmountTax = 0.0; } //折扣金额 if (!string.IsNullOrEmpty(textEditDiscountFee.Text)) { inoutData.DiscountFee = double.Parse(textEditDiscountFee.EditValue.ToString()); } else { inoutData.DiscountFee = 0.0; } //支付期限 if (!string.IsNullOrEmpty(textEditPayTerm.Text)) { inoutData.PayTerm = int.Parse(textEditPayTerm.Text); } //快递公司 inoutData.FreightCompany = string.Empty; inoutData.FreightCode = string.Empty; #endregion return(inoutHelper.Save(gvOtherInProduct, inoutData)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="gridView"></param> /// <param name="dateEditInTime"></param> public bool Save(GridView gridView, InOutData inoutData) { if (gridView == null || gridView.RowCount == 0) { XtraMessageBox.Show("没有可保存的数据", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } bool isSelectHouse = HouseSelect(gridView); if (!isSelectHouse) { XtraMessageBox.Show("需要选择仓库", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } bool isSelectLayout = LayoutSelect(gridView); if (!isSelectLayout) { XtraMessageBox.Show("需要选择库位", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } //用于存放要保存到数据库的StockProduct List <Alading.Entity.StockProduct> stockProductList = new List <StockProduct>(); //用于存放要保存到数据库的StockHouseProduct List <Alading.Entity.StockHouseProduct> stockHouseProList = new List <StockHouseProduct>(); //用于存放要保存到数据库的StockDetail List <Alading.Entity.StockDetail> stockDetailList = new List <StockDetail>(); List <string> outerSkuIdList = new List <string>(); List <string> outerIdList = new List <string>(); for (int rowHandle = 0; rowHandle < gridView.RowCount; rowHandle++) { DataRow dataRow = gridView.GetDataRow(rowHandle); #region 更新StockItem StockProduct StockHouseProduct Alading.Entity.StockProduct stockProduct = new StockProduct(); stockProduct.SkuOuterID = dataRow["SkuOuterID"] == null ? string.Empty : dataRow["SkuOuterID"].ToString(); stockProduct.OuterID = dataRow["OuterId"] == null ? string.Empty : dataRow["OuterId"].ToString(); //获取入库数量 double inOutNum = 0.0; if (dataRow["Count"] == null || string.IsNullOrEmpty(dataRow["Count"].ToString())) { stockProduct.SkuQuantity = 0; } else if (inoutData.isIn) { inOutNum = double.Parse(dataRow["Count"].ToString()); stockProduct.SkuQuantity = int.Parse(inOutNum.ToString()); } else { inOutNum = double.Parse(dataRow["Count"].ToString()); stockProduct.SkuQuantity = -int.Parse(inOutNum.ToString()); } //存放以准备保存到数据库 stockProductList.Add(stockProduct); outerSkuIdList.Add(dataRow["SkuOuterID"].ToString()); outerIdList.Add(dataRow["OuterId"].ToString()); #endregion #region 添加或更新StockHouseProduct StockHouseProduct stockHousePro = new StockHouseProduct(); stockHousePro.HouseCode = dataRow["HouseCode"] == null ? string.Empty : dataRow["HouseCode"].ToString(); stockHousePro.LayoutCode = dataRow["LayoutCode"] == null ? string.Empty : dataRow["LayoutCode"].ToString(); stockHousePro.SkuOuterID = stockProduct.SkuOuterID; stockHousePro.Num = stockProduct.SkuQuantity; stockHousePro.HouseName = dataRow["HouseName"].ToString(); stockHousePro.LayoutName = dataRow["LayoutName"].ToString(); stockHouseProList.Add(stockHousePro); #endregion #region 添加到StockDetail Alading.Entity.StockDetail stockDetail = new StockDetail(); stockDetail.StockDetailCode = Guid.NewGuid().ToString(); stockDetail.ProductSkuOuterId = stockProduct.SkuOuterID; stockDetail.InOutCode = inoutData.InOutCode; //仓库编号 stockDetail.StockHouseCode = dataRow["HouseCode"] == null ? string.Empty : dataRow["HouseCode"].ToString(); //库位编号 stockDetail.StockLayOutCode = dataRow["LayoutCode"] == null ? string.Empty : dataRow["LayoutCode"].ToString(); //商品价格 stockDetail.Price = (float)stockProduct.SkuPrice; stockDetail.Quantity = int.Parse(inOutNum.ToString()); stockDetail.DetailType = inoutData.InOutType; stockDetail.DetailRemark = dataRow["DetailRemark"] == null ? string.Empty : dataRow["DetailRemark"].ToString(); //税率 stockDetail.Tax = dataRow["Tax"] == null ? string.Empty : dataRow["Tax"].ToString(); stockDetail.TotalFee = dataRow["TotalMoney"] == null ? 0 : float.Parse(dataRow["TotalMoney"].ToString()); //商品的保质期 stockDetail.DurabilityDate = System.DateTime.MaxValue; stockDetailList.Add(stockDetail); #endregion } #region 添加StockInOut //用于存放StockInOut List <Alading.Entity.StockInOut> stockInOutList = new List <Alading.Entity.StockInOut>(); Alading.Entity.StockInOut stockInOut = new Alading.Entity.StockInOut(); //进出库单编号 stockInOut.InOutCode = inoutData.InOutCode; stockInOut.InOutTime = inoutData.InOutDateTime; stockInOut.OperatorCode = inoutData.OperatorCode; //经办人员 stockInOut.OperatorName = inoutData.Operator; stockInOut.InOutType = inoutData.InOutType; //oid赋值 stockInOut.TradeOrderCode = string.Empty; //付款方式 stockInOut.PayType = inoutData.PayType; //保存现金折扣 stockInOut.DiscountFee = float.Parse(inoutData.DiscountFee.ToString()); //保存应付应收金额 stockInOut.DueFee = float.Parse(inoutData.NeedToPay.ToString()); stockInOut.InOutStatus = inoutData.InOutStatus; stockInOut.IsSettled = true; stockInOut.PayThisTime = float.Parse(inoutData.PayThisTime.ToString()); stockInOut.PayTerm = inoutData.PayTerm; stockInOut.IncomeTime = inoutData.IncomeTime; stockInOut.AmountTax = float.Parse(inoutData.AmountTax.ToString()); stockInOut.FreightCompany = inoutData.FreightCompany; stockInOut.FreightCode = inoutData.FreightCode; stockInOutList.Add(stockInOut); #endregion #region 添加或更新PayCharge PayCharge payCharge = new PayCharge(); payCharge.PayChargeCode = Guid.NewGuid().ToString(); //付款收款方式 payCharge.PayChargeType = inoutData.InOutType; payCharge.InOutCode = inoutData.InOutCode; //付款人编号 payCharge.PayerCode = string.Empty; //付款人名字 payCharge.PayerName = string.Empty; //收款人编号 payCharge.ChargerCode = string.Empty; //收款人名字 payCharge.ChargerName = string.Empty; //操作时间 payCharge.OperateTime = DateTime.Parse(DateTime.Now.ToShortDateString()); payCharge.OperatorCode = inoutData.OperatorCode; payCharge.OperatorName = inoutData.Operator; payCharge.PayChargeRemark = string.Empty; payCharge.TotalFee = inoutData.TotalFee; payCharge.NeedToPay = inoutData.NeedToPay; payCharge.AmountTax = inoutData.AmountTax; payCharge.PayThisTime = inoutData.PayThisTime; payCharge.DiscountFee = inoutData.DiscountFee; payCharge.IncomeDay = inoutData.PayTerm; payCharge.IncomeTime = inoutData.IncomeTime; #endregion StockProductService.UpdateStock(stockProductList, stockHouseProList, stockInOutList, stockDetailList, payCharge, outerSkuIdList, outerIdList); return(true); }