public ActionResult JSDeleteFund(SubmitHandler handler)//删除响应
{
var s = X.GetCmp <Store>("FundStore");
string id;
Dictionary <string, string>[] values = JSON.Deserialize <Dictionary <string, string>[]>(handler.Json.ToString());
if (values.Length > 0)//js代码已经处理过，此处判断无用，可删
{
foreach (Dictionary <string, string> row in values)
{
id = row["ID"];
T_HR_Fund de = entities.T_HR_Fund.Find(id);
if (de != null)
{
//entities.T_HR_Fund.Remove(de);
de.Valid = false;
T_HR_Staff st = entities.T_HR_Staff.Find(de.StaffID);
st.FundValid = false;
try
{
entities.SaveChanges();
s.Remove(id);
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据删除失败！<br /> note:" + e.Message).Show();
}
}
}
}
else
{
X.Msg.Alert("提示", "未选择任何列！").Show();
}
return(this.Direct());
}
public ActionResult AddOrEditStaffJob(V_HR_StaffJobWithName staffJob)//AddstaffJob保存相应
{
DirectResult r = new DirectResult();
T_HR_StaffJob staffJobupdate = entities.T_HR_StaffJob.Find(staffJob.StaffJobID);
if (staffJobupdate == null)//为空为添加
{
T_HR_StaffJob staffJobadd = new T_HR_StaffJob();
staffJobadd.StaffJobID = Tool.ProduceSed64();
staffJobadd.StaffID = staffJob.StaffID;
staffJobadd.JobID = staffJob.JobID;
if (staffJob.ValidTime <= DateTime.Now.Date)//添加保存时可能存在两个有效职位,但是没有用到添加，员工职位的添加是在入职时设置的，那时还不存在该员工职位记录
{
staffJobadd.IsValid = true;
}
else
{
staffJobadd.IsValid = false;
}
staffJobadd.ValidTime = staffJob.ValidTime;
staffJobadd.Remark = staffJob.Remark;
staffJobadd.CreaterName = "admin";//后期改为用户名
staffJobadd.CreateTime = DateTime.Now;
entities.T_HR_StaffJob.Add(staffJobadd);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
T_HR_Staff s = entities.T_HR_Staff.Find(staffJob.StaffID);
s.StaffType = staffJob.StaffType;
T_HR_StaffJob staffJobadd = new T_HR_StaffJob();
staffJobadd.StaffJobID = Tool.ProduceSed64();
staffJobadd.StaffID = staffJob.StaffID;
staffJobadd.JobID = staffJob.JobID;
if (staffJob.ValidTime <= DateTime.Now.Date)
{
staffJobupdate.IsValid = false;
staffJobadd.IsValid = true;
}
else
{
staffJobupdate.IsValid = true;
staffJobadd.IsValid = false;
}
staffJobadd.ValidTime = staffJob.ValidTime;
staffJobadd.ChangeType = staffJob.ChangeType;
staffJobadd.Remark = staffJob.Remark;
staffJobadd.CreaterName = "admin";//后期改为用户名
staffJobadd.CreateTime = DateTime.Now;
entities.T_HR_StaffJob.Add(staffJobadd);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
public ActionResult JSDeleteDepartment(SubmitHandler handler)//删除响应
{
var s = X.GetCmp <Store>("DepartmentStore");
string id;
Dictionary <string, string>[] values = JSON.Deserialize <Dictionary <string, string>[]>(handler.Json.ToString());
if (values.Length > 0)//js代码已经处理过，此处判断无用，可删
{
if (IsDelete(values))
{
foreach (Dictionary <string, string> row in values)
{
id = row["ID"];
var dep = (from o in entities.V_HR_Dep
where o.ID == id
select o).First();
#region
if (dep.Level == "1")
{
T_HR_Department1 dep1 = entities.T_HR_Department1.Find(id);
if (dep1 != null)
{
//entities.T_HR_Contract.Remove(de);
dep1.Valid = false;
}
}
if (dep.Level == "2")
{
T_HR_Department2 dep2 = entities.T_HR_Department2.Find(id);
if (dep2 != null)
{
//entities.T_HR_Contract.Remove(de);
dep2.Valid = false;
}
}
if (dep.Level == "3")
{
T_HR_Department3 dep3 = entities.T_HR_Department3.Find(id);
if (dep3 != null)
{
//entities.T_HR_Contract.Remove(de);
dep3.Valid = false;
}
}
if (dep.Level == "4")
{
T_HR_Department4 dep4 = entities.T_HR_Department4.Find(id);
if (dep4 != null)
{
//entities.T_HR_Contract.Remove(de);
dep4.Valid = false;
}
}
if (dep.Level == "5")
{
T_HR_Department5 dep5 = entities.T_HR_Department5.Find(id);
if (dep5 != null)
{
//entities.T_HR_Contract.Remove(de);
dep5.Valid = false;
}
}
#endregion
var staffs = from o in entities.T_HR_Staff
where o.ID1 == id || o.ID2 == id || o.ID3 == id || o.ID4 == id || o.ID5 == id
select o;
foreach (var item in staffs)
{
T_HR_Staff staff = entities.T_HR_Staff.Find(item.StaffID);
staff.ID1 = null;
staff.ID2 = null;
staff.ID3 = null;
staff.ID4 = null;
staff.ID5 = null;
staff.Department = null;
}
try
{
entities.SaveChanges();
s.Remove(id);
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据删除失败！<br /> note:" + e.Message).Show();
}
}
}
else
{
X.Msg.Alert("警告", "不可删除存在下级部门的部门！").Show();
}
}
else
{
X.Msg.Alert("提示", "未选择任何列！").Show();
}
return(this.Direct());
}
public ActionResult AddOrEditFund(V_HR_Fund re)
{
DirectResult r = new DirectResult();
T_HR_Fund reupdate = entities.T_HR_Fund.Find(re.ID);
if (reupdate == null)//为空为添加
{
var ft = (from o in entities.V_HR_Fund
where o.StaffID == re.StaffID && o.Valid == true
select o).ToList();
if (!ft.Any())
{
T_HR_Fund readd = new T_HR_Fund();
readd.ID = Guid.NewGuid().ToString();
readd.StaffID = re.StaffID;
readd.StartDate = re.StartDate;
if (re.EndDate != null)
{
readd.EndDate = re.EndDate;
readd.Months = GetMonths(Convert.ToDateTime(re.StartDate), Convert.ToDateTime(re.EndDate));
}
//readd.Months = re.Months;
readd.Valid = true;
readd.Remark = re.Remark;
readd.CreaterName = new LoginUser().EmployeeId;
readd.CreateTime = DateTime.Now;
T_HR_Staff s = entities.T_HR_Staff.Find(re.StaffID);
s.FundValid = true;
entities.T_HR_Fund.Add(readd);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else
{
X.Msg.Alert("警告", "该员工基金记录已存在，不可重复添加！").Show();
return(this.Direct());
}
}
else//否则为修改
{
reupdate.StaffID = re.StaffID;
reupdate.StartDate = re.StartDate;
if (re.EndDate != null)
{
reupdate.EndDate = re.EndDate;
reupdate.Months = GetMonths(Convert.ToDateTime(re.StartDate), Convert.ToDateTime(re.EndDate));
}
//reupdate.Months = re.Months;
reupdate.Remark = re.Remark;
reupdate.Valid = true;
reupdate.EditorName = new LoginUser().EmployeeId;
reupdate.EditeTime = DateTime.Now;
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
public ActionResult AddOrEditDepartment(Department dep)//AddContract保存相应
{
V_HR_Dep testdep = entities.V_HR_Dep.Find(dep.ID);
dep.Level = GetLevel(dep.ID1, dep.ID2, dep.ID3, dep.ID4);
if (dep.Level != 0)
{
DirectResult r = new DirectResult();
if (testdep == null)//为空为添加
{
dep.ID = Tool.ProduceSed64();;
dep.Valid = true;
dep.CreaterName = new LoginUser().EmployeeId;
dep.CreateTime = DateTime.Now;
dep.PreID = GetPreID(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4);
if (dep.Level == 1)
{
entities.T_HR_Department1.Add(dep.ToDB1(1));
}
if (dep.Level == 2)
{
entities.T_HR_Department2.Add(dep.ToDB2(1));
}
if (dep.Level == 3)
{
entities.T_HR_Department3.Add(dep.ToDB3(1));
}
if (dep.Level == 4)
{
entities.T_HR_Department4.Add(dep.ToDB4(1));
}
if (dep.Level == 5)
{
entities.T_HR_Department5.Add(dep.ToDB5(1));
}
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
dep.EditorName = new LoginUser().EmployeeId;
dep.EditeTime = DateTime.Now;
dep.PreID = GetPreID(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4);
#region
if (testdep.Level == "1")
{
T_HR_Department1 dep1 = entities.T_HR_Department1.Find(dep.ID);
dep1.Department1No = dep.No;
dep1.Department1Name = dep.Name;
dep1.Remark = dep.Remark;
dep1.EditorName = dep.EditorName;
dep1.EditeTime = dep.EditeTime;
dep1.DOrder = dep.DOrder;
}
if (testdep.Level == "2")
{
T_HR_Department2 dep2 = entities.T_HR_Department2.Find(dep.ID);
dep2.Department2No = dep.No;
dep2.Department2Name = dep.Name;
dep2.Remark = dep.Remark;
dep2.EditorName = dep.EditorName;
dep2.EditeTime = dep.EditeTime;
dep2.DOrder = dep.DOrder;
}
if (testdep.Level == "3")
{
T_HR_Department3 dep3 = entities.T_HR_Department3.Find(dep.ID);
dep3.Department3No = dep.No;
dep3.Department3Name = dep.Name;
dep3.Remark = dep.Remark;
dep3.EditorName = dep.EditorName;
dep3.EditeTime = dep.EditeTime;
dep3.DOrder = dep.DOrder;
}
if (testdep.Level == "4")
{
T_HR_Department4 dep4 = entities.T_HR_Department4.Find(dep.ID);
dep4.Department4No = dep.No;
dep4.Department4Name = dep.Name;
dep4.Remark = dep.Remark;
dep4.EditorName = dep.EditorName;
dep4.EditeTime = dep.EditeTime;
dep4.DOrder = dep.DOrder;
}
if (testdep.Level == "5")
{
T_HR_Department5 dep5 = entities.T_HR_Department5.Find(dep.ID);
dep5.Department5No = dep.No;
dep5.Department5Name = dep.Name;
dep5.Remark = dep.Remark;
dep5.EditorName = dep.EditorName;
dep5.EditeTime = dep.EditeTime;
dep5.DOrder = dep.DOrder;
}
#endregion
string depname = GetDepartment(dep.Level, dep.ID1, dep.ID2, dep.ID3, dep.ID4, dep.Name);
var staffs = from o in entities.T_HR_Staff
where o.ID1 == dep.ID || o.ID2 == dep.ID || o.ID3 == dep.ID || o.ID4 == dep.ID || o.ID5 == dep.ID
select o;
foreach (var item in staffs)
{
T_HR_Staff staff = entities.T_HR_Staff.Find(item.StaffID);
staff.Department = depname;
}
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "修改成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据修改失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "上级部门不能跳过为空！").Show();
return(this.Direct());
}
}
