private void BindDebitNote()
{
DebitNoteQuery debitNoteQuery = this.GetDebitNoteQuery();
DbQueryResult allPurchaseDebitNote = SalesHelper.GetAllPurchaseDebitNote(debitNoteQuery);
this.dlstDebitNote.DataSource = allPurchaseDebitNote.Data;
this.dlstDebitNote.DataBind();
this.pager.TotalRecords = allPurchaseDebitNote.TotalRecords;
this.pager1.TotalRecords = allPurchaseDebitNote.TotalRecords;
this.txtPurchaseOrderId.Text = debitNoteQuery.OrderId;
}
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["PurchaseOrderId"]))
{
query.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["PurchaseOrderId"]);
}
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));
}
public static DbQueryResult GetAllDebitNote(DebitNoteQuery query)
{
return(SalesProvider.Instance().GetAllDebitNote(query));
}
public abstract DbQueryResult GetAllPurchaseDebitNote(DebitNoteQuery query);
