/// <summary>
/// </summary>
protected void GateNames(string typeids)
{
AdminPopedom.IsHoldModel("06");
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, PageIndex)
.AddInputParameter("@Columns", DbType.String, "*")
.AddInputParameter("@TableName", DbType.String, "Web_VGameNameInfo")
.AddInputParameter("@Wheres", DbType.String, " and kindid=" + typeids + " or ParentKindID=" + typeids)
.AddInputParameter("@KeyName", DbType.String, "NameID")
.AddInputParameter("@OrderBy", DbType.String, "IDSort desc")
.ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
GameNamesList.DataSource = ds.Tables[1];
GameNamesList.DataBind();
GameNamesList.Visible = true;
}
else
{
GameNamesList.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("06");
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, PageIndex)
.AddInputParameter("@Columns", DbType.String, "*")
.AddInputParameter("@TableName", DbType.String, "Web_VGameNameInfo")
.AddInputParameter("@Wheres", DbType.String, "")
.AddInputParameter("@KeyName", DbType.String, "NameID")
.AddInputParameter("@OrderBy", DbType.String, "NameID")
.ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
GameNamesList.DataSource = ds.Tables[1];
GameNamesList.DataBind();
GameNamesList.Visible = true;
}
else
{
GameNamesList.Visible = false;
}
/*
* DataTable sd = new DataTable();
* string para = "";
* string[] sql = new string[2];
* sql[0] = @"select n.*,nc.KindName as kindname,ts.DLLFileName,ts.DeskPeople
* from [TGameNameInfo] as n left outer join [TGameKindInfo] as nc on n.Kindid=nc.KindId
* left outer join [TGameServerInfo] as ts on n.NameID=ts.NameID";
* sql[1] = "select count(0) from TGameNameInfo ";
* string url = "GameNames.aspx";
*
* PageLink page_set = new PageLink(url, 20, 10, para, sql);
* page_set.paraLinkType = paraLinkShow.middling.ToString();
* sd = page_set.get_table();
* if (sd.Rows.Count > 0)
* {
* Repeater Vistas = (Repeater)Page.FindControl("GameNamesList");
* Vistas.DataSource = sd;
* Vistas.DataBind();
* this.pageList.Text = page_set.pageList();
* }
* else
* sd.Clear();*/
}
