Ejemplo n.º 1
0
 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(), "*");
 }
Ejemplo n.º 2
0
 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;
 }
Ejemplo n.º 3
0
 public static DbQueryResult GetAllDebitNote(DebitNoteQuery query)
 {
     return new DebitNoteDao().GetAllDebitNote(query);
 }