private void button1_Click(object sender, EventArgs e)
{
Model.Department depID = new Model.Department();
deleteDep.DepartmentName = deptName;
depID.DepartmentName = deptName;
Employee numEmp = new Employee();
numEmp.DepartmentId = dtc.GetDepartmentID(depID);
if (dtc.GetEmpNumInDep(numEmp) > 0)
{
Employee removeEmp = new Employee();
Employee intoEmp = new Employee();
removeEmp.DepartmentId = dtc.GetDepartmentID(depID);
depID.DepartmentName = cbDepartment.Text;
intoEmp.DepartmentId = dtc.GetDepartmentID(depID);
dtc.RemoveEmp(removeEmp, intoEmp);
}
dtc.DeleteDep(deleteDep);
Model.SystemEvent addEvent = new SystemEvent();
addEvent.EventDate = DateTime.Now.ToShortDateString();
addEvent.EventDescription = "删除成功";
dtc.AddEvent(addEvent);
MessageBox.Show("删除成功！");
Close();
}
public List<SystemEvent> SearchEvent(SystemEvent searchEvent)
{
var sea = (from s in hrContext.SystemEvent
where s.EventDate == searchEvent.EventDate
select s).ToList();
return sea;
}
private void BtnOK_Click(object sender, EventArgs e)
{
SystemEvent searchEvent = new SystemEvent();
if (DtpEnd.Value.Subtract(DtpStart.Value).Days>=0)//如果开始时间小于等于结束时间
{
//通过for循环获取连续时间段内每一天发生的事情并添加到数组中
for (DateTime dtStart = DtpStart.Value; dtStart <= DtpEnd.Value; dtStart = dtStart.AddDays(1))
{
searchEvent.EventDate = dtStart.ToShortDateString();
item.AddRange(dtc.SearchEvent(searchEvent));
}
}
Close();//关闭
}
private void btnOK_Click(object sender, EventArgs e)
{
Model.Department addDep = new Model.Department();
Model.SystemEvent addEvent = new SystemEvent();
dtc.name = txtDepartmentName.Text.Trim();
dtc.description = txtDepartmentDescription.Text.Trim();
dtc.Add(addDep);
addEvent.EventDescription = "添加部门成功！";
addEvent.EventDate = DateTime.Now.ToShortDateString();
dtc.AddEvent(addEvent);
MessageBox.Show("添加部门成功！", "消息：",MessageBoxButtons.OK );
txtDepartmentName.Clear();
txtDepartmentName.Focus();
}
private void btnNewEmployee_Click(object sender, EventArgs e)
{
Model.Employee addEmp = new Model.Employee();
Model.Employee modifyEmp = new Model.Employee();
SystemEvent addEvent = new SystemEvent();
SystemEvent modifyEvent = new SystemEvent();
if (isAddEmployee == true)
{
addEmp.EmployeeLoginName = txtLoginName.Text.Trim();//登录名
addEmp.EmployeeName = txtName.Text.Trim();//姓名
addEmp.EmployeePassword = txtPassword.Text.Trim();//登陆密码
addEmp.EmployeeEmail = txtEmail.Text.Trim();//邮箱
depID.DepartmentName = cbDepartment.Text.Trim();//部门名
addEmp.DepartmentId =dtc.GetDepartmentID(depID);//部门编号
if (txtBaseSalary.Text.Trim() != "") { dtc.baseSalary = Convert.ToInt32(txtBaseSalary.Text.Trim()); }//基本工资
addEmp.EmployeePostName = txtPosition.Text.Trim();//职位名
if (txtPhone.Text.Trim() != "")//手机号码
{
addEmp.EmployeePhone =txtPhone.Text.Trim();
}
if (numLevel.Text.Trim() != "")//级别
{
addEmp.Employee_Level_ = Convert.ToInt32(numLevel.Text.Trim());
}
addEmp.EmployeeRegisterDate = DateTime.Now.ToShortDateString();//注册时间
addEmp.EmployeePhoto = imageByte;//图片
dtc.AddEmp(addEmp);
addEvent.EventDescription = "新增员工:" + txtLoginName.Text.Trim();
addEvent.EventDate = DateTime.Now.ToShortDateString();
dtc.AddEvent(addEvent);
MessageBox.Show("添加成功！", "消息：", MessageBoxButtons.OK);
txtBaseSalary.Clear();
txtBirth.Clear();
txtEmail.Clear();
txtLoginName.Clear();
txtName.Clear();
txtPassword.Clear();
txtPhone.Clear();
txtPosition.Clear();
txtName.Focus();
}
else
{
modifyEmp.EmployeeId = employeeID;
modifyEmp.EmployeeLoginName = txtLoginName.Text.Trim();//登录名
modifyEmp.EmployeeName = txtName.Text.Trim();//姓名
modifyEmp.EmployeePassword = txtPassword.Text.Trim();//登陆密码
modifyEmp.EmployeeEmail = txtEmail.Text.Trim();//邮箱
depID.DepartmentName = cbDepartment.Text.Trim();//部门名
modifyEmp.DepartmentId = dtc.GetDepartmentID(depID);//部门编号
if (txtBaseSalary.Text.Trim() != "") { dtc.baseSalary = Convert.ToInt32(txtBaseSalary.Text.Trim()); }//基本工资
modifyEmp.EmployeePostName = txtPosition.Text.Trim();//职位名
if (txtPhone.Text.Trim() != "")//手机号码
{
modifyEmp.EmployeePhone = txtPhone.Text.Trim();
}
if (numLevel.Text.Trim() != "")//级别
{
modifyEmp.Employee_Level_ = Convert.ToInt32(numLevel.Text.Trim());
}
modifyEmp.EmployeePhoto = imageByte;//图片
dtc.ModifyEmp(modifyEmp);
modifyEvent.EventDescription = "原员工:" +name+"已改名为："+ txtLoginName.Text.Trim();
modifyEvent.EventDate = DateTime.Now.ToShortDateString();
dtc.ModifyEvent(modifyEvent);
MessageBox.Show("修改成功！", "消息：", MessageBoxButtons.OK);
}
}
public void LoginEvent(SystemEvent loginEvent)
{
dc.LoginEvent(loginEvent);
}
public List<SystemEvent> SearchEvent(SystemEvent searchEvent)
{
return dc.SearchEvent(searchEvent);
}
public void AddEvent(SystemEvent addEvent) { dc.AddEvent(addEvent); }
public void ModifyEvent(SystemEvent modifyEvent)
{
dc.ModifyEvent(modifyEvent);
}
partial void DeleteSystemEvent(SystemEvent instance);
partial void UpdateSystemEvent(SystemEvent instance);
partial void InsertSystemEvent(SystemEvent instance);
private void btnSetManger_Click(object sender, EventArgs e)
{
Employee levelUp = new Employee();
levelUp.EmployeeId = Convert.ToInt32(dgvDepartment.CurrentRow.Cells[0].Value);
levelUp.EmployeePostName = "经理";
levelUp.Employee_Level_ = 2;
SystemEvent addEvent = new SystemEvent();
addEvent.EventDescription = "任命"+ dgvDepartment.CurrentRow.Cells[1].Value + "为" + departName + "经理";
dtc.LevelUp(levelUp);
}
public void LoginEvent(SystemEvent loginEvent)//登录事件
{
try
{
hrContext.SubmitChanges();
}
catch(Exception ee) { throw ee; }
}
public void ModifyEvent(SystemEvent modifyEvent)
{
hrContext.SystemEvent.InsertOnSubmit(modifyEvent);
hrContext.SubmitChanges();
}
public void AddEvent(SystemEvent addEvent) { try {
hrContext.SystemEvent.InsertOnSubmit(addEvent);
hrContext.SubmitChanges(); }
catch (Exception ee) { throw ee; } }
