/*
* 事件
*/
#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() + " 条记录";
}
}
