/// <summary> /// Update a AcItem. /// </summary> public void Update(Model.AcItem acItem) { // // todo: add other logic here. // accessor.Update(acItem); }
/// <summary> /// Insert a AcItem. /// </summary> public void Insert(Model.AcItem acItem) { // // todo:add other logic here // accessor.Insert(acItem); }
public bool ExistsExcept(Model.AcItem e) { Hashtable paras = new Hashtable(); paras.Add("newId", e.Id); paras.Add("oldId", Get(e.AcItemId) == null?null:Get(e.AcItemId).Id); return(sqlmapper.QueryForObject <bool>("AcItem.existsexcept", paras)); }
private void simpleButtonA_Click(object sender, EventArgs e) { APParameterSet.ChooseAcItem f = new Book.UI.AccountPayable.APParameterSet.ChooseAcItem(); if (f.ShowDialog(this) == DialogResult.OK) { Model.AcOtherShouldPaymentDetail detail = new Book.Model.AcOtherShouldPaymentDetail(); Model.AcItem acitem = f.SelectedItem as Model.AcItem; detail.AcOtherShouldPaymentDetailId = Guid.NewGuid().ToString(); detail.AcOtherShouldPaymentId = this.AcOtherShouldPayment.AcOtherShouldPaymentId; detail.LoanName = acitem.ItemName; detail.AcQuantity = 0; detail.AcMoney = 0; detail.AcItemPrice = acitem.ItemPrice; detail.AcItemId = acitem.AcItemId; this.AcOtherShouldPayment.Details.Add(detail); this.gridControl1.RefreshDataSource(); this.bindingSource1.Position = this.bindingSource1.IndexOf(detail); } //Model.AcOtherShouldPaymentDetail detail = new Model.AcOtherShouldPaymentDetail(); //detail.AcOtherShouldPaymentId = this.AcOtherShouldPayment.AcOtherShouldPaymentId; //this.AcOtherShouldPayment.Details.Add(detail); //this.gridControl1.RefreshDataSource(); //this.bindingSource1.Position = this.bindingSource1.IndexOf(detail); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == this.colAcItemPrice || e.Column == this.colAcQuantity) { Model.AcOtherShouldPaymentDetail CurrentDetail = this.AcOtherShouldPayment.Details[e.RowHandle]; double?mInvoiceTaxrate = (calcTaxRate.EditValue == null || string.IsNullOrEmpty(this.calcTaxRate.EditValue.ToString())) ? 0 : double.Parse(this.calcTaxRate.EditValue.ToString()); global::Helper.TaxType t = (Helper.TaxType) this.TaxType.SelectedIndex; CurrentDetail.AcItemPrice = this.GetDecimal((CurrentDetail.AcItemPrice.HasValue ? CurrentDetail.AcItemPrice.Value : 0), BL.V.SetDataFormat.CGDJXiao.Value); //CurrentDetail.AcQuantity = this.GetDecimal(CurrentDetail.AcQuantity.HasValue ? CurrentDetail.AcQuantity.Value : 0, BL.V.SetDataFormat.CGSLXiao.Value); CurrentDetail.AcMoney = this.GetDecimal(CurrentDetail.AcItemPrice.Value * CurrentDetail.AcQuantity.Value, BL.V.SetDataFormat.CGJEXiao.Value); if (CurrentDetail.AcQuantity.HasValue && CurrentDetail.AcQuantity.Value > 0) { CurrentDetail.TaxCalualateDictionary = new global::Helper.TaxCalculateHelper(t, mInvoiceTaxrate.Value, mInvoiceTaxrate.Value, CurrentDetail.AcMoney.Value, CurrentDetail.AcQuantity.Value).TaxCalculateDictionary; this.CalculateMoney(); } this.gridControl1.RefreshDataSource(); //this.CalcHeJI(); } if (e.Column == this.colLoanName) { Model.AcOtherShouldPaymentDetail CurrentDetail = this.AcOtherShouldPayment.Details[e.RowHandle]; IList <Model.AcItem> acilist = (from Model.AcItem ac in acitemlist where ac.ItemName == CurrentDetail.LoanName select ac).ToList <Model.AcItem>(); if (acilist != null && acilist.Count != 0) { Model.AcItem aci = acilist.First <Model.AcItem>(); CurrentDetail.AcItemId = aci.AcItemId; CurrentDetail.AcItem = aci; CurrentDetail.LoanName = aci.ItemName; double?mInvoiceTaxrate = (calcTaxRate.EditValue == null || string.IsNullOrEmpty(this.calcTaxRate.EditValue.ToString())) ? 0 : double.Parse(this.calcTaxRate.EditValue.ToString()); global::Helper.TaxType t = (Helper.TaxType) this.TaxType.SelectedIndex; CurrentDetail.AcItemPrice = this.GetDecimal(aci.ItemPrice.HasValue ? aci.ItemPrice.Value : 0, BL.V.SetDataFormat.CGDJXiao.Value); //CurrentDetail.AcQuantity = this.GetDecimal(CurrentDetail.AcQuantity.HasValue ? CurrentDetail.AcQuantity.Value : 0, BL.V.SetDataFormat.CGSLXiao.Value); CurrentDetail.AcMoney = this.GetDecimal(CurrentDetail.AcItemPrice.Value * CurrentDetail.AcQuantity.Value, BL.V.SetDataFormat.CGJEXiao.Value); if (CurrentDetail.AcQuantity.HasValue && CurrentDetail.AcQuantity.Value > 0) { CurrentDetail.TaxCalualateDictionary = new global::Helper.TaxCalculateHelper(t, mInvoiceTaxrate.Value, mInvoiceTaxrate.Value, CurrentDetail.AcMoney.Value, CurrentDetail.AcQuantity.Value).TaxCalculateDictionary; this.CalculateMoney(); } this.gridControl1.RefreshDataSource(); } else { CurrentDetail = new Book.Model.AcOtherShouldPaymentDetail(); CurrentDetail.AcItemPrice = 0; CurrentDetail.AcMoney = 0; CurrentDetail.AcQuantity = 0; this.gridControl1.RefreshDataSource(); } } }
public void Update(Model.AcItem e) { this.Update <Model.AcItem>(e); }
public void Insert(Model.AcItem e) { this.Insert <Model.AcItem>(e); }
public void Insert(Model.AcOtherShouldPayment acOtherShouldPayment) { // // todo:add other logic here // Validate(acOtherShouldPayment); //获取数据库原有 IList <Model.AcItem> dbAClist = AcItemaccessor.Select(); try { acOtherShouldPayment.InsertTime = DateTime.Now; BL.V.BeginTransaction(); string invoiceKind = this.GetInvoiceKind().ToLower(); string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acOtherShouldPayment.InsertTime.Value.Year); string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acOtherShouldPayment.InsertTime.Value.Year, acOtherShouldPayment.InsertTime.Value.Month); string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acOtherShouldPayment.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(acOtherShouldPayment); var Qgroup = from Model.AcOtherShouldPaymentDetail acspd in acOtherShouldPayment.Details group acspd by acspd.LoanName; foreach (IGrouping <string, Model.AcOtherShouldPaymentDetail> item in Qgroup) { if (!string.IsNullOrEmpty(item.Last <Model.AcOtherShouldPaymentDetail>().AcItemId)) { Model.AcItem acitem = (from Model.AcItem ac in dbAClist where ac.AcItemId == item.Last().AcItemId select ac).First <Model.AcItem>(); acitem.ItemPrice = item.Last <Model.AcOtherShouldPaymentDetail>().AcItemPrice; AcItemaccessor.Update(acitem); continue; } if (dbAClist == null || dbAClist.Count == 0) { Model.AcItem acitem = new Book.Model.AcItem(); acitem.AcItemId = Guid.NewGuid().ToString(); acitem.AcItemDate = DateTime.Now; acitem.ItemName = item.Last().LoanName; acitem.ItemPrice = item.Last().AcItemPrice; AcItemaccessor.Insert(acitem); } else { IList <Model.AcItem> actQ = (from Model.AcItem ac in dbAClist where ac.ItemName == item.Last().LoanName select ac).ToList(); Model.AcItem act = null; if (actQ != null && actQ.Count != 0) { act = actQ.First <Model.AcItem>(); } if (act != null) { if (act.ItemPrice != item.Last().AcItemPrice) { act.ItemPrice = item.Last().AcItemPrice; AcItemaccessor.Update(act); } } else { Model.AcItem acitem = new Book.Model.AcItem(); acitem.AcItemId = Guid.NewGuid().ToString(); acitem.AcItemDate = DateTime.Now; acitem.ItemName = item.Last().LoanName; acitem.ItemPrice = item.Last().AcItemPrice; AcItemaccessor.Insert(acitem); } } } foreach (Model.AcOtherShouldPaymentDetail acOtherShouldPaymentDetail in acOtherShouldPayment.Details) { acOtherShouldPaymentDetail.AcOtherShouldPaymentDetailId = Guid.NewGuid().ToString(); acOtherShouldPaymentDetail.AcOtherShouldPaymentId = acOtherShouldPayment.AcOtherShouldPaymentId; AcOtherShouldPaymentDetailAccessor.Insert(acOtherShouldPaymentDetail); } BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
public bool ExistsExcept(Model.AcItem e) { return(accessor.ExistsExcept(e)); }