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; } } }