private void BindData(int CurrentPageIndex)
{
int nStatus = -1;
string sKeyword ="";
int nPageSize = 1000;
int nPageCount = Constants.PAGECOUNT;
DataTable dtbPage = new DataTable();
StaticPages objPage = new StaticPages();
dtbPage = objPage.Search(sKeyword, 0,0, nStatus, CurrentPageIndex, nPageSize, ref nPageCount);
FlowCategory flow = new FlowCategory(dtbPage, VERTICAL_COLUMN_NAME, HOLIZOTAL_COLUMN_NAME);
if (nStatus == -1 && sKeyword == string.Empty) // search all
{
DataTable objTable = new DataTable();
StaticPages obj = new StaticPages();
objTable = obj.Search("", 0,1, -1, 1, 10000, ref nPageCount);
FlowCategory objflow = new FlowCategory(objTable, VERTICAL_COLUMN_NAME, HOLIZOTAL_COLUMN_NAME);
objflow.IDColumnName = "StaticPageID";
objflow.ParentIDColumName = "[Parent]";
flow.SortColumnName = "MenuName";
objflow.SortColumnName = "Priority";
objflow.ParentSortDirection = "ASC";
if (objflow.Execute(0))
{
int iCurrIndex = 0;
if (CurrentPageIndex > 0) iCurrIndex = CurrentPageIndex - 1;
mCateData = objflow.DestinationData();
FlowPager pager = new FlowPager(mCateData, nPageSize, "[Parent]");
DataView vwPage = pager.GeneralPageByIndex(iCurrIndex, VERTICAL_COLUMN_NAME);
hidSearchStatus.Value = "1";
RpStaticPage.DataSource = vwPage;
nPageCount = mCateData.Rows.Count;
nPageSize = pager.TotalRecord;
}
mCateData = objflow.DestinationData();
RpStaticPage.DataBind();
//lblTotalRecord.Text = "Có" + " " + +nPageCount + " " + "Bản ghi được tìm thấy";
}
else // Search Active or Inactive
{
hidSearchStatus.Value = "0";
RpStaticPage.DataBind();
//lblTotalRecord.Text = ConvertData.ConvertToString(nPageCount);
}
}
private void BindDataToDropCategory()
{
int nPageCount = 0;
ddlCategory.Items.Clear();
DataTable objTable = new DataTable();
StaticPages objStaticPages = new StaticPages();
objTable = objStaticPages.Search("", 0,0, -1, 1, 10000, ref nPageCount);
int nCount = objTable.Rows.Count;
FlowCategory flow = new FlowCategory(objTable, VERTICAL_COLUMN_NAME, HOLIZOTAL_COLUMN_NAME);
flow.IDColumnName = "StaticPageID";
flow.ParentIDColumName = "[Parent]";
flow.SortColumnName = "MenuName";
flow.SortColumnName = "Priority";
flow.ParentSortDirection = "ASC";
if (flow.Execute(0))
{
mCateData = flow.DestinationData();
}
if (mCateData != null)
{
foreach (DataRow dr in mCateData.Rows)
{
if (dr != null)
{
string sText = Convert.ToString(dr["MenuName"]);
Int16 iHolz = Convert.ToInt16(dr[HOLIZOTAL_COLUMN_NAME]);
textCreateMarginLeft(ref sText, iHolz);
ListItem item = new ListItem(sText, Convert.ToString(dr["StaticPageID"]));
ddlCategory.Items.Add(item);
}
}
Utl1.SetNonSelectToControl(ddlCategory, MultipleLanguage.DDL_SELECTVALUE, "0");
}
else
{
ddlCategory.DataSource = mCateData;
ddlCategory.DataTextField = "MenuName";
ddlCategory.DataValueField = "StaticPageID";
ddlCategory.DataBind();
Utl1.SetNonSelectToControl(ddlCategory, "Tất cả", "0");
}
}