public void Delete(Model.SalesForHeader salesForHeader)
{
//
// todo:add other logic here
//
accessor.Delete(salesForHeader.SalesForHeaderId);
}
public bool ExistsExcept(Model.SalesForHeader e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.SalesForHeaderId).Id);
return(sqlmapper.QueryForObject <bool>("SalesForHeader.existsexcept", paras));
}
public Model.SalesForHeader Getdetails(string salesForHeaderId)
{
Model.SalesForHeader SalesForHeader = accessor.Get(salesForHeaderId);
if (SalesForHeader != null)
{
SalesForHeader.details = salesFordetailsAccessor.Getdetails(SalesForHeader);
}
return(SalesForHeader);
}
public IList <Model.SalesFordetails> Getdetails(Model.SalesForHeader salesForHeader)
{
if (salesForHeader == null)
{
return(null);
}
else
{
return(sqlmapper.QueryForList <Model.SalesFordetails>("SalesFordetails.select_bySalesHeader", salesForHeader.SalesForHeaderId));
}
}
/// <summary>
/// Update a SalesForHeader.
/// </summary>
public void Update(Model.SalesForHeader salesForHeader)
{
//
// todo: add other logic here.
//
//accessor.Update(salesForHeader);
if (salesForHeader != null)
{
this.Delete(salesForHeader);
salesForHeader.UpdateTime = DateTime.Now;
this.Insert(salesForHeader);
}
}
/// <summary>
/// Delete SalesForHeader by primary key.
/// </summary>
/// <summary>
/// Insert a SalesForHeader.
/// </summary>
public void Insert(Model.SalesForHeader salesForHeader)
{
//
// todo:add other logic here
//
salesForHeader.InsertTime = DateTime.Now;
accessor.Insert(salesForHeader);
if (salesForHeader.details != null)
{
foreach (Model.SalesFordetails SalesFordetails in salesForHeader.details)
{
if (SalesFordetails.Product == null || string.IsNullOrEmpty(SalesFordetails.Product.ProductId))
{
throw new Exception("貨品不為空");
}
SalesFordetails.SalesForHeaderId = salesForHeader.SalesForHeaderId;
salesFordetailsAccessor.Insert(SalesFordetails);
}
}
}
public Model.SalesForHeader GetPrev(Model.SalesForHeader e)
{
return(sqlmapper.QueryForObject <Model.SalesForHeader>("SalesForHeader.get_prev", e));
}
public Model.SalesForHeader GetNext(Model.SalesForHeader e)
{
return(sqlmapper.QueryForObject <Model.SalesForHeader>("SalesForHeader.get_next", e));
}
public bool HasRowsAfter(Model.SalesForHeader e)
{
return(sqlmapper.QueryForObject <bool>("SalesForHeader.has_rows_after", e));
}
public bool ExistsExcept(Model.SalesForHeader e)
{
return(accessor.ExistsExcept(e));
}
public void Update(Model.SalesForHeader e)
{
this.Update <Model.SalesForHeader>(e);
}
public void Insert(Model.SalesForHeader e)
{
this.Insert <Model.SalesForHeader>(e);
}
public Model.SalesForHeader GetNext(Model.SalesForHeader e)
{
return(accessor.GetNext(e));
}
public Model.SalesForHeader GetPrev(Model.SalesForHeader e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.SalesForHeader e)
{
return(accessor.HasRowsAfter(e));
}
public bool HasRowsBefore(Model.SalesForHeader e)
{
return(accessor.HasRowsBefore(e));
}
public bool HasRowsBefore(Model.SalesForHeader e)
{
return(sqlmapper.QueryForObject <bool>("SalesForHeader.has_rows_before", e));
}
public IList <Model.SalesFordetails> Getdetails(Model.SalesForHeader salesForHeader)
{
return(accessor.Getdetails(salesForHeader));
}
