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