public A_AddHistoryAttendance_Add(A_AddHistoryAttendance frm)
{
InitializeComponent();
Afr = frm;
blIsAdd = frm._isAdd;
bindcombox(ddlClassAdd, ddlTimerIntervalAdd);
if (blIsAdd) //补单
{
GetDeptInfo(); //部门
GetEmpName(cmbDept); //姓名
}
else //修改
{
if (Afr._id != null && Afr._id != "")
{
DataSet dsHisA;
using (dsHisA = new DataSet())
{
dsHisA = aBLL.GetEmployeeAttendanceHistoryList(" and H.ID=" + Afr._id, 1, 1, frm.dtpStartTime.Value.ToString("yyyyM"), frm.dtpStartTime.Value.ToString("yyyyM"), out strErr);
if (dsHisA != null && dsHisA.Tables.Count > 0)
{
GetDeptInfo(); //部门
cmbDept.SelectedValue = dsHisA.Tables[0].Rows[0]["DeptID"].ToString();
GetEmpName(cmbDept); //姓名
cmbEmpName.Text = dsHisA.Tables[0].Rows[0]["EmployeeName"].ToString();
txtCodeSenderAddress.Text = dsHisA.Tables[0].Rows[0]["BlockID"].ToString();
ddlClassAdd.SelectedValue = dsHisA.Tables[0].Rows[0]["ClassID"].ToString();
dtpBeginTimeAdd.Text = dsHisA.Tables[0].Rows[0]["BeginWorkTime"].ToString();
dtpEndTimeAdd.Text = dsHisA.Tables[0].Rows[0]["EndWorkTime"].ToString();
txtRemarkAdd.Text = dsHisA.Tables[0].Rows[0]["Remark"].ToString();
ddlTimerIntervalAdd.Text = dsHisA.Tables[0].Rows[0]["ClassShortName"].ToString();
}
}
}
cmbDept.Enabled = false;
txtCodeSenderAddress.Enabled = false;
cmbEmpName.Enabled = false;
btnReset.Enabled = false;
}
}
void BindDataDataGridView()
{
string strWhere = string.Empty;
if (DeptTree.SelectedNode != null)
{
if (DeptTree.SelectedNode.Name != "0")
{
strWhere += " and D.DeptID = " + DeptTree.SelectedNode.Name;
}
}
if (ddlTimerInterval.SelectedValue.ToString().Trim() != "0")
{
strWhere += " and H.TimerIntervalID = " + ddlTimerInterval.SelectedValue.ToString();
}
if (txtBlock.Text.Trim() != "")
{
strWhere += " and H.BlockID = " + txtBlock.Text.ToString().Trim();
}
if (txtUserName.Text.Trim() != "")
{
strWhere += " and H.EmployeeName like '%" + txtUserName.Text.Trim() + "%'";
}
strWhere += " and H.DataAttendance>='" + dtpStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and H.DataAttendance<='" + dtpEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
//if (cmbSelectCounts.Text.ToString() == "")
//{
// intPageSize = 20;
//}
//else
//{
// intPageSize = Convert.ToInt32(cmbSelectCounts.SelectedItem.ToString());
//}
DataSet ds = aBLL.GetEmployeeAttendanceHistoryList(strWhere, intPageIndex, intPageSize, dtpStartTime.Value.ToString("yyyyM"), dtpEndTime.Value.ToString("yyyyM"), out strErr);
if (ds != null && ds.Tables.Count > 0)
{
// 重新设置页数
int sumPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
sumPage = sumPage % intPageSize != 0 ? sumPage / intPageSize + 1 : sumPage / intPageSize;
intPageCount = sumPage;
if (sumPage == 0)
{
dgrd.DataSource = ds.Tables[0];
lblCounts.Text = "共 0 条记录";
lblPageCounts.Text = "1";
lblSumPage.Text = "/1页";
btnUpPage.Enabled = false;
btnDownPage.Enabled = false;
}
else
{
ds.Tables[0].TableName = "A_AddHistoryAttendance";
dgrd.DataSource = ds.Tables[0];
lblCounts.Text = "共 " + ds.Tables[1].Rows[0][0].ToString() + " 条记录";
lblPageCounts.Text = intPageIndex.ToString();
lblSumPage.Text = "/" + sumPage + "页";
//控制翻页状态
SetPageEnable(intPageIndex, sumPage);
}
if (dgrd.Columns.Count >= 9)
{
int width = (dgrd.Width - 50 - 2) / (dgrd.Columns.Count - 6);
dgrd.Columns[1].Visible = false;
dgrd.Columns[2].HeaderText = "卡号";
dgrd.Columns[2].ReadOnly = true;
dgrd.Columns[2].Width = width;
dgrd.Columns[3].HeaderText = "姓名";
dgrd.Columns[3].ReadOnly = true;
dgrd.Columns[3].Width = width;
dgrd.Columns[4].Visible = false;
dgrd.Columns[5].Visible = false;
dgrd.Columns[6].HeaderText = "部门";
dgrd.Columns[6].ReadOnly = true;
dgrd.Columns[6].Width = width;
dgrd.Columns[7].HeaderText = "班次";
dgrd.Columns[7].ReadOnly = true;
dgrd.Columns[7].Width = width;
dgrd.Columns[8].HeaderText = "上班时间";
dgrd.Columns[8].ReadOnly = true;
dgrd.Columns[8].Width = width;
dgrd.Columns[9].HeaderText = "下班时间";
dgrd.Columns[9].ReadOnly = true;
dgrd.Columns[9].Width = width;
dgrd.Columns[10].Visible = false;
dgrd.Columns[11].Visible = false;
dgrd.Columns[12].HeaderText = "记工时间";
dgrd.Columns[12].ReadOnly = true;
dgrd.Columns[12].Width = width;
}
}
}
