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 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);
}
