/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (To != null) { To.XBill = ddlBill.SelectedValue; if (!string.IsNullOrEmpty(tbxFVehicleNum.Text)) { To.XVehicleNum = tbxFVehicleNum.Text; To.XTo = tbxFVehicleNum.Text; } if (!string.IsNullOrEmpty(txtFMarginEnd.Text)) { To.XMarginEnd = string.IsNullOrEmpty(txtFMarginEnd.Text) ? 0 : Convert.ToDecimal(txtFMarginEnd.Text); } if (!string.IsNullOrEmpty(txtFQty.Text)) { To.XQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text); } To.XMemo = txtFMemo.Text; To.XFDate = DateTime.Now; To.XCreateBy = CurrentUser.AccountName; LiquidToService.SaveChanges(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyid", KeyId); SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms); var parmsTo = new Dictionary <string, object>(); parmsTo.Clear(); parmsTo.Add("@companyId", CurrentUser.AccountComId); parmsTo.Add("@KeyId", KeyId); SqlService.ExecuteProcedureCommand("proc_LiquidTo", parmsTo); return(true); } return(false); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var its = new LHLiquidTo { XKeyId = KeyId, XCompanyId = CurrentUser.AccountComId, XBill = ddlBill.SelectedValue }; if (!string.IsNullOrEmpty(tbxFVehicleNum.SelectedValue)) { its.XTo = tbxFVehicleNum.SelectedValue; } if (!string.IsNullOrEmpty(txtFMarginEnd.Text)) { its.XMarginEnd = string.IsNullOrEmpty(txtFMarginEnd.Text) ? 0 : Convert.ToDecimal(txtFMarginEnd.Text); } if (!string.IsNullOrEmpty(txtFQty.Text)) { its.XQty = string.IsNullOrEmpty(txtFQty.Text) ? 0 : Convert.ToDecimal(txtFQty.Text); } its.XMemo = txtFMemo.Text; LiquidToService.Add(its); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@companyId", CurrentUser.AccountComId); parms.Add("@keyid", KeyId); SqlService.ExecuteProcedureCommand("proc_LiquidMargin", parms); var parmsTo = new Dictionary <string, object>(); parmsTo.Clear(); parmsTo.Add("@companyId", CurrentUser.AccountComId); parmsTo.Add("@KeyId", KeyId); SqlService.ExecuteProcedureCommand("proc_LiquidTo", parmsTo); return(true); }
/// <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(); }