private void calEffect(IList <Model.AcPaymentDetail> acPaymentDetail) { foreach (Model.AcPaymentDetail item in acPaymentDetail) { if (String.IsNullOrEmpty(item.AcInvoiceId)) { continue; } if (item.AcInvoiceType == "採購發票單") { Model.AcInvoiceCOBill cobill = acInvoiceCOBillaccessor.Get(item.AcInvoiceId); if (cobill == null) { continue; } cobill.mHeXiaoJingE = cobill.mHeXiaoJingE == null ? 0 : cobill.mHeXiaoJingE - item.DomesticThisChargeMoney; cobill.NoHeXiaoTotal = cobill.ZongMoney - cobill.mHeXiaoJingE; acInvoiceCOBillaccessor.Update(cobill); } else if (item.AcInvoiceType == "其它應付款") { Model.AcOtherShouldPayment acoSP = acOtherShouldPaymentAccessor.Get(item.AcInvoiceId); if (acoSP == null) { continue; } acoSP.mHeXiaoJingE = acoSP.mHeXiaoJingE == null ? 0 : acoSP.mHeXiaoJingE - item.DomesticThisChargeMoney; acoSP.NoHeXiaoTotal = acoSP.HeJi - acoSP.mHeXiaoJingE; acOtherShouldPaymentAccessor.Update(acoSP); } } }
private void addDetail(Model.AcPayment acPayment) { foreach (Model.AcPaymentDetail item in acPayment.Detail) { if (String.IsNullOrEmpty(item.AcInvoiceId)) { continue; } item.AcPaymentId = acPayment.AcPaymentId; if (item.AcInvoiceType == "採購發票單") { Model.AcInvoiceCOBill cobill = acInvoiceCOBillaccessor.Get(item.AcInvoiceId); if (cobill == null) { goto mustdo; } cobill.mHeXiaoJingE = cobill.mHeXiaoJingE == null ? 0 : cobill.mHeXiaoJingE + item.DomesticThisChargeMoney; cobill.NoHeXiaoTotal = cobill.ZongMoney - cobill.mHeXiaoJingE; acInvoiceCOBillaccessor.Update(cobill); } else if (item.AcInvoiceType == "其它應付款") { Model.AcOtherShouldPayment acoSP = acOtherShouldPaymentAccessor.Get(item.AcInvoiceId); if (acoSP == null) { goto mustdo; } acoSP.mHeXiaoJingE = acoSP.mHeXiaoJingE == null ? 0 : acoSP.mHeXiaoJingE + item.DomesticThisChargeMoney; acoSP.NoHeXiaoTotal = acoSP.HeJi - acoSP.mHeXiaoJingE; acOtherShouldPaymentAccessor.Update(acoSP); } mustdo: acPaymentDetailaccessor.Insert(item); } }
/// <summary> /// 尾笔 /// </summary> protected override void MoveLast() { // if (_acbeginAccountPayble == null) { this._acInvoiceCoBill = this._acInvoiceCoBillManager.Get(this._acInvoiceCoBillManager.GetLast() == null ? "" : this._acInvoiceCoBillManager.GetLast().AcInvoiceCOBillId); } }
public bool ExistsExcept(Model.AcInvoiceCOBill e) { Hashtable paras = new Hashtable(); paras.Add("newId", e.Id); paras.Add("oldId", Get(e.AcInvoiceCOBillId) == null?null:Get(e.AcInvoiceCOBillId).Id); return(sqlmapper.QueryForObject <bool>("AcInvoiceCOBill.existsexcept", paras)); }
protected override void MoveNext() { Model.AcInvoiceCOBill temp = this._acInvoiceCoBillManager.GetNext(this._acInvoiceCoBill); if (temp == null) { throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows); } this._acInvoiceCoBill = this._acInvoiceCoBillManager.Get(temp.AcInvoiceCOBillId); }
public Model.AcInvoiceCOBill GetDetails(Model.AcInvoiceCOBill acInvoiceCoBill) { Model.AcInvoiceCOBill temp = accessor.Get(acInvoiceCoBill.AcInvoiceCOBillId); if (temp != null) { temp.Details = accessorDetails.SelectByAcInvoiceCOBill(temp); } return(temp); }
public void _Update(Model.AcInvoiceCOBill acInvoiceCOBill) { acInvoiceCOBill.UpdateTime = DateTime.Now; accessor.Update(acInvoiceCOBill); IList <Model.AcInvoiceCOBillDetail> olddetail = accessorDetails.SelectByAcInvoiceCOBill(acInvoiceCOBill); calEffect(olddetail); accessorDetails.Delete(acInvoiceCOBill); addDetail(acInvoiceCOBill); }
protected override void AddNew() { this._acInvoiceCoBill = new Model.AcInvoiceCOBill(); this._acInvoiceCoBill.AcInvoiceCOBillId = this._acInvoiceCoBillManager.GetId(); //this._acInvoiceCoBill.Id = this._acInvoiceCoBillManager.GetId(); this._acInvoiceCoBill.AcInvoiceCOBillDate = DateTime.Now; this._acInvoiceCoBill.Employee = BL.V.ActiveOperator.Employee; this._acInvoiceCoBill.TaxRateType = 1; this._acInvoiceCoBill.TaxRate = 5; this._acInvoiceCoBill.Details = new List <Model.AcInvoiceCOBillDetail>(); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { ListForm lf = new ListForm(); if (lf.ShowDialog(this) == DialogResult.OK) { this._acInvoiceCoBill = (Model.AcInvoiceCOBill)lf.SelectItem; this.action = "view"; this.Refresh(); } lf.Dispose(); GC.Collect(); }
public override void Refresh() { if (this._acInvoiceCoBill == null) { this.AddNew(); this.action = "insert"; } else { if (this.action == "view") { this._acInvoiceCoBill = this._acInvoiceCoBillManager.GetDetails(this._acInvoiceCoBill); } } this.AcInvoiceCOBillId.Text = this._acInvoiceCoBill.AcInvoiceCOBillId; this.textId.Text = this._acInvoiceCoBill.Id; this.HeJiMoney.Value = this._acInvoiceCoBill.HeJiMoney == null ? 0 : this._acInvoiceCoBill.HeJiMoney.Value; this.calcTaxRate.Value = this._acInvoiceCoBill.TaxRate == null ? 0 : Convert.ToDecimal(this._acInvoiceCoBill.TaxRate.Value); this.calcmHeXiaoJingE.Value = this._acInvoiceCoBill.mHeXiaoJingE == null ? 0 : this.calcmHeXiaoJingE.Value; this.calcNoHeXiaoTotal.Value = this._acInvoiceCoBill.NoHeXiaoTotal == null ? 0 : this.calcNoHeXiaoTotal.Value; this.TaxType.SelectedIndex = Convert.ToInt32(this._acInvoiceCoBill.TaxRateType); this.TaxRateMoney.Value = this._acInvoiceCoBill.TaxRateMoney == null ? 0 : this._acInvoiceCoBill.TaxRateMoney.Value; this.ZongMoney.Value = this._acInvoiceCoBill.ZongMoney == null ? 0 : this._acInvoiceCoBill.ZongMoney.Value; this.newChooseEmployee0Id.EditValue = this._acInvoiceCoBill.AuditEmp; // this.newChooseEmployee1Id.EditValue = this._acInvoiceCoBill.Employee1; this.newChooseEmployeeId.EditValue = this._acInvoiceCoBill.Employee; this.newChooseSup_SupplierId.EditValue = this._acInvoiceCoBill.Sup_Supplier; this.newChooseSupplierId.EditValue = this._acInvoiceCoBill.Supplier; this.memoAcInvoiceCOBillDesc.Text = this._acInvoiceCoBill.AcInvoiceCOBillDesc; this.dateAcInvoiceCOBillDate.DateTime = this._acInvoiceCoBill.AcInvoiceCOBillDate.Value; this.txt_AuditState.EditValue = this.GetAuditName(this._acInvoiceCoBill.AuditState); this.bindingSourceDetails.DataSource = this._acInvoiceCoBill.Details; base.Refresh(); //if (this.action == "view") //{ // this.barBtnJinHuoDan.Enabled = false; //} //else //{ // this.barBtnJinHuoDan.Enabled = true; //} this.newChooseEmployeeId.Enabled = false; //this.HeJiMoney.Enabled = false; this.ZongMoney.Enabled = false; this.TaxRateMoney.Enabled = false; this.calcmHeXiaoJingE.Enabled = false; this.calcNoHeXiaoTotal.Enabled = false; }
private void Validate(Model.AcInvoiceCOBill acInvoiceCOBill) { if (string.IsNullOrEmpty(acInvoiceCOBill.Id)) { throw new global::Helper.RequireValueException(Model.AcInvoiceCOBill.PRO_Id); } if (string.IsNullOrEmpty(acInvoiceCOBill.SupplierId)) { throw new global::Helper.RequireValueException(Model.AcInvoiceCOBill.PRO_SupplierId); } if (acInvoiceCOBill.Details == null || acInvoiceCOBill.Details.Count == 0) { throw new global::Helper.RequireValueException("AcInvoiceCOBill.Details"); } }
private void addDetail(Model.AcInvoiceCOBill acInvoiceCOBill) { foreach (Model.AcInvoiceCOBillDetail item in acInvoiceCOBill.Details) { item.AcInvoiceCOBillId = acInvoiceCOBill.AcInvoiceCOBillId; accessorDetails.Insert(item); //更新进货详细 Model.InvoiceCGDetail icgd = mInvoiceCGDetailAccessor.Get(item.InvoiceCGDetailId); if (icgd != null) { icgd.InvoiceCGDetailFPQuantity = Convert.ToDouble(icgd.InvoiceCGDetailFPQuantity) + Convert.ToDouble(item.InvoiceCGDetaiInQuantity); } mInvoiceCGDetailAccessor.Update(icgd); } }
public void Update(Model.AcInvoiceCOBill acInvoiceCOBill) { Validate(acInvoiceCOBill); try { BL.V.BeginTransaction(); _Update(acInvoiceCOBill); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
/// <summary> /// Insert a AcInvoiceCOBill. /// </summary> public void Insert(Model.AcInvoiceCOBill acInvoiceCOBill) { Validate(acInvoiceCOBill); try { acInvoiceCOBill.InsertTime = DateTime.Now; TiGuiExists(acInvoiceCOBill); acInvoiceCOBill.UpdateTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acInvoiceCOBill.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acInvoiceCOBill.InsertTime.Value.Year, acInvoiceCOBill.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acInvoiceCOBill.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); accessor.Insert(acInvoiceCOBill); foreach (Model.AcInvoiceCOBillDetail item in acInvoiceCOBill.Details) { item.AcInvoiceCOBillId = acInvoiceCOBill.AcInvoiceCOBillId; accessorDetails.Insert(item); //更新进货详细 Model.InvoiceCGDetail icgd = mInvoiceCGDetailAccessor.Get(item.InvoiceCGDetailId); if (icgd != null) { icgd.InvoiceCGDetailFPQuantity = Convert.ToDouble(icgd.InvoiceCGDetailFPQuantity) + Convert.ToDouble(item.InvoiceCGDetaiInQuantity); } mInvoiceCGDetailAccessor.Update(icgd); } BL.V.CommitTransaction(); } finally { BL.V.RollbackTransaction(); } }
public void Delete(Model.AcInvoiceCOBill acInvoiceCOBill) { try { BL.V.BeginTransaction(); calEffect(acInvoiceCOBill.Details); accessorDetails.Delete(acInvoiceCOBill); this.Delete(acInvoiceCOBill.AcInvoiceCOBillId); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
private void TiGuiExists(Model.AcInvoiceCOBill model) { if (this.ExistsPrimary(model.AcInvoiceCOBillId)) { //设置KEY值 string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InsertTime.Value.Year, model.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd")); string sequencekey = string.Format(invoiceKind); SequenceManager.Increment(sequencekey_y); SequenceManager.Increment(sequencekey_m); SequenceManager.Increment(sequencekey_d); SequenceManager.Increment(sequencekey); model.AcInvoiceCOBillId = this.GetId(model.InsertTime.Value); TiGuiExists(model); } }
protected override void Delete() { if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } try { this._acInvoiceCoBillManager.Delete(this._acInvoiceCoBill); this._acInvoiceCoBill = this._acInvoiceCoBillManager.GetNext(this._acInvoiceCoBill); if (this._acInvoiceCoBill == null) { this._acInvoiceCoBill = this._acInvoiceCoBillManager.GetLast(); } } catch { throw; } }
public Ro(Model.AcInvoiceCOBill acInvoiceCOBill) { InitializeComponent(); //报表标题 this.ReportName.Text = BL.Settings.CompanyChineseName; //报表标题 this.ReportTitle.Text = Properties.Resources.AcInvoiceCOBill; //列印日期 this.ReportDate.Text += System.DateTime.Now.ToShortDateString(); //头资料 this.Id.Text = acInvoiceCOBill.Id; this.AcInvoiceCOBillId.Text = acInvoiceCOBill.AcInvoiceCOBillId; this.AcInvoiceCOBillDate.Text = acInvoiceCOBill.AcInvoiceCOBillDate.Value.ToString("yyyy-MM-dd"); this.AcInvoiceCOBillDesc.Text = acInvoiceCOBill.AcInvoiceCOBillDesc; this.Employee.Text = string.IsNullOrEmpty(acInvoiceCOBill.EmployeeId) ? "" : acInvoiceCOBill.Employee.ToString(); this.Employee0.Text = string.IsNullOrEmpty(acInvoiceCOBill.Employee1Id) ? "" : acInvoiceCOBill.Employee1.ToString(); this.Employee1.Text = string.IsNullOrEmpty(acInvoiceCOBill.Employee0Id) ? "" : acInvoiceCOBill.Employee0.ToString(); this.Supplier.Text = acInvoiceCOBill.Supplier.ToString(); this.Sup_Supplier.Text = string.IsNullOrEmpty(acInvoiceCOBill.Sup_SupplierId) ? "" : acInvoiceCOBill.Sup_Supplier.ToString(); this.TaxRate.Text = acInvoiceCOBill.TaxRate.ToString(); this.TaxRateType.Text = acInvoiceCOBill.TaxRateType.ToString(); this.TaxRateMoney.Text = acInvoiceCOBill.TaxRateMoney.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value)); this.ZongMoney.Text = acInvoiceCOBill.ZongMoney.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value)); this.lblmHeXiaoJingE.Text = acInvoiceCOBill.mHeXiaoJingE.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value)); this.lblNoHeXiaoTotal.Text = acInvoiceCOBill.NoHeXiaoTotal.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value)); //绑定详细数据源 this.DataSource = acInvoiceCOBill.Details; //详细资料 this.CellInvoiceId.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceId); this.CellInvoiceAllowance.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceAllowance); this.CellProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName); this.CellInvoiceCGDetaiInQuantity.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetaiInQuantity); this.CellInvoiceCGDetailMoney.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetailMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value)); this.CellInvoiceCGDetailPrice.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetailPrice, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSDJXiao.Value)); this.CellInvoiceCGDetailTax.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetailTax); this.CellInvoiceCGDetailTaxMoney.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetailTaxMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value)); this.CellInvoiceCGDetailTaxPrice.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceCOBillDetail.PRO_InvoiceCGDetailTaxPrice, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSDJXiao.Value)); }
public void Insert(Model.AcInvoiceCOBill e) { this.Insert <Model.AcInvoiceCOBill>(e); }
public Model.AcInvoiceCOBill GetNext(Model.AcInvoiceCOBill e) { return(sqlmapper.QueryForObject <Model.AcInvoiceCOBill>("AcInvoiceCOBill.get_next", e)); }
public Model.AcInvoiceCOBill GetPrev(Model.AcInvoiceCOBill e) { return(sqlmapper.QueryForObject <Model.AcInvoiceCOBill>("AcInvoiceCOBill.get_prev", e)); }
public bool HasRowsAfter(Model.AcInvoiceCOBill e) { return(sqlmapper.QueryForObject <bool>("AcInvoiceCOBill.has_rows_after", e)); }
public bool HasRowsBefore(Model.AcInvoiceCOBill e) { return(sqlmapper.QueryForObject <bool>("AcInvoiceCOBill.has_rows_before", e)); }
public IList <Model.AcInvoiceCOBillDetail> SelectByAcInvoiceCOBill(Model.AcInvoiceCOBill acInvoiceCoBill) { return(sqlmapper.QueryForList <Model.AcInvoiceCOBillDetail>("AcInvoiceCOBillDetail.selectByAcInvoiceCOBill", acInvoiceCoBill.AcInvoiceCOBillId)); }
protected override void MoveFirst() { this._acInvoiceCoBill = this._acInvoiceCoBillManager.Get(this._acInvoiceCoBillManager.GetFirst() == null ? "" : this._acInvoiceCoBillManager.GetFirst().AcInvoiceCOBillId); }
public Model.AcInvoiceCOBill GetNext(Model.AcInvoiceCOBill e) { return(accessor.GetNext(e)); }
public void Delete(Model.AcInvoiceCOBill acInvoiceCoBill) { sqlmapper.Delete("AcInvoiceCOBillDetail.delete_detail_AcinvoiceCoBilID", acInvoiceCoBill.AcInvoiceCOBillId); }
public void Update(Model.AcInvoiceCOBill e) { this.Update <Model.AcInvoiceCOBill>(e); }
public IList <Model.AcInvoiceCOBillDetail> SelectByAcInvoiceCOBill(Model.AcInvoiceCOBill acInvoiceCoBill) { return(accessor.SelectByAcInvoiceCOBill(acInvoiceCoBill)); }
public Model.AcInvoiceCOBill GetPrev(Model.AcInvoiceCOBill e) { return(accessor.GetPrev(e)); }