//#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(); }