/* * 事件 */ #region [ 方法: DataGridView数据绑定 ] void BindDataGridView() { lblErr.Text = ""; if (txtBlock.Text.ToString() != "") { try { Convert.ToInt32(txtBlock.Text); } catch { lblCounts.ForeColor = Color.Red; lblCounts.Text = "卡号只能为数字!"; return; } } if (txtStandardTime.Text == "") { lblCounts.ForeColor = Color.Red; lblCounts.Text = "额定工时不能为空!"; return; } if (this.txtStandardTime.Text.ToString() != "") { try { Convert.ToInt32(this.txtStandardTime.Text); } catch { lblCounts.ForeColor = Color.Red; lblCounts.Text = "额定工时只能为数字!"; return; } } string strWhere = " and DataAttendance >='" + dtpStartTime.Text.ToString() + "' and DataAttendance <='" + dtpEndTime.Text.ToString() + "'"; if (ddlDept.SelectedValue.ToString() != "0") { strWhere = strWhere + " and DeptID = " + ddlDept.SelectedValue.ToString(); } if (txtEmployeeName.Text.ToString() != "") { strWhere = strWhere + " and EmployeeName = '" + txtEmployeeName.Text.ToString() + "'"; } if (txtBlock.Text.ToString() != "") { strWhere = strWhere + " and BlockID = " + txtBlock.Text.ToString(); } DataSet ds = aBLL.GetAttendanceSalary(strWhere, Convert.ToInt32(txtStandardTime.Text), out strErr); if (strErr.ToString() == "Succeeds") { ds.Tables[0].Columns[2].ColumnName = HardwareName.Value(CorpsName.CodeSenderAddress); dgrd.DataSource = ds.Tables[0]; lblCounts.ForeColor = Color.Blue; lblCounts.Text = "共有 " + ds.Tables[0].Rows.Count.ToString() + " 条记录"; } }