/// <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 个人"; // })); } }