/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var liquidPlan = new LHLiquidPlan { CreateBy = CurrentUser.AccountName }; return(LiquidPlanService.Add(liquidPlan)); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var liquidPlan = new LHLiquidPlan(); string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), // "LP", CurrentUser.AccountComId); liquidPlan.FCompanyId = CurrentUser.AccountComId; liquidPlan.KeyId = newKeyId; liquidPlan.CreateBy = CurrentUser.AccountName; liquidPlan.FDate = txtFDate.SelectedDate; liquidPlan.FItemCode = tbxFItemName.SelectedValue; liquidPlan.FItemName = tbxFItemName.SelectedText; liquidPlan.FBill = tbxFBill.SelectedValue; liquidPlan.FVehicleNum = tbxFVehicleNum.SelectedValue; liquidPlan.FDriver = GasHelper.GetDropDownListArrayString(tbxFDriver.SelectedItemArray); liquidPlan.FSupercargo = tbxFSupercargo.SelectedValue; liquidPlan.FMargin = Convert.ToDecimal(tbxFMargin.Text); liquidPlan.FMemo = txtFMemo.Text; LiquidPlanService.Add(liquidPlan); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyId", newKeyId); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyId1", Grid1SelectIds()); parms.Add("@keyId2", Grid2SelectIds().ToList()[0]); parms.Add("@keyId3", Grid2SelectIds().ToList()[1]); parms.Add("@keyId4", Grid2SelectIds().ToList()[2]); SqlService.ExecuteProcedureCommand("proc_LiquidPlanMergeProc", parms); return(true); }
/// <summary> /// AddListGrid /// </summary> private void AddListGrid() { //新增行事件 var dictList = Grid1.GetNewAddedList(); foreach (var rowKey in dictList) { var sKeys = new StringBuilder(); var sValues = new StringBuilder(); foreach (var key in rowKey.Keys) { sKeys.AppendFormat("{0},", key); } foreach (var dictValue in rowKey.Values) { sValues.AppendFormat("{0},", dictValue); } var keys = sKeys.ToString().Split(','); var values = sValues.ToString().Split(','); var details = new LHLiquidPlan(); for (int i = 0; i < keys.Count(); i++) { #region 修改内容 var key = keys[i]; var value = values[i]; if (!string.IsNullOrEmpty(key) && key.Length > 0) { if (details != null) { #region Add if (key.Equals("KeyId")) { details.KeyId = value; } if (key.Equals("FDate")) { details.FDate = Convert.ToDateTime(value); } if (key.Equals("FItemName"))//产品 { details.FItemCode = value; if (!string.IsNullOrEmpty(value)) { details.FItemName = ItemsService.FirstOrDefault( p => p.FCode == value && p.FCompanyId == CurrentUser.AccountComId).FName; } } if (key.Equals("FBill")) { details.FBill = value; } //if (key.Equals("FDriver")) //{ // details.FDriver = value; //} if (key.Equals("FSupercargo")) { details.FSupercargo = value; } if (key.Equals("FVehicleNum")) { details.FVehicleNum = value; if (value != null && !string.IsNullOrEmpty(value)) { var vehicle = new VehicleService().FirstOrDefault(p => p.FNum == value); details.FMargin = Convert.ToDecimal(vehicle.FMargin); } } //if (key.Equals("FMargin")) //{ // details.FMargin = Convert.ToDecimal(value); //} if (key.Equals("FPurchasedDate")) { details.FPurchasedDate = value; } if (key.Equals("FSupplierName")) { details.FSupplierCode = value; if (!string.IsNullOrEmpty(value)) { details.FSupplierName = SupplierService.FirstOrDefault( p => p.FCode == value && p.FCompanyId == CurrentUser.AccountComId).FName; } } if (key.Equals("FPurchasedPrice")) { details.FPurchasedPrice = Convert.ToDecimal(value); details.FAmt = details.FPurchasedPrice * details.FPurchasedQty; } if (key.Equals("FPurchasedQty")) { details.FPurchasedQty = Convert.ToDecimal(value); details.FAmt = details.FPurchasedPrice * details.FPurchasedQty; } //-------------------------------------- if (key.Equals("FDate1")) { details.FDate1 = Convert.ToDateTime(value); } if (key.Equals("FName1")) { details.FCode1 = value; if (!string.IsNullOrEmpty(value)) { details.FName1 = CustomerService.FirstOrDefault( p => p.FCode == value && p.FCompanyId == CurrentUser.AccountComId).FName; } } if (key.Equals("FPrice1")) { details.FPrice1 = Convert.ToDecimal(value); details.FAmt1 = details.FPrice1 * details.FQty1; } if (key.Equals("FQty1")) { details.FQty1 = Convert.ToDecimal(value); details.FAmt1 = details.FPrice1 * details.FQty1; } //-------------------- if (key.Equals("FDate2")) { details.FDate2 = Convert.ToDateTime(value); } if (key.Equals("FName2")) { details.FCode2 = value; if (!string.IsNullOrEmpty(value)) { details.FName2 = CustomerService.FirstOrDefault( p => p.FCode == value && p.FCompanyId == CurrentUser.AccountComId).FName; } } if (key.Equals("FPrice2")) { details.FPrice2 = Convert.ToDecimal(value); details.FAmt2 = details.FPrice2 * details.FQty2; } if (key.Equals("FQty2")) { details.FQty2 = Convert.ToDecimal(value); details.FAmt2 = details.FPrice2 * details.FQty2; } //-------------------- if (key.Equals("FDat3")) { details.FDate3 = Convert.ToDateTime(value); } if (key.Equals("FName3")) { details.FCode3 = value; if (!string.IsNullOrEmpty(value)) { details.FName3 = CustomerService.FirstOrDefault( p => p.FCode == value && p.FCompanyId == CurrentUser.AccountComId).FName; } } if (key.Equals("FPrice3")) { details.FPrice3 = Convert.ToDecimal(value); details.FAmt3 = details.FPrice3 * details.FQty3; } if (key.Equals("FQty3")) { details.FQty3 = Convert.ToDecimal(value); details.FAmt3 = details.FPrice3 * details.FQty3; } //-------------------- if (key.Equals("FMarginEnd")) { details.FMarginEnd = Convert.ToDecimal(value); } if (key.Equals("FMemo")) { details.FMemo = value; } #endregion } } #endregion } string keyId = SequenceService.CreateSequence(Convert.ToDateTime(details.FDate), "LP", CurrentUser.AccountComId); details.KeyId = keyId; details.FDeleteFlag = 0; details.FType = 26; details.FFlag = 1; details.CreateBy = CurrentUser.AccountName; details.FStatus = 10; details.FCompanyId = CurrentUser.AccountComId; LiquidPlanService.Add(details); var refuel = new LHLiquidRefuel { FFlag = 1, CreateBy = CurrentUser.AccountName, FDate = details.FDate, KeyId = details.KeyId, FCompanyId = CurrentUser.AccountComId }; LiquidRefuelService.Add(refuel); } Grid1.CommitChanges(); }