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>页";
}
