public void DataBindList()
{
DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager")
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@CurrentPage", DbType.Int32, anpPageIndex.CurrentPageIndex)
.AddInputParameter("@Columns", DbType.String, "*")
.AddInputParameter("@TableName", DbType.String, "Web_AdminModifyLog")
.AddInputParameter("@Wheres", DbType.String, " ")
.AddInputParameter("@KeyName", DbType.String, "ID")
.AddInputParameter("@OrderBy", DbType.String, "AddTime 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;
PrizesHList.DataSource = ds.Tables[1];
PrizesHList.DataBind();
PrizesHList.Visible = true;
NoPrizesHList.Visible = false;
}
else
{
this.NoPrizesHList.Visible = true;
PrizesHList.Visible = false;
}
}
public void DataBindList()
{
DataSet ds = DbSession.Default.FromProc("Web_PSystemStat").ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
PrizesHList.DataSource = ds.Tables[0];
PrizesHList.DataBind();
}
}
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_vAwardLog")
.AddInputParameter("@Wheres", DbType.String, "")
.AddInputParameter("@KeyName", DbType.String, "log_ID")
.AddInputParameter("@OrderBy", DbType.String, "AwardTime 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)
{
PrizesHList.Visible = true;
NoPrizesHList.Visible = false;
PrizesHList.DataSource = ds.Tables[1];
PrizesHList.DataBind();
}
else
{
PrizesHList.Visible = false;
NoPrizesHList.Visible = true;
}
}
/*
* DataTable sd = new DataTable();
* string para = "";
* string[] sql = new string[2];
* sql[0] = @"select *,b.Award_Name,c.UserName from Web_AwardLog a,Web_Award b,TUsers c
* where a.Award_ID=b.Award_ID and a.UserID=c.UserID order by a.log_id desc";
* sql[1] = "select count(*) from Web_AwardLog";
* string url = "PrizesH.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("PrizesHList");
* Vista.DataSource = sd;
* Vista.DataBind();
* this.pageList.Text = page_set.pageList();
* }
* else
* this.NoPrizesHList.Visible = true;
* sd.Clear();*/
}
public void DataBindList()
{
string date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (Request.QueryString["Date"] != null && Request.QueryString["Date"].ToString().Length > 0)
{
date = Request.QueryString["Date"].ToString();
}
strDateTime = date;
DataSet ds = DbSession.Default.FromProc("Web_PSystemStatForToday")
.AddInputParameter("@DateTM", DbType.DateTime, date)
.ToDataSet();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
PrizesHList.DataSource = ds.Tables[0];
PrizesHList.DataBind();
}
}