public Model.BGHandbook GetDetails(string id)
{
Model.BGHandbook produceInDepot = accessor.Get(id);
produceInDepot.Detail1 = Detail1Accessor.Select(id);
produceInDepot.Detail2 = Detail2Accessor.Select(id);
return(produceInDepot);
}
public void Delete(Model.BGHandbook model)
{
//
// todo:add other logic here
//
this.Delete(model.BGHandbookId);
}
public bool ExistsExcept(Model.BGHandbook e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.BGHandbookId) == null?null:Get(e.BGHandbookId).Id);
return(sqlmapper.QueryForObject <bool>("BGHandbook.existsexcept", paras));
}
public void _insert(Model.BGHandbook bGHandbook)
{
try
{
BL.V.BeginTransaction();
Insert(bGHandbook);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void TiGuiExists(Model.BGHandbook model)
{
if (this.ExistsPrimary(model.BGHandbookId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.BGHandbookDate.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.BGHandbookDate.Value.Year, model.BGHandbookDate.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.BGHandbookDate.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.BGHandbookId = this.GetId(model.BGHandbookDate.Value);
TiGuiExists(model);
}
}
private void addDetail(Model.BGHandbook model)
{
if (model.Detail1 != null)
{
foreach (Model.BGHandbookDetail1 detail1 in model.Detail1)
{
detail1.BGHandbookId = model.BGHandbookId;
Detail1Accessor.Insert(detail1);
}
}
if (model.Detail2 != null)
{
foreach (Model.BGHandbookDetail2 detail2 in model.Detail2)
{
detail2.BGHandbookId = model.BGHandbookId;
Detail2Accessor.Insert(detail2);
}
}
}
/// <summary>
/// Update a BGHandbook.
/// </summary>
public void Update(Model.BGHandbook bGHandbook)
{
//
// todo: add other logic here.
//
//accessor.Update(bGHandbook);
try
{
BL.V.BeginTransaction();
bGHandbook.UpdateTime = DateTime.Now;
accessor.Delete(bGHandbook.BGHandbookId);
this.Insert(bGHandbook);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
/// <summary>
/// Insert a BGHandbook.
/// </summary>
public void Insert(Model.BGHandbook bGHandbook)
{
//
// todo:add other logic here
//
bGHandbook.InsertTime = DateTime.Now;
TiGuiExists(bGHandbook);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, bGHandbook.BGHandbookDate.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, bGHandbook.BGHandbookDate.Value.Year, bGHandbook.BGHandbookDate.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, bGHandbook.BGHandbookDate.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(bGHandbook);
addDetail(bGHandbook);
}
public bool ExistsExcept(Model.BGHandbook e)
{
return(accessor.ExistsExcept(e));
}
public Model.BGHandbook GetPrev(Model.BGHandbook e)
{
return(sqlmapper.QueryForObject <Model.BGHandbook>("BGHandbook.get_prev", e));
}
public Model.BGHandbook GetNext(Model.BGHandbook e)
{
return(sqlmapper.QueryForObject <Model.BGHandbook>("BGHandbook.get_next", e));
}
public bool HasRowsAfter(Model.BGHandbook e)
{
return(sqlmapper.QueryForObject <bool>("BGHandbook.has_rows_after", e));
}
public bool HasRowsBefore(Model.BGHandbook e)
{
return(sqlmapper.QueryForObject <bool>("BGHandbook.has_rows_before", e));
}
public Model.BGHandbook GetPrev(Model.BGHandbook e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsBefore(Model.BGHandbook e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsAfter(Model.BGHandbook e)
{
return(accessor.HasRowsAfter(e));
}
public void Insert(Model.BGHandbook e)
{
this.Insert <Model.BGHandbook>(e);
}
public Model.BGHandbook GetNext(Model.BGHandbook e)
{
return(accessor.GetNext(e));
}
public void Update(Model.BGHandbook e)
{
this.Update <Model.BGHandbook>(e);
}
