public void BindGridViewAndPager() { int valueCount = 0; BLL.TN_FaultRecode faultRecordBll = new BLL.TN_FaultRecode(); int startRowNo = (_anpager.CurrentPageIndex - 1) * _anpager.PageSize + 1; int endRowNo = _anpager.CurrentPageIndex * _anpager.PageSize; int rowCount = 0; DataTable dt = faultRecordBll.GridViewAndPager(_coalCode, _startTime, _endTime, _queryWhere, _queryOrder, startRowNo, endRowNo, out rowCount).Tables[0]; dt.Columns.Add("newTime"); for (int i = 0; i < dt.Rows.Count; i++) { double s = Convert.ToDouble((dt.Rows[i]["Duration"].ToString())); int s1 = (Int32)s; dt.Rows[i]["newTime"] = CalculateTime(s1); } //add by zhangkr 2010-11-27 for (int j = 0; j < dt.Rows.Count;j++ ) { devStatus = new TDTK.IndustryPlatform.SafetyMonitor.BLL.TN_DevStatus(); string strCode = dt.Rows[j]["DevState"].ToString(); dt.Rows[j]["DevState"] = devStatus.GetNameByCodeNew(strCode); } //add by zhangkr if (dt.Rows.Count < pageCount) { valueCount = pageCount - dt.Rows.Count; for (int i = 0; i < valueCount; i++) { dt.Rows.Add(); } } Gv.DataSource = dt; Gv.DataBind(); _anpager.RecordCount = rowCount; _anpager.CustomInfoHTML = "共<font color=\"blue\"><b>" + _anpager.RecordCount.ToString() + "</b></font>条记录"; _anpager.CustomInfoHTML += " 共<font color=\"blue\"><b>" + _anpager.PageCount.ToString() + "</b></font>页"; _anpager.CustomInfoHTML += " 当前第<font color=\"red\"><b>" + _anpager.CurrentPageIndex.ToString() + "</b></font>页"; }
private void BindSwitchData(BLL.TN_SwitchData switchDataBll) { int valueCount = 0; int startRowNo = (_anpager.CurrentPageIndex - 1) * _anpager.PageSize + 1; int endRowNo = _anpager.CurrentPageIndex * _anpager.PageSize; int rowCount = 0; DataSet dst = switchDataBll.GridViewAndPager(_coalCode, _deviceCode, _startTime, _endTime, _queryWhere, _queryOrder, startRowNo, endRowNo, out rowCount); if (dst.Tables.Count>0) { DataTable dt=dst.Tables[0]; //add by zhangkr 2010-11-27 for (int j = 0; j < dt.Rows.Count; j++) { devStatus = new TDTK.IndustryPlatform.SafetyMonitor.BLL.TN_DevStatus(); string strCode = dt.Rows[j]["DevState"].ToString(); dt.Rows[j]["DevState"] = devStatus.GetNameByCodeNew(strCode); } //add by zhangkr if (dt.Rows.Count < pageCount) { valueCount = pageCount - dt.Rows.Count; for (int i = 0; i < valueCount; i++) { dt.Rows.Add(); } } Gv.DataSource = dt; Gv.DataBind(); } _anpager.RecordCount = rowCount; _anpager.CustomInfoHTML = "共<font color=\"blue\"><b>" + _anpager.RecordCount.ToString() + "</b></font>条记录"; _anpager.CustomInfoHTML += " 共<font color=\"blue\"><b>" + _anpager.PageCount.ToString() + "</b></font>页"; _anpager.CustomInfoHTML += " 当前第<font color=\"red\"><b>" + _anpager.CurrentPageIndex.ToString() + "</b></font>页"; }