private void btnBrowse_Click(object sender, EventArgs e)
{
clsUser user = new clsUser();
FrmCheckAttendenceLog frm = new FrmCheckAttendenceLog(ENo, 1, OperatorNo, user);
frm.Owner = this;
frm.ShowDialog();
this.txtNo.Text = user.Eno.ToString();
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
int count = 0;
string sql = "select count(*) from t_salary";
count = (int)DAO.ExecuteScalar(sql);
if (count <= 0)
{
MessageBox.Show("无工资记录！");
return;
}
else
{
FrmCheckAttendenceLog frm = new FrmCheckAttendenceLog(Eno, 2);
frm.ShowDialog();
}
}
private void btnBrowseAttendence_Click(object sender, EventArgs e)
{
if (txtNo.Text == null || txtNo.Text == "")
{
MessageBox.Show("请重新选择员工！");
return;
}
else
{
ENo = int.Parse(txtNo.Text.Trim());
string sql = String.Format("select count(*) from t_CheckRecord where Eno='{0}' and CONVERT(varchar(20), OffWorkTime, 120) like '{1}%'", ENo, DateTime.Now.ToShortDateString().Substring(0, 7));
int count = (int)DAO.ExecuteScalar(sql);
if (count <= 0)
{
MessageBox.Show("本月没有职工考勤记录！");
return;
}
else
{
FrmCheckAttendenceLog frm = new FrmCheckAttendenceLog(ENo, 0);
frm.ShowDialog();
}
}
}