public ContentResult UnCheckQuitList(Lib.GridPager pager, string queryStr)
{
string name = Server.UrlDecode(Request.Cookies["Name"].Value);
List <T_QuitApprove> ApproveMod = db.T_QuitApprove.Where(a => a.ApproveName == name && a.ApproveTime == null).ToList();
int[] Arry = new int[ApproveMod.Count];
for (int i = 0; i < ApproveMod.Count; i++)
{
Arry[i] = int.Parse(ApproveMod[i].Oid.ToString());
}
IQueryable <T_Quit> queryData = from r in db.T_Quit
where Arry.Contains(r.ID) && r.IsDelete == 0 && (r.Status == -1 || r.Status == 0 || r.Status == 2)
select r;
if (!string.IsNullOrEmpty(queryStr))
{
queryData = queryData.Where(a => a.Code != null && a.Code.Contains(queryStr) || a.PostUser != null && a.PostUser.Contains(queryStr));
}
pager.totalRows = queryData.Count();
//分页
queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows);
List <T_Quit> list = new List <T_Quit>();
foreach (var item in queryData)
{
T_Quit i = new T_Quit();
i = item;
list.Add(i);
}
string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}";
return(Content(json));
}
public ContentResult ShowQuitList(Lib.GridPager pager, string queryStr, int status)
{
string name = Server.UrlDecode(Request.Cookies["Name"].Value);
IQueryable <T_Quit> queryData = db.T_Quit.Where(a => a.IsDelete == 0);
if (!string.IsNullOrEmpty(queryStr))
{
queryData = queryData.Where(a => a.Code != null && a.Code.Contains(queryStr) || (a.PostUser != null && a.PostUser.Contains(queryStr)));
}
if (status != 9999)
{
queryData = queryData.Where(a => a.Status == status);
}
pager.totalRows = queryData.Count();
//分页
queryData = queryData.OrderByDescending(c => c.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows);
List <T_Quit> list = new List <T_Quit>();
foreach (var item in queryData)
{
T_Quit i = new T_Quit();
i = item;
list.Add(i);
}
string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(list, Lib.Comm.setTimeFormat()) + "}";
return(Content(json));
}
public ActionResult ViewQuitEdit(int ID)
{
T_Quit MOD = db.T_Quit.Find(ID);
if (MOD == null)
{
return(HttpNotFound());
}
//审批批号绑定
ViewData["Code"] = MOD.Code;
//用户花名绑定
string Nickname = Server.UrlDecode(Request.Cookies["Nickname"].Value);
string Name = Server.UrlDecode(Request.Cookies["Name"].Value);
ViewData["Nickname"] = Nickname;
ViewData["Name"] = Name;
//用户部门绑定
T_User UserModel = db.T_User.SingleOrDefault(a => a.Nickname == Nickname);
int DepartmentId = int.Parse(UserModel.DepartmentId);
T_Department dModel = db.T_Department.SingleOrDefault(a => a.ID == DepartmentId);
ViewData["PostDepartment"] = dModel.Name;
//一级审核人
ViewData["FirstApprove"] = GetFisrtNameForApprove();
ViewData["MyUser"] = MOD.FirstApprove;
//离职日期
ViewData["Time"] = MOD.QuitTime;
//我的固定资产
ViewData["Assets"] = GetMyAssets(Name);
//我的借支
ViewData["Borrow"] = GetMyBorrow(Nickname);
return(View(MOD));
}
public JsonResult VoidQuit(int ID)
{
T_Quit model = db.T_Quit.Find(ID);
model.Status = 3;
db.Entry <T_Quit>(model).State = System.Data.Entity.EntityState.Modified;
int i = db.SaveChanges();
ModularByZL();
return(Json(i, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewQuitHistory(int ID)
{
T_Quit model = db.T_Quit.Find(ID);
if (model == null)
{
return(HttpNotFound());
}
GetApproveHistory(ID);
return(View(model));
}
public ActionResult ViewQuitCheck(int ID)
{
T_Quit model = db.T_Quit.Find(ID);
if (model == null)
{
return(HttpNotFound());
}
GetApproveHistory(ID);
ViewData["approveid"] = ID;
return(View(model));
}
public JsonResult QuitAddSave(T_Quit model, string jsonStr)
{
using (TransactionScope sc = new TransactionScope())
{
try
{
//主表保存
model.IsDelete = 0;
model.Step = 0;
model.Status = -1;
model.PostTime = DateTime.Now;
db.T_Quit.Add(model);
int i = db.SaveChanges();
if (i > 0)
{
//审核保存
T_QuitApprove modelApprove = new T_QuitApprove();
modelApprove.Status = -1;
modelApprove.Memo = "";
modelApprove.Oid = model.ID;
modelApprove.ApproveName = model.FirstApprove;
db.T_QuitApprove.Add(modelApprove);
db.SaveChanges();
//附件保存
if (!string.IsNullOrEmpty(jsonStr))
{
List <T_QuitOptions> details = Deserialize <T_QuitOptions>(jsonStr);
foreach (var item in details)
{
item.Oid = model.ID;
db.T_QuitOptions.Add(item);
}
db.SaveChanges();
}
ModularByZL();
sc.Complete();
return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { State = "Faile", Message = "保存失败" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult ViewQuitDetail(int ID)
{
T_Quit model = db.T_Quit.Find(ID);
if (model == null)
{
return(HttpNotFound());
}
string Name = model.PostUser;
T_User userModel = db.T_User.SingleOrDefault(a => a.Name == Name);
string Nickname = userModel.Nickname;
//我的固定资产
ViewData["Assets"] = GetMyAssets(Name);
//我的借支
ViewData["Borrow"] = GetMyBorrow(Nickname);
GetApproveHistory(ID);
return(View(model));
}
public JsonResult QuitEditSave(T_Quit model, string jsonStr, int ID)
{
using (TransactionScope sc = new TransactionScope())
{
try
{
//主表修改
int editStatus = model.Status; //原记录的状态
int editID = model.ID; //原记录的ID
T_Quit modelQuit = db.T_Quit.Find(ID);
modelQuit.Memo = model.Memo;
modelQuit.PostUser = model.PostUser;
modelQuit.QuitTime = model.QuitTime;
modelQuit.AssetsCode = model.AssetsCode;
modelQuit.BorrowCode = model.BorrowCode;
modelQuit.FirstApprove = model.FirstApprove;
modelQuit.QuitTime = model.QuitTime;
modelQuit.Reason = model.Reason;
modelQuit.WageAccount = model.WageAccount;
modelQuit.WageAccountName = model.WageAccountName;
modelQuit.WageBank = model.WageBank;
modelQuit.WorkAccount = model.WorkAccount;
db.Entry <T_Quit>(modelQuit).State = System.Data.Entity.EntityState.Modified;
int i = db.SaveChanges();
if (i > 0)
{
//审核保存 不同意修改 新添加一条审核记录。未审核的则不添加而是修改
T_QuitApprove Approvemodel = db.T_QuitApprove.SingleOrDefault(a => a.Oid == editID && a.ApproveTime == null);
if (Approvemodel == null)
{
//不同意 修改
T_QuitApprove modelApprove = new T_QuitApprove();
modelApprove.Status = -1;
modelApprove.Memo = "";
modelApprove.Oid = model.ID;
modelApprove.ApproveName = model.FirstApprove;
db.T_QuitApprove.Add(modelApprove);
db.SaveChanges();
}
else
{
//新增修改
Approvemodel.ApproveName = model.FirstApprove;
db.Entry <T_QuitApprove>(Approvemodel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//附件保存 先删除原有的附件
List <T_QuitOptions> delMod = db.T_QuitOptions.Where(a => a.Oid == editID).ToList();
foreach (var item in delMod)
{
db.T_QuitOptions.Remove(item);
}
db.SaveChanges();
if (!string.IsNullOrEmpty(jsonStr))
{
List <T_QuitOptions> details = Deserialize <T_QuitOptions>(jsonStr);
foreach (var item in details)
{
item.Oid = model.ID;
db.T_QuitOptions.Add(item);
}
db.SaveChanges();
}
ModularByZL();
sc.Complete();
return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { State = "Faile", Message = "保存失败" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult QuitCheck(int id, int status, string memo)
{
using (TransactionScope sc = new TransactionScope())
{
T_QuitApprove modelApprove = db.T_QuitApprove.SingleOrDefault(a => a.Oid == id && a.ApproveTime == null);
string curName = Server.UrlDecode(Request.Cookies["Name"].Value);
string nikeName = Server.UrlDecode(Request.Cookies["Nickname"].Value);
string result = "";
if (modelApprove == null)
{
return(Json("数据可能被删除", JsonRequestBehavior.AllowGet));
}
modelApprove.Memo = memo;
modelApprove.ApproveTime = DateTime.Now;
modelApprove.Status = status;
db.Entry <T_QuitApprove>(modelApprove).State = System.Data.Entity.EntityState.Modified;
int i = db.SaveChanges();
if (i > 0)
{
T_Quit model = db.T_Quit.Find(id);
T_QuitApprove newApprove = new T_QuitApprove();
if (model == null)
{
return(Json("数据可能被删除", JsonRequestBehavior.AllowGet));
}
if (status == 1)
{
//同意
int step = int.Parse(model.Step.ToString());
step++;
IQueryable <T_QuitApproveConfig> config = db.T_QuitApproveConfig.AsQueryable();
int stepLength = config.Count();//总共步骤
if (step < stepLength)
{
//不是最后一步，主表状态为0 =>审核中
model.Status = 0;
T_QuitApproveConfig stepMod = db.T_QuitApproveConfig.SingleOrDefault(a => a.Step == step);
string nextName = stepMod.Name;
//下一步审核人不是null 审核记录插入一条新纪录
newApprove.Memo = "";
newApprove.Oid = id;
newApprove.Status = -1;
if (nextName != null)
{
newApprove.ApproveName = nextName;
}
db.T_QuitApprove.Add(newApprove);
db.SaveChanges();
}
else
{
//最后一步，主表状态改为 1 => 同意
model.Status = status;
//人事档案改为离职
T_PersonnelFile MOD_Person = db.T_PersonnelFile.FirstOrDefault(a => a.TrueName == model.PostUser);
if (MOD_Person == null)
{
return(Json("保存失败", JsonRequestBehavior.AllowGet));
}
MOD_Person.OnJob = 1;
MOD_Person.QuitDate = DateTime.Now.ToString();
db.Entry <T_PersonnelFile>(MOD_Person).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
model.Step = step;
db.Entry <T_Quit>(model).State = System.Data.Entity.EntityState.Modified;
int j = db.SaveChanges();
if (j > 0)
{
result = "保存成功";
}
else
{
result = "保存失败";
}
}
else
{
//不同意
model.Step = 0;
model.Status = 2;
db.Entry <T_Quit>(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//审核流程结束 申请人编辑后插入下一条记录
result = "保存成功";
}
}
else
{
result = "保存失败";
}
ModularByZL();
sc.Complete();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
