/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var order = SKOrderService.Where(p => p.keyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (order != null) { order.FCode = txtFCode.Text; order.FName = tbxFCustomer.Text; //-------------------------------------------------- order.FDeleteFlag = 0; order.FMemo = txtFMemo.Text.Trim(); order.CreateBy = CurrentUser.AccountName; order.FDate = txtFDate.SelectedDate; order.FAbstract = ddlFAbstract.SelectedValue; order.FDate = txtFDate.SelectedDate; //order.FVerificationFlag = 0;//未核销的 var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@KeyId", txtKeyId.Text.Trim()); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SKOrderAmt", parms).Tables[0].Rows[0][0]); order.FAmount = amt; SKOrderService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "SK", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "12"); 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); }
/// <summary> /// 加载页面数据 /// </summary> private void LoadData() { switch (Actions) { case WebAction.Add: Region1.Title = "添加收款单"; txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId); var temp = new LHSKOrder { keyId = txtKeyId.Text, FFlag = 1, FDeleteFlag = 1, //发货单 //FType = Convert.ToInt32(GasEnumBill.Receipt), CreateBy = CurrentUser.AccountName, FDate = txtFDate.SelectedDate, FAmount = 0, FCate = "客户", FCompanyId = CurrentUser.AccountComId //F = CurrentUser.AccountComId, //FStatus = Convert.ToInt32(GasEnumBillStauts.Add), //FProgress = Convert.ToInt32(GasEnumBillStauts.Add), }; //临时写入单据 SKOrderService.Add(temp); var summary = new JObject { { "FCode", "合计" }, { "FAmt", 0 }, }; Grid1.SummaryData = summary; break; case WebAction.Edit: txtKeyId.Text = KeyId; Region1.Title = "编辑收款单"; if (SkOrder != null) { txtFCode.Text = SkOrder.FCode; tbxFCustomer.Text = SkOrder.FName; ddlFAbstract.SelectedValue = SkOrder.FAbstract; txtFMemo.Text = SkOrder.FMemo; BindDataGrid(); } break; } }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (SkOrder != null) { SkOrder.FCode = txtFCode.Text; SkOrder.FName = tbxFCustomer.Text; SkOrder.FAbstract = ddlFAbstract.SelectedValue; //------------------------------------------------------ SkOrder.FDate = txtFDate.SelectedDate; //StockOut.FAddress = txtFAddress.Text.Trim(); //CollectionOrder.FCompanyId = CurrentUser.AccountComId; //StockOut.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; //StockOut.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; //StockOut.FFlag = 1; //StockOut.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); //StockOut.FLinkman = txtFLinkman.Text.Trim(); SkOrder.FMemo = txtFMemo.Text.Trim(); //StockOut.FPhone = txtFPhone.Text.Trim(); //var parms = new Dictionary<string, object>(); //parms.Clear(); //parms.Add("@keyID", CollectionOrder.keyId); //var amt = // Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]); //CollectionOrder.FAmount = amt; //if (ddlFSupercargo.SelectedItem != null) //{ // var texts = new List<string>(); // foreach (ListItem item in ddlFSupercargo.SelectedItemArray) // { // texts.Add(item.Text); // } // if (!string.IsNullOrEmpty(String.Join(",", texts.ToArray()))) // { // StockOut.FSupercargo = String.Join(",", texts.ToArray()); // } //} //if (ddlFDriver.SelectedItem != null) //{ // var texts = new List<string>(); // foreach (ListItem item in ddlFDriver.SelectedItemArray) // { // texts.Add(item.Text); // } // if (!string.IsNullOrEmpty(String.Join(",", texts.ToArray()))) // { // StockOut.FDriver = String.Join(",", texts.ToArray()); // } //} var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@KeyId", txtKeyId.Text.Trim()); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SKOrderAmt", parms).Tables[0].Rows[0][0]); SkOrder.FAmount = amt; SkOrder.CreateBy = CurrentUser.AccountName; return(SKOrderService.SaveChanges() >= 0); } return(false); }