private void Btn_LoadData_Click(object sender, EventArgs e)
{
if (lc == null)
{
lc = new LoadCheck(Doper.Depts, dc, Doper.GetDeptName);
}
var checks = lc.GetCheckList(out DateTime beginDate, out DateTime endDate);
var users = dc.USERINFO.ToList();
var Acc = new AttControlClass(dc);
Emps = new List <EmpCheckMonth>();
checks.ForEach(p =>
{
var eobj = Emps.Where(o => o.Emp.USERID == p.USERID).SingleOrDefault();
if (eobj == null)
{
var user = users.Where(u => u.USERID == p.USERID).Single();
eobj = new EmpCheckMonth(user, Acc, new DeptOper(dc).GetDeptName);
eobj.Shifts = this.Shifts;
eobj.SetDate(beginDate, endDate);
Emps.Add(eobj);
}
eobj.Add(p);
});
Emps.ForEach(p => p.SetShifts());
var list = Emps.OrderByDescending(p => p.DeptName).ThenBy(p => p.EmpId).ToList();
empCheckMonthBindingSource.DataSource = new BindingCollection <EmpCheckMonth>(list);
YearHoliday.Value = 0;
}
private void ToolStripButton1_Click(object sender, EventArgs e)
{
if (!IsConnect)
{
string dbcon = tool_con.Text;
if (dbcon != "")
{
dc = new attContent(dbcon);
dc.ConName = dbcon;
Doper = new DeptOper(dc);
ReadShift();
toolStripButton1.Text = "关闭连接";
IsConnect = true;
}
else
{
MessageBox.Show("请选择数据库连接!");
}
}
else
{
dc.Dispose();
textBox2.Text = "";
lc = null;
Doper = null;
toolStripButton1.Text = "连接数据库";
IsConnect = false;
empCheckMonthBindingSource.DataSource = null;
empCheckDayBindingSource.DataSource = null;
shiftBindingSource.DataSource = null;
}
tool_con.Enabled = !IsConnect;
tabControl1.Enabled = IsConnect;
btn_LoadData.Enabled = IsConnect;
btn_SyncCheck.Enabled = IsConnect;
modeselect.Enabled = IsConnect;
BtnWriteToDb.Enabled = IsConnect;
}
