//#region 规定页面加载时显示近几个月内发放的IC卡
///// <summary>
///// 规定页面加载时显示近几个月内发放的IC卡
///// </summary>
///// <param name="date"></param>
///// <returns></returns>
//public static string GetBeginTime(System.DateTime date)
//{
// int monthInterval = 0;
// try
// {
// monthInterval = 12;//规定页面加载时显示近12个月内发放的IC卡
// }
// catch (Exception e)
// {
// e.ToString();
// }
// return date.AddMonths(monthInterval * (-1)).ToString("yyyy-MM-dd");
//}
//public static string GetBeginTime()
//{
// return GetBeginTime(DateTime.Now);
//}
//#endregion
protected void grdInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdInfo.PageIndex = e.NewPageIndex;
string sqlWhere = GetSqlWhereSort();
if (string.IsNullOrEmpty(this.hidStrSort.Value))
{
sqlWhere += " order by FK_Time desc";
}
else
{
sqlWhere += this.hidStrSort.Value;
}
DataSet ds = ICParam.GetDataSetsort(sqlWhere);
this.grdInfo.DataSource = ds;
this.grdInfo.DataBind();
}
protected void grdInfo_Sorting(object sender, GridViewSortEventArgs e)
{
if (string.IsNullOrEmpty(this.hidsort.Value))
{
this.hidsort.Value = "DESC";
}
else
{
if (this.hidsort.Value.Trim() == "DESC")
{
this.hidsort.Value = "ASC";
}
else
{
this.hidsort.Value = "DESC";
}
}
string sortField = e.SortExpression.ToString();
string strSort = " order by " + sortField + " " + this.hidsort.Value;
this.hidStrSort.Value = strSort;
string sqlWhere = GetSqlWhereSort();
sqlWhere += strSort;
DataSet ds = ICParam.GetDataSetsort(sqlWhere);
int ICsum = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ICsum += 1;
}
this.lblICsum.Text = ICsum.ToString();
this.grdInfo.DataSource = ds;
this.grdInfo.DataBind();
}
