protected override void AddNew()
{
Model.AcItem mac = new Book.Model.AcItem();
mac.AcItemId = Guid.NewGuid().ToString();
mac.Id = "01";
mac.AcItemDate = DateTime.Now;
mac.mState = true;
this._detail.Add(mac);
}
protected override void grid_keyDpwn()
{
//Model.Setting set = new Book.Model.Setting();
//set.SettingId = Guid.NewGuid().ToString();
//set.SettingTags = "PCISO";
//this._detail.Add(set);
//this.bindingSource1.Position = this.bindingSource1.IndexOf(set);
//this.gridControl1.RefreshDataSource();
Model.AcItem mac = new Book.Model.AcItem();
mac.AcItemId = Guid.NewGuid().ToString();
mac.Id = this._detail.Max(item => Convert.ToInt32(item.Id)).ToString();
mac.AcItemDate = DateTime.Now;
mac.mState = true;
this._detail.Add(mac);
this.gridControl1.RefreshDataSource();
}
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;
}
}