public DbQueryResult GetAllDebitNote(DebitNoteQuery query)
{
StringBuilder builder = new StringBuilder();
builder.Append(" 1=1");
if (!string.IsNullOrEmpty(query.OrderId))
{
builder.AppendFormat(" and OrderId = '{0}'", query.OrderId);
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_OrderDebitNote", "NoteId", builder.ToString(), "*");
}
private DebitNoteQuery GetDebitNoteQuery()
{
DebitNoteQuery query = new DebitNoteQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OrderId"]))
{
query.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["OrderId"]);
}
query.PageIndex = this.pager.PageIndex;
query.PageSize = this.pager.PageSize;
query.SortBy = "PayDate";
query.SortOrder = SortAction.Desc;
return query;
}
public static DbQueryResult GetAllDebitNote(DebitNoteQuery query)
{
return new DebitNoteDao().GetAllDebitNote(query);
}