/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockOut != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// StockOut.FCode = txtFCode.Text; StockOut.FName = tbxFCustomer.Text; //------------------------------------------------------ StockOut.FCompanyId = CurrentUser.AccountComId; StockOut.FMemo = txtFMemo.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockOut.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_MonthInitQty", parms).Tables[0].Rows[0][0]); StockOut.FAmount = amt; StockOut.FDate = txtFDate.SelectedDate; return(InitMonthServie.SaveChanges() >= 0); } return(false); }
/// <summary> /// 加载页面数据 /// </summary> private void LoadData() { switch (Actions) { case WebAction.Add: txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId); Region3.Title = "调整客户代码期初占用钢瓶单"; var temp = new LHInitMonth { KeyId = txtKeyId.Text, FFlag = 1, FDeleteFlag = 1, //调整客户代码期初占用钢瓶单 FType = Convert.ToInt32(GasEnumBill.ChangeAccount), CreateBy = CurrentUser.AccountName, FDate = txtFDate.SelectedDate, FCompanyId = CurrentUser.AccountComId, FStatus = Convert.ToInt32(GasEnumBillStauts.Add), }; //临时写入单据 InitMonthServie.Add(temp); //合计 //var summary = new JObject //{ // {"FItemCode", "合计"}, // {"FQty", 0}, //}; //Grid1.SummaryData = summary; break; case WebAction.Edit: txtKeyId.Text = KeyId; Region3.Title = "编辑调整客户代码期初占用钢瓶单"; if (StockOut != null) { WebControlHandler.BindObjectToControls(StockOut, SimpleForm1); txtFDate.SelectedDate = StockOut.FDate; tbxFCustomer.Text = StockOut.FName; txtFAmount.Text = StockOut.FAmount.ToString(); BindDataGrid(); } break; } }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = InitMonthServie.Where(p => p.KeyId == txtKeyId.Text.Trim()).FirstOrDefault(); if (stock != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; //-------------------------------------------------- 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_MonthInitQty", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FDate = txtFDate.SelectedDate; stock.FAmt = 0; stock.FCate = hfdUnit.Text; stock.FDate = txtFDate.SelectedDate; InitMonthServie.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "TB", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "23"); 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); }