/*
* 方法
*/
#region [ 方法: DataGridView数据绑定 ]
void BindDataGridView()
{
string strWhere = string.Empty;
DataSet ds = aBLL.GetEmployeeAttendanceRateStatistic(dtpStartTime.Value.ToString("yyyy-MM-dd"), dtpEndTime.Value.ToString("yyyy-MM-dd"), out strErr);
if (ds != null)
{
DataTable dt = new DataTable();
dgrd.DataSource = ds.Tables[0];
if (ds.Tables[0].Rows.Count != 0)
{
if (ds.Tables[0].Columns.Count == 4)
{
dgrd.AddSpanHeader(2, 2, ds.Tables[0].Columns[2].ColumnName.ToString());
dgrd.Columns[2].HeaderText = "出勤次数";
dgrd.Columns[3].HeaderText = "均工时数(时)";
}
if (ds.Tables[0].Columns.Count == 6)
{
dgrd.AddSpanHeader(2, 2, ds.Tables[0].Columns[2].ColumnName.ToString());
dgrd.Columns[2].HeaderText = "出勤次数";
dgrd.Columns[3].HeaderText = "均工时数(时)";
dgrd.AddSpanHeader(4, 2, ds.Tables[0].Columns[4].ColumnName.ToString());
dgrd.Columns[4].HeaderText = "出勤次数";
dgrd.Columns[5].HeaderText = "均工时数(时)";
}
if (ds.Tables[0].Columns.Count == 8)
{
dgrd.AddSpanHeader(2, 2, ds.Tables[0].Columns[2].ColumnName.ToString());
dgrd.Columns[2].HeaderText = "出勤次数";
dgrd.Columns[3].HeaderText = "均工时数(时)";
dgrd.AddSpanHeader(4, 2, ds.Tables[0].Columns[4].ColumnName.ToString());
dgrd.Columns[4].HeaderText = "出勤次数";
dgrd.Columns[5].HeaderText = "均工时数(时)";
dgrd.AddSpanHeader(6, 2, ds.Tables[0].Columns[6].ColumnName.ToString());
dgrd.Columns[6].HeaderText = "出勤次数";
dgrd.Columns[7].HeaderText = "均工时数(时)";
}
}
}
}
