/// <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> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (LiquidPlan != null) { LiquidPlan.CreateBy = ddlFSalesman.SelectedValue; LiquidPlan.FDate = txtFDate.SelectedDate; LiquidPlan.FDate4 = FDate4.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; //-------------------------------------------- LiquidPlan.FSupplierCode = txtFSupplierCode.Text; LiquidPlan.FSupplierName = tbxFSupplier.Text; LiquidPlan.FPurchasedDate = txtFPurchasedDate.Text; if (!string.IsNullOrEmpty(txtFGross.Text)) { LiquidPlan.FGross = Convert.ToDecimal(txtFGross.Text); } if (!string.IsNullOrEmpty(txtFPacked.Text)) { LiquidPlan.FPacked = Convert.ToDecimal(txtFPacked.Text); } if (!string.IsNullOrEmpty(tbxFPurchasedPrice.Text)) { LiquidPlan.FPurchasedPrice = Convert.ToDecimal(tbxFPurchasedPrice.Text); } if (!string.IsNullOrEmpty(tbxFPurchasedQty.Text)) { LiquidPlan.FPurchasedQty = Convert.ToDecimal(tbxFPurchasedQty.Text); } //------------------------------------ LiquidPlan.FCode1 = tbxFCode1.Text; LiquidPlan.FName1 = tbxFName1.Text; LiquidPlan.FDate1 = FDate1.SelectedDate; LiquidPlan.FTime1 = FTime1.Text; if (!string.IsNullOrEmpty(txtFGross1.Text)) { LiquidPlan.FGross1 = Convert.ToDecimal(txtFGross1.Text); } if (!string.IsNullOrEmpty(txtFPacked1.Text)) { LiquidPlan.FPacked1 = Convert.ToDecimal(txtFPacked1.Text); } if (!string.IsNullOrEmpty(txtFQty1.Text)) { LiquidPlan.FQty1 = Convert.ToDecimal(txtFQty1.Text); } if (!string.IsNullOrEmpty(txtFPrice1.Text)) { LiquidPlan.FPrice1 = Convert.ToDecimal(txtFPrice1.Text); } //------------------------------------ LiquidPlan.FCode2 = tbxFCode2.Text; LiquidPlan.FName2 = tbxFName2.Text; LiquidPlan.FDate2 = FDate2.SelectedDate; LiquidPlan.FTime2 = FTime2.Text; if (!string.IsNullOrEmpty(txtFGross2.Text)) { LiquidPlan.FGross2 = Convert.ToDecimal(txtFGross2.Text); } if (!string.IsNullOrEmpty(txtFPacked2.Text)) { LiquidPlan.FPacked2 = Convert.ToDecimal(txtFPacked2.Text); } if (!string.IsNullOrEmpty(txtFQty2.Text)) { LiquidPlan.FQty2 = Convert.ToDecimal(txtFQty2.Text); } if (!string.IsNullOrEmpty(txtFPrice2.Text)) { LiquidPlan.FPrice2 = Convert.ToDecimal(txtFPrice2.Text); } //------------------------------------ LiquidPlan.FCode3 = tbxFCode3.Text; LiquidPlan.FName3 = tbxFName3.Text; LiquidPlan.FDate3 = FDate3.SelectedDate; LiquidPlan.FTime3 = FTime3.Text; if (!string.IsNullOrEmpty(txtFGross3.Text)) { LiquidPlan.FGross3 = Convert.ToDecimal(txtFGross3.Text); } if (!string.IsNullOrEmpty(txtFPacked3.Text)) { LiquidPlan.FPacked3 = Convert.ToDecimal(txtFPacked3.Text); } if (!string.IsNullOrEmpty(txtFQty3.Text)) { LiquidPlan.FQty3 = Convert.ToDecimal(txtFQty3.Text); } if (!string.IsNullOrEmpty(txtFPrice3.Text)) { LiquidPlan.FPrice3 = Convert.ToDecimal(txtFPrice3.Text); } //////////////////////////////////////////// if (LiquidRefuel != null) { LiquidRefuel.FBeginAddress = txtFBeginAddress.Text; LiquidRefuel.FEndAddress = txtFEndAddress.Text; if (!string.IsNullOrEmpty(txtFBeginMileage.Text)) { LiquidRefuel.FBeginMileage = Convert.ToDecimal(txtFBeginMileage.Text); } if (!string.IsNullOrEmpty(txtFEndMileage.Text)) { LiquidRefuel.FEndMileage = Convert.ToDecimal(txtFEndMileage.Text); } if (!string.IsNullOrEmpty(txtFQty.Text)) { LiquidRefuel.FQty = Convert.ToDecimal(txtFQty.Text); } if (!string.IsNullOrEmpty(txtFPrice.Text)) { LiquidRefuel.FPrice = Convert.ToDecimal(txtFPrice.Text); } if (!string.IsNullOrEmpty(txtFAmount.Text)) { LiquidRefuel.FAmount = Convert.ToDecimal(txtFAmount.Text); } if (!string.IsNullOrEmpty(txtFOtherAmount.Text)) { LiquidRefuel.FOtherAmount = Convert.ToDecimal(txtFOtherAmount.Text); } LiquidRefuelService.SaveChanges(); } if (!string.IsNullOrEmpty(txtFMileage.Text)) { LiquidPlan.FMileage = Convert.ToDecimal(txtFMileage.Text); } LiquidPlan.FAmt = LiquidPlan.FPurchasedQty * LiquidPlan.FPurchasedPrice; LiquidPlan.FAmt1 = LiquidPlan.FPrice1 * LiquidPlan.FQty1; LiquidPlan.FAmt2 = LiquidPlan.FPrice2 * LiquidPlan.FQty2; LiquidPlan.FAmt3 = LiquidPlan.FPrice3 * LiquidPlan.FQty3; ////余量 //LiquidPlan.FMarginEnd = Convert.ToDecimal(tbxFMargin.Text) + Convert.ToDecimal(tbxFPurchasedQty.Text) // // - Convert.ToDecimal(txtFQty1.Text) - Convert.ToDecimal(txtFQty2.Text) - // Convert.ToDecimal(txtFQty3.Text); LiquidPlanService.SaveChanges(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyid", Key); SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms); return(true); } return(false); }
/// <summary> /// ModifiedGrid /// </summary> private void ModifiedGrid() { //编辑行事件 var dictModified = Grid1.GetModifiedDict(); foreach (var rowKey in dictModified.Keys) { string datakey = Grid1.DataKeys[rowKey][0].ToString(); var sKeys = new StringBuilder(); var sValues = new StringBuilder(); foreach (var key in dictModified[rowKey].Keys) { sKeys.AppendFormat("{0},", key); } foreach (var dictValue in dictModified[rowKey].Values) { sValues.AppendFormat("{0},", dictValue); } if (sValues.ToString().Contains("-1")) { Alert.Show("请输入有效信息!", MessageBoxIcon.Warning); return; } var details = LiquidPlanService.Where(p => p.KeyId == datakey && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); var keys = sKeys.ToString().Split(','); var values = sValues.ToString().Split(','); 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 Edit 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); } if (key.Equals("FPurchasedQty")) { details.FPurchasedQty = Convert.ToDecimal(value); } if (key.Equals("FPurchasedPQty")) { details.FPurchasedPQty = Convert.ToDecimal(value); } //-------------------------------------- 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); } if (key.Equals("FPQty1")) { details.FPQty1 = Convert.ToDecimal(value); } if (key.Equals("FQty1")) { details.FQty1 = Convert.ToDecimal(value); } //-------------------- 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); } if (key.Equals("FQty2")) { details.FQty2 = Convert.ToDecimal(value); } if (key.Equals("FPQty2")) { details.FPQty2 = Convert.ToDecimal(value); } //-------------------- 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); } if (key.Equals("FPQty3")) { details.FPQty3 = Convert.ToDecimal(value); } if (key.Equals("FQty3")) { details.FQty3 = Convert.ToDecimal(value); } //-------------------- if (key.Equals("FMarginEnd")) { details.FMarginEnd = Convert.ToDecimal(value); } if (key.Equals("FMemo")) { details.FMemo = value; } #endregion } } #endregion } LiquidPlanService.SaveChanges(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyid", datakey); SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms); } }
/// <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(); }
/// <summary> /// Grid1_RowCommand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { var commandName = e.CommandName; var datakey = Grid1.DataKeys[e.RowIndex][0].ToString(); switch (commandName) { case "Delete": LiquidPlanService.Delete(p => p.KeyId == datakey && p.FCompanyId == CurrentUser.AccountComId); Alert.Show("删除成功。", MessageBoxIcon.Information); break; case "Pound": PageContext.RegisterStartupScript( Window1.GetShowReference(string.Format("./PoundEdit.aspx?KeyId={0}&action=2", datakey), "填写磅单")); break; case "Submit": var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyId", datakey); SqlService.ExecuteProcedureCommand("proc_LiquidPlan", parms); Alert.Show("磅单成功。", MessageBoxIcon.Information); break; case "To": var dataqty = Grid1.DataKeys[e.RowIndex][1].ToString(); var to = LiquidToService.FirstOrDefault( p => p.XCompanyId == CurrentUser.AccountComId && p.XKeyId == datakey); if (to != null) { PageContext.RegisterStartupScript( Window4.GetShowReference(string.Format("./LiquidTo.aspx?KeyId={0}&qty={1}&action=2", datakey, dataqty), "导气")); } else { PageContext.RegisterStartupScript( Window4.GetShowReference(string.Format("./LiquidTo.aspx?KeyId={0}&qty={1}&action=1", datakey, dataqty), "导气")); } //var parmsTo = new Dictionary<string, object>(); //parmsTo.Clear(); //parmsTo.Add("@companyId", CurrentUser.AccountComId); //parmsTo.Add("@KeyId", datakey); //SqlService.ExecuteProcedureCommand("proc_LiquidTo",parmsTo); break; } BindDataGrid(); }