/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pIndex">页索引</param>
public void BindData(int pIndex)
{
if (this.InvokeRequired)
{
SetBindData d = new SetBindData(BindData);
Invoke(d, new object[] { pIndex });
}
else
{
if (pIndex < 1)
{
MessageBox.Show("您输入的页数超出范围,请正确输入页数");
return;
}
if (pIndex == 1)
{
btnUpPage.Enabled = false;
}
DataSet ds = realtimeInwellBll.GetRealTimeInWell(pIndex, m_PSize, m_StrWhere);
if (ds.Tables != null && ds.Tables.Count > 0)
{
// 重新设置页数
int sumPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
sumPage = sumPage % m_PSize != 0 ? sumPage / m_PSize + 1 : sumPage / m_PSize;
m_PCounts = sumPage;//获取总页数
#region[qyz 设置显示内容]
DataTable dt = ds.Tables[0];
dt.Columns.Remove("EmpNo");
dt.Columns.Remove("classGroup");
dt.Columns.Remove("ClassName");
dt.Columns.Remove("Directional");
dt.Columns.Remove("DeptID");
dt.Columns.Remove("workTypeID");
dt.Columns.Remove("DutyID");
dt.Columns.Remove("DutyClassID");
dt.Columns.Remove("InHereLong");
#endregion
dt.TableName = "FrmRealInWell";
if (pIndex > sumPage)
{
if (sumPage == 0)
{
lblCounts.Text = "共 0 条信息";
lblPageCounts.Text = "1";
lblSumPage.Text = "/" + 1 + "页";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
dgvMain.DataSource = dt;
#region[qyz 设置显示内容]
dgvMain.Columns["CodeSenderAddress"].HeaderText = "标识卡";
dgvMain.Columns["EmpName"].HeaderText = "姓名";
dgvMain.Columns["DeptName"].HeaderText = "部门";
dgvMain.Columns["WorkTypeName"].HeaderText = "工种";
dgvMain.Columns["DutyName"].HeaderText = "职务";
dgvMain.Columns["IntervalName"].HeaderText = "班次";
dgvMain.Columns["StationHeadPlace"].HeaderText = "下井位置";
dgvMain.Columns["InTime"].HeaderText = "下井时间";
dgvMain.Columns["InTimeLong"].HeaderText = "下井时长";
dgvMain.Columns["InWellPlace"].HeaderText = "现处位置";
dgvMain.Columns["StationHeadDetectTime"].HeaderText = "检测时间";
#endregion
return;
}
pIndex = sumPage;
}
btnUpPage.Enabled = true;
btnDownPage.Enabled = true;
if (pIndex == 1)
{
btnUpPage.Enabled = false;
}
if (pIndex == sumPage)
{
btnDownPage.Enabled = false;
}
lblCounts.Text = "共 " + ds.Tables[1].Rows[0][0].ToString() + " 条信息";
lblPageCounts.Text = pIndex.ToString();
lblSumPage.Text = "/" + sumPage + "页";
dgvMain.DataSource = dt;
#region[qyz 设置显示内容]
dgvMain.Columns["CodeSenderAddress"].HeaderText = "标识卡";
dgvMain.Columns["EmpName"].HeaderText = "姓名";
dgvMain.Columns["DeptName"].HeaderText = "部门";
dgvMain.Columns["WorkTypeName"].HeaderText = "工种";
dgvMain.Columns["DutyName"].HeaderText = "职务";
dgvMain.Columns["IntervalName"].HeaderText = "班次";
dgvMain.Columns["StationHeadPlace"].HeaderText = "下井位置";
dgvMain.Columns["InTime"].HeaderText = "下井时间";
dgvMain.Columns["InTimeLong"].HeaderText = "下井时长";
dgvMain.Columns["InWellPlace"].HeaderText = "现处位置";
dgvMain.Columns["StationHeadDetectTime"].HeaderText = "检测时间";
#endregion
}
else
{
lblCounts.Text = "共 0 条信息";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
lblPageCounts.Text = "1";
lblSumPage.Text = "/" + 1 + "页";
dgvMain.DataSource = null;
}
//****czlt-2010-9-16**start****
if (isHearderSort == true)
{
DataGridViewColumn newColumn = dgvMain.Columns[index];
dgvMain.Sort(newColumn, listSort);
}
//****czlt-2010-9-16**end****
}
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="pIndex">页索引</param>
public void BindData(int pIndex)
{
if (this.InvokeRequired)
{
SetBindData d = new SetBindData(BindData);
Invoke(d, new object[] { pIndex });
}
else
{
if (pIndex < 1)
{
MessageBox.Show("您输入的页数超出范围,请正确输入页数");
return;
}
if (pIndex == 1)
{
btnUpPage.Enabled = false;
}
DataSet ds = realtimeInwellBll.GetRealTimeInWell(pIndex, m_PSize, m_StrWhere);
if (ds.Tables != null && ds.Tables.Count > 0)
{
// 重新设置页数
int sumPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
sumPage = sumPage % m_PSize != 0 ? sumPage / m_PSize + 1 : sumPage / m_PSize;
m_PCounts = sumPage;//获取总页数
#region [qyz 设置显示内容]
DataTable dt = ds.Tables[0];
dt.Columns.Remove("EmpNo");
dt.Columns.Remove("classGroup");
dt.Columns.Remove("ClassName");
dt.Columns.Remove("Directional");
dt.Columns.Remove("DeptID");
dt.Columns.Remove("workTypeID");
dt.Columns.Remove("DutyID");
dt.Columns.Remove("DutyClassID");
dt.Columns.Remove("InHereLong");
#endregion
dt.TableName = "FrmRealInWell";
if (pIndex > sumPage)
{
if (sumPage == 0)
{
lblCounts.Text = "共 0 条信息";
lblPageCounts.Text = "1";
lblSumPage.Text = "/" + 1 + "页";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
dgvMain.DataSource = dt;
#region [qyz 设置显示内容]
dgvMain.Columns["CodeSenderAddress"].HeaderText = "标识卡";
dgvMain.Columns["EmpName"].HeaderText = "姓名";
dgvMain.Columns["DeptName"].HeaderText = "部门";
dgvMain.Columns["WorkTypeName"].HeaderText = "工种";
dgvMain.Columns["DutyName"].HeaderText = "职务";
dgvMain.Columns["IntervalName"].HeaderText = "班次";
dgvMain.Columns["StationHeadPlace"].HeaderText = "下井位置";
dgvMain.Columns["InTime"].HeaderText = "下井时间";
dgvMain.Columns["InTimeLong"].HeaderText = "下井时长";
dgvMain.Columns["InWellPlace"].HeaderText = "现处位置";
dgvMain.Columns["StationHeadDetectTime"].HeaderText = "检测时间";
#endregion
return;
}
pIndex = sumPage;
}
btnUpPage.Enabled = true;
btnDownPage.Enabled = true;
if (pIndex == 1)
{
btnUpPage.Enabled = false;
}
if (pIndex == sumPage)
{
btnDownPage.Enabled = false;
}
lblCounts.Text = "共 " + ds.Tables[1].Rows[0][0].ToString() + " 条信息";
lblPageCounts.Text = pIndex.ToString();
lblSumPage.Text = "/" + sumPage + "页";
dgvMain.DataSource = dt;
#region [qyz 设置显示内容]
dgvMain.Columns["CodeSenderAddress"].HeaderText = "标识卡";
dgvMain.Columns["EmpName"].HeaderText = "姓名";
dgvMain.Columns["DeptName"].HeaderText = "部门";
dgvMain.Columns["WorkTypeName"].HeaderText = "工种";
dgvMain.Columns["DutyName"].HeaderText = "职务";
dgvMain.Columns["IntervalName"].HeaderText = "班次";
dgvMain.Columns["StationHeadPlace"].HeaderText = "下井位置";
dgvMain.Columns["InTime"].HeaderText = "下井时间";
dgvMain.Columns["InTimeLong"].HeaderText = "下井时长";
dgvMain.Columns["InWellPlace"].HeaderText = "现处位置";
dgvMain.Columns["StationHeadDetectTime"].HeaderText = "检测时间";
#endregion
}
else
{
lblCounts.Text = "共 0 条信息";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
lblPageCounts.Text = "1";
lblSumPage.Text = "/" + 1 + "页";
dgvMain.DataSource = null;
}
//****czlt-2010-9-16**start****
if (isHearderSort == true)
{
DataGridViewColumn newColumn = dgvMain.Columns[index];
dgvMain.Sort(newColumn, listSort);
}
//****czlt-2010-9-16**end****
}
}
