private void LoadData()
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(txtstartime.Text) && !string.IsNullOrEmpty(txtenddate.Text))
{
sb.AppendFormat("and cast (WriteTime as date) between '{0}' and '{1}'", Convert.ToDateTime(txtstartime.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtenddate.Text).ToString("yyyy-MM-dd"));
}
if (!string.IsNullOrEmpty(txtUserName.Text))
{
sb.AppendFormat(" and UserID like '%{0}%'", txtUserName.Text.Trim());
}
string sql = string.Format("select *,UserID+'|'+ cast (cast(WriteTime as date) as varchar(10)) as ID from t_failrequestInfo where 1=1 {0} ", sb.ToString());
DataSet ds2 = userbll.GetSqlList(sql);
DataSet ds = userbll.ExecuteSqlPager(sql, "UserID", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);
Gdv_data.DataSource = ds.Tables[0];
Gdv_data.DataBind();
int RecordCount = ds2.Tables[0].Rows.Count;
AspNetPager1.PageSize = RecordCount;
AspNetPager1.RecordCount = RecordCount;
}
private void LoadData()
{
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(txtUserName.Text))
{
strWhere = string.Format(" UserName like '%{0}%'", txtUserName.Text.Trim());
}
string sql = string.Format("select * from t_userinfo {0} ", strWhere != ""?"where " + strWhere:"");
DataSet ds2 = userbll.GetList(strWhere);
DataSet ds = userbll.ExecuteSqlPager(sql, "ID", AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);
Gdv_data.DataSource = ds.Tables[0];
Gdv_data.DataBind();
int RecordCount = ds2.Tables[0].Rows.Count;
AspNetPager1.RecordCount = RecordCount;
}
