public ActionResult JSDeleteWorkOverTime(SubmitHandler handler)//删除响应
{
var s = X.GetCmp <Store>("WorkOverTimeStore");
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_WorkOverTime de = entities.T_HR_WorkOverTime.Find(id);
if (de != null)
{
de.Valid = false;
//entities.T_HR_WorkOverTime.Remove(de);
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 AddOrEditWorkOverTime(V_HR_WorkOverTime wot)
{
DirectResult r = new DirectResult();
T_HR_WorkOverTime wotupdate = entities.T_HR_WorkOverTime.Find(wot.ID);
if (wotupdate == null)//为空为添加
{
var list = from o in entities.T_HR_WorkOverTime
where o.StaffID == wot.StaffID && o.Year == wot.Year
select o;
if (!list.Any())
{
T_HR_WorkOverTime wotadd = new T_HR_WorkOverTime();
wotadd.ID = Guid.NewGuid().ToString();
wotadd.StaffID = wot.StaffID;
wotadd.Year = wot.Year;
wotadd.LastYear = wot.LastYear;
wotadd.CurrentYear = wot.CurrentYear;
wotadd.CurrentYearSum = wot.LastYear + wot.CurrentYear;
wotadd.Personal = wot.Personal;
wotadd.Company = wot.Company;
wotadd.CurrentYearLast = wot.LastYear + wot.CurrentYear - wot.Personal - wot.Company;
wotadd.Valid = true;
wotadd.CreaterName = new LoginUser().EmployeeId;
wotadd.CreateTime = DateTime.Now;
entities.T_HR_WorkOverTime.Add(wotadd);
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();
r.Success = false;
}
}
else//否则为修改
{
wotupdate.Year = wot.Year;
wotupdate.LastYear = wot.LastYear;
wotupdate.CurrentYear = wot.CurrentYear;
wotupdate.CurrentYearSum = wot.LastYear + wot.CurrentYear;
wotupdate.Personal = wot.Personal;
wotupdate.Company = wot.Company;
wotupdate.CurrentYearLast = wot.LastYear + wot.CurrentYear - wot.Personal - wot.Company;
wotupdate.EditorName = new LoginUser().EmployeeId;
wotupdate.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);
}
