/// <summary>
/// 加载并绑定数据
/// </summary>
/// <param name="intPage"></param>
private void GridViewBind()
{
int intPage = pages;
if (chkUnion.Checked)
{
isUnion = true;
}
else
{
isUnion = false;
}
DataSet ds = aBLL.GetEmployeeAttendanceDeptStatistic(dtpStartTime.Value.ToString("yyyy-MM-dd"), dtpEndTime.Value.ToString("yyyy-MM-dd"), strSqlWhere, intPage, pSize, isUnion, out strErr);
try
{
if (ds != null && ds.Tables.Count > 0)
{
//ds.Tables[0].Columns[0].SetOrdinal(2);
//ds.Tables[0].Columns[2].SetOrdinal(0);
//DataTable dt = new DataTable();
//int count0 = 0;
//int count4 = 0;
//int count8 = 0;
//int count9 = 0;
//int count10 = 0;
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// count0 = count0 + Convert.ToInt32(dr[3]);
// count4 = count4 + Convert.ToInt32(dr[4]);
// count8 = count8 + Convert.ToInt32(dr[5]);
// count9 = count9 + Convert.ToInt32(dr[6]);
// count10 = count10 + Convert.ToInt32(dr[7]);
//}
//DataRow r = ds.Tables[0].NewRow();
//r[2] = "合计";
//r[3] = count0;
//r[4] = count4;
//r[5] = count8;
//r[6] = count9;
//r[7] = count10;
//ds.Tables[0].Rows.Add(r);
//ds.Tables[0].Columns.Remove("deptid");
//ds.Tables[0].TableName = "A_AttendanceDeptStatistic";
this.Invoke(new MethodInvoker(delegate()
{
dgViewDept.DataSource = ds.Tables[0];
//dgViewDept.DataSource = dt;
// 重新设置页数
int sumPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
sumPage = sumPage % pSize != 0 ? sumPage / pSize + 1 : sumPage / pSize;
countPage = sumPage;
if (sumPage == 0)
{
lblCounts.Text = "共 0 条记录";
lblPageCounts.Text = "1";
lblSumPage.Text = "/1页";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
}
else
{
lblCounts.Text = "共 " + ds.Tables[1].Rows[0][0].ToString() + " 条记录";
lblPageCounts.Text = intPage.ToString();
lblSumPage.Text = "/" + sumPage + "页";
//控制翻页状态
SetPageEnable(intPage, sumPage);
}
//customersDataGridView.Columns["ContactName"].DisplayIndex = 0;
//customersDataGridView.Columns["ContactTitle"].DisplayIndex = 1;
//dgViewDept.Controls["部门名称"];
//dgViewDept.Columns[1].Visible = false;
//dgViewDept.Columns[0].DisplayIndex = 1;
//dgViewDept.Columns[1].DisplayIndex = 0;
}));
}
else
{
MessageBox.Show("没有符合条件的查询结果,请重新选择查询条件进行查询!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//DataTable dt = new DataTable("A_AttendanceDeptStatistic_BindDataGridView");
//dt.Columns.Add("部门名称");
//dt.Columns.Add("班制");
//dt.Columns.Add("出勤汇总");
//dt.Columns.Add("早班汇总");
//dt.Columns.Add("中班汇总");
//dt.Columns.Add("晚班汇总");
//dt.Columns.Add("请假汇总");
//this.Invoke(new MethodInvoker(delegate()
// {
// dgViewDept.DataSource = dt;
// lblCounts.Text = "共 0 个人";
// }));
}
}
catch
{
MessageBox.Show("您的查询有误,请重新查询!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
//DataTable dt = new DataTable("A_AttendanceDeptStatistic_BindDataGridView");
//dt.Columns.Add("部门名称");
//dt.Columns.Add("班制");
//dt.Columns.Add("出勤汇总");
//dt.Columns.Add("早班汇总");
//dt.Columns.Add("中班汇总");
//dt.Columns.Add("晚班汇总");
//dt.Columns.Add("请假汇总");
//this.Invoke(new MethodInvoker(delegate()
// {
// dgViewDept.DataSource = dt;
// lblCounts.Text = "共 0 个人";
// }));
}
}
