private void BindList()
{
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_VLotterLog")
.AddInputParameter("@Wheres", DbType.String, "")
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "ID desc")
.ToDataSet();
if (ds.Tables.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if (ds.Tables[1].Rows.Count > 0)
{
PrizesList.Visible = true;
NoPrizesList.Visible = false;
PrizesList.DataSource = ds.Tables[1];
PrizesList.DataBind();
}
else
{
PrizesList.Visible = false;
NoPrizesList.Visible = true;
}
}
ds.Clear();
}
protected void BindList()
{
if (UserID != null && UserID != "")
{
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_VUserGameMoney")
.AddInputParameter("@Wheres", DbType.String, " and Userid=" + UserID)
.AddInputParameter("@KeyName", DbType.String, "GameID")
.AddInputParameter("@OrderBy", DbType.String, "GameID desc")
.ToDataSet();
if (ds.Tables.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if (ds.Tables[1].Rows.Count > 0)
{
PrizesList.Visible = true;
NoPrizesList.Visible = false;
PrizesList.DataSource = ds.Tables[1];
PrizesList.DataBind();
}
else
{
PrizesList.Visible = false;
NoPrizesList.Visible = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("11");
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_Award")
.AddInputParameter("@Wheres", DbType.String, "")
.AddInputParameter("@KeyName", DbType.String, "Award_id")
.AddInputParameter("@OrderBy", DbType.String, "Award_id desc")
.ToDataSet();
if (ds.Tables.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if (ds.Tables[1].Rows.Count > 0)
{
PrizesList.Visible = true;
NoPrizesList.Visible = false;
PrizesList.DataSource = ds.Tables[1];
PrizesList.DataBind();
}
else
{
PrizesList.Visible = false;
NoPrizesList.Visible = true;
}
}
/*
* DataTable sd = new DataTable();
* string para = "";
* string[] sql = new string[2];
* sql[0] = "select * from Web_Award order by Award_id desc";
* sql[1] = "select count(*) from Web_Award";
* string url = "Prizes.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 Vista = (Repeater)Page.FindControl("PrizesList");
* Vista.DataSource = sd;
* Vista.DataBind();
* this.pageList.Text = page_set.pageList();
* }
* else
* this.NoPrizesList.Visible = true;
* sd.Clear();
*/
}
protected void Page_Load(object sender, EventArgs e)
{
AdminPopedom.IsHoldModel("18");
if (!IsPostBack)
{
if (CommonManager.Web.Request("act", "") == "")
{
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_VLotterSpecial")
.AddInputParameter("@Wheres", DbType.String, "")
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "ID desc")
.ToDataSet();
if (ds.Tables.Count > 0)
{
anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0];
anpPageIndex.CurrentPageIndex = PageIndex;
if (ds.Tables[1].Rows.Count > 0)
{
PrizesList.Visible = true;
NoPrizesList.Visible = false;
PrizesList.DataSource = ds.Tables[1];
PrizesList.DataBind();
}
else
{
PrizesList.Visible = false;
NoPrizesList.Visible = true;
}
}
ds.Clear();
}
else
{
DeleteLog();
}
}
}
