public JsonResult PayRaiseCheckSave(T_PersonnelPayRaiseApprove model) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_PersonnelPayRaiseApprove editModel = db.T_PersonnelPayRaiseApprove.Find(model.ID); editModel.Status = model.Status; editModel.ApproveTime = DateTime.Now; editModel.ApproveName = name; editModel.Memo = model.Memo; db.Entry <T_PersonnelPayRaiseApprove>(editModel).State = System.Data.Entity.EntityState.Modified; T_PersonnelPayRaise PayRaiseModel = db.T_PersonnelPayRaise.Find(editModel.PID); if (model.Status == 1)//同意 { int nextStep = editModel.Step + 1; List <T_PersonnelPayRaiseConfig> ConfigList = db.T_PersonnelPayRaiseConfig.Where(a => a.Step == nextStep).ToList(); if (ConfigList.Count > 0)//下一步 { PayRaiseModel.Status = 0; PayRaiseModel.Step = nextStep; PayRaiseModel.CurrentApproveName = ConfigList.First().Name; T_PersonnelPayRaiseApprove newApprove = new T_PersonnelPayRaiseApprove(); newApprove.ApproveName = ConfigList.First().Name; newApprove.PID = editModel.PID; newApprove.Status = 0; newApprove.Step = nextStep; db.T_PersonnelPayRaiseApprove.Add(newApprove); } else//结束 { T_PersonnelFile person = db.T_PersonnelFile.Find(PayRaiseModel.PFID); person.Salary = PayRaiseModel.PayRaise; db.Entry <T_PersonnelFile>(person).State = System.Data.Entity.EntityState.Modified; //修改档案表T_PersonnelFile薪资信息 PayRaiseModel.CurrentApproveName = ""; PayRaiseModel.Status = 1; PayRaiseModel.Step = 99; } } else//不同意结束 { PayRaiseModel.CurrentApproveName = ""; PayRaiseModel.Status = 2; PayRaiseModel.Step = 99; } db.Entry <T_PersonnelPayRaise>(PayRaiseModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
public string WorkNum()//生成员工编号 { T_PersonnelFile personnel = db.T_PersonnelFile.OrderByDescending(a => a.Code).FirstOrDefault(); string codestr = "010001"; if (personnel == null) { return(codestr); } else { int code = int.Parse(personnel.Code); int newcode = code + 1; codestr = "0" + newcode; } return(codestr); }
public ActionResult ViewPersonnelTransferApply() { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_PersonnelFile pModel = db.T_PersonnelFile.FirstOrDefault(a => a.NickName == name && a.IsDelete == 0 && a.OnJob == 0); T_PersonnelTransfer model = new T_PersonnelTransfer(); ViewData["approveList"] = getApproveName(1); ViewData["TransferType"] = TransferType(); ViewData["transferJob"] = ConfigList("岗位"); if (pModel != null) { model.Department = pModel.Department; model.Job = pModel.Job; model.Pid = pModel.ID; model.PostUser = name; return(View(model)); } else { model.Department = "您没有档案信息,无法申请转岗,请联系人事"; return(View(model)); } }
public JsonResult ResumeDistribute(int DID, int RID)//简历分配 { using (TransactionScope sc = new TransactionScope()) { try { T_PersonnelFile pModel = db.T_PersonnelFile.Find(RID); T_EmployDemand dModel = db.T_EmployDemand.Find(DID); dModel.DistributionNum += 1; //已分配数量+1 pModel.DemandID = DID; //档案存入分配需求ID db.Entry <T_PersonnelFile>(pModel).State = System.Data.Entity.EntityState.Modified; db.Entry <T_EmployDemand>(dModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult ViewPayRaiseApply() { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_User uModel = db.T_User.FirstOrDefault(a => a.Nickname == name); ViewData["approveList"] = getApproveName(1); //string deptID=uModel.DepartmentId; //string ApproveName = db.T_User.FirstOrDefault(a => a.DepartmentId == deptID).Nickname; T_PersonnelFile pModel = db.T_PersonnelFile.FirstOrDefault(a => a.NickName == name && a.IsDelete == 0 && a.OnJob == 0); T_PersonnelPayRaise model = new T_PersonnelPayRaise(); if (pModel != null) { model.PFID = pModel.ID; model.PostUser = name; //model.CurrentApproveName = ApproveName; return(View(model)); } else { model.Reason = "您没有档案信息,无法申请调薪,请联系人事"; return(View(model)); } }
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)); } }
public JsonResult ToRegularCheckSave(T_ToRegularApprove model, int Salary) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_ToRegularApprove editModel = db.T_ToRegularApprove.Find(model.ID); editModel.Status = model.Status; editModel.ApproveTime = DateTime.Now; editModel.ApproveName = name; editModel.Memo = model.Memo; db.Entry <T_ToRegularApprove>(editModel).State = System.Data.Entity.EntityState.Modified; T_ToRegularWorker ToRegularModel = db.T_ToRegularWorker.Find(editModel.PID); if (model.Status == 1) //同意 { int nextStep = editModel.Step + 1; List <T_ToRegularConfig> ConfigList = db.T_ToRegularConfig.Where(a => a.Step == nextStep).ToList(); if (ConfigList.Count > 0) //下一步 { ToRegularModel.Status = 0; ToRegularModel.Step = nextStep; ToRegularModel.Salary = Salary; ToRegularModel.CurrentApprove = ConfigList.First().Name; T_ToRegularApprove newApprove = new T_ToRegularApprove(); newApprove.ApproveName = ConfigList.First().Name; newApprove.PID = editModel.PID; newApprove.Status = 0; newApprove.Step = nextStep; db.T_ToRegularApprove.Add(newApprove); } else //结束 { T_PersonnelFile person = null; try { person = db.T_PersonnelFile.FirstOrDefault(a => a.NickName == ToRegularModel.PostName && a.IsDelete == 0 && a.OnJob == 0); person.Salary = Salary; person.Job = ToRegularModel.Job; person.isZhuanzheng = 1; db.Entry <T_PersonnelFile>(person).State = System.Data.Entity.EntityState.Modified; //修改档案表T_PersonnelFile薪资信息 } catch (Exception e) { return(Json(new { State = "Faile", Message = "请给该用户添加人事档案,或者给该用户人事档案完善花名信息" }, JsonRequestBehavior.AllowGet)); } ToRegularModel.CurrentApprove = ""; ToRegularModel.Status = 1; ToRegularModel.Step = 99; ToRegularModel.Salary = Salary; } } else //不同意结束 { ToRegularModel.CurrentApprove = ""; ToRegularModel.Status = 2; ToRegularModel.Step = 99; } db.Entry <T_ToRegularWorker>(ToRegularModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //ModularByZP(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
public JsonResult TransferCheckSave(T_PersonnelTransferApprove model, string nextApprove) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_PersonnelTransferApprove editModel = db.T_PersonnelTransferApprove.Find(model.ID); editModel.Status = model.Status; editModel.ApproveDate = DateTime.Now; editModel.ApproveName = name; editModel.Memo = model.Memo; db.Entry <T_PersonnelTransferApprove>(editModel).State = System.Data.Entity.EntityState.Modified; T_PersonnelTransfer TransferModel = db.T_PersonnelTransfer.Find(editModel.PTID); if (model.Status == 1)//同意 { int nextStep = editModel.Step + 1; List <T_PersonnelTransferConfig> ConfigList = db.T_PersonnelTransferConfig.Where(a => a.Step == nextStep).ToList(); if (ConfigList.Count > 0)//下一步 { TransferModel.Status = 0; TransferModel.Step = nextStep; TransferModel.CurrentApprove = nextApprove; T_PersonnelTransferApprove newApprove = new T_PersonnelTransferApprove(); if (nextApprove != "") { newApprove.ApproveName = nextApprove; } else { newApprove.ApproveName = ConfigList.First().Name; } newApprove.PTID = editModel.PTID; newApprove.Status = 0; newApprove.Step = nextStep; db.T_PersonnelTransferApprove.Add(newApprove); } else//结束 { T_PersonnelFile person = db.T_PersonnelFile.Find(TransferModel.Pid); person.Job = TransferModel.TransJob; person.Department = TransferModel.TransDepartment; //还需要修改user的departmentID信息 TransferModel.Status = 1; TransferModel.Step = 99; TransferModel.TransferDate = DateTime.Now; } } else//不同意结束 { TransferModel.Status = 2; TransferModel.Step = 99; } db.Entry <T_PersonnelTransfer>(TransferModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //ModularByZP(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } }
} //简历新增 public JsonResult InterviewEditSave(T_PersonnelInterviewRecord model, string NextInterviewer) { using (TransactionScope sc = new TransactionScope()) { try { string name = Server.UrlDecode(Request.Cookies["NickName"].Value); T_PersonnelInterviewRecord editModel = db.T_PersonnelInterviewRecord.Find(model.ID); editModel.State = model.State; editModel.Memo = model.Memo; editModel.Interviewer = name; editModel.Date = DateTime.Now; db.Entry <T_PersonnelInterviewRecord>(editModel).State = System.Data.Entity.EntityState.Modified; T_PersonnelFile perModel = db.T_PersonnelFile.Find(editModel.PID); if (model.State == 1) { if (NextInterviewer != "结束") //进入下一轮面试 { T_PersonnelInterviewRecord newRecord = new T_PersonnelInterviewRecord(); newRecord.Interviewer = NextInterviewer; newRecord.Memo = ""; newRecord.PID = editModel.PID; newRecord.State = 0; newRecord.Step = editModel.Step + 1; db.T_PersonnelInterviewRecord.Add(newRecord); perModel.CurrentInterviewer = NextInterviewer; perModel.InterviewStep = newRecord.Step; perModel.InterviewState = 0; } else //面试通过 { perModel.CurrentInterviewer = ""; perModel.InterviewStep = 99; perModel.InterviewState = 1; //发送短信 //string[] msg = { "恭喜您通过面试" }; //Lib.SendSMS.Send(msg, "15608486578"); } } else //面试不通过 { perModel.CurrentInterviewer = ""; perModel.InterviewStep = 99; perModel.InterviewState = 2; } db.Entry <T_PersonnelFile>(perModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //ModularByZP(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (DbEntityValidationException e) { return(Json(new { State = "Faile", Message = e.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage }, JsonRequestBehavior.AllowGet)); } } }
public JsonResult ResumeAddSave(EmploymentRegistration model) { using (TransactionScope sc = new TransactionScope()) { try { T_PersonnelFile PerFile = model.perInfo; PerFile.IsDelete = 0; PerFile.ApplyDate = DateTime.Now; PerFile.Code = ""; PerFile.NickName = ""; PerFile.OnJob = -1; PerFile.online = "电子商务部"; PerFile.InterviewState = -1; PerFile.InterviewStep = 1; PerFile.isZhuanzheng = 0; PerFile.CurrentInterviewer = db.T_PersonnelInterviewConfig.FirstOrDefault(a => a.Step == 1 && a.Type == "面试官").Name; db.T_PersonnelFile.Add(PerFile); db.SaveChanges(); T_PersonnelInterviewRecord InterviewRecord = new T_PersonnelInterviewRecord(); InterviewRecord.Interviewer = PerFile.CurrentInterviewer; InterviewRecord.PID = PerFile.ID; InterviewRecord.State = 0; InterviewRecord.Memo = ""; InterviewRecord.Step = 1; db.T_PersonnelInterviewRecord.Add(InterviewRecord); db.SaveChanges(); foreach (var EduBackgroud in model.EduBackgroud) { if (!string.IsNullOrWhiteSpace(EduBackgroud.School)) { EduBackgroud.PID = PerFile.ID; db.T_PersonnelEduBackgroud.Add(EduBackgroud); } } foreach (var WorkExperience in model.WorkExperience) { if (!string.IsNullOrWhiteSpace(WorkExperience.Job)) { WorkExperience.PID = PerFile.ID; db.T_PersonnelWorkExperience.Add(WorkExperience); } } foreach (var Family in model.Family) { if (!string.IsNullOrWhiteSpace(Family.Name)) { Family.Pid = PerFile.ID; db.T_PersonnelFamily.Add(Family); } } db.SaveChanges(); //ModularByZP(); sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { State = "Faile", Message = e.Message }, JsonRequestBehavior.AllowGet)); } } } //简历新增
public JsonResult JoinedCheck(int id, int status, string memo) { using (TransactionScope sc = new TransactionScope()) { try { T_JoinedApprove modelApprove = db.T_JoinedApprove.SingleOrDefault(a => a.Oid == id && a.ApproveTime == null); string curName = Server.UrlDecode(Request.Cookies["Name"].Value); string result = ""; if (modelApprove == null) { return(Json("数据可能被删除", JsonRequestBehavior.AllowGet)); } modelApprove.Memo = memo; modelApprove.ApproveTime = DateTime.Now; modelApprove.Status = status; db.Entry <T_JoinedApprove>(modelApprove).State = System.Data.Entity.EntityState.Modified; int i = db.SaveChanges(); if (i > 0) { T_Joined model = db.T_Joined.Find(id); T_JoinedApprove newApprove = new T_JoinedApprove(); if (model == null) { return(Json("数据可能被删除", JsonRequestBehavior.AllowGet)); } if (status == 1) { //同意 int step = int.Parse(model.Step.ToString()); step++; IQueryable <T_JoinedApproveConfig> config = db.T_JoinedApproveConfig.AsQueryable(); int stepLength = config.Count();//总共步骤 if (step < stepLength) { //不是最后一步,主表状态为0 =>审核中 model.Status = 0; T_JoinedApproveConfig stepMod = db.T_JoinedApproveConfig.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_JoinedApprove.Add(newApprove); //T_JoinedApproveConfig stepMods = db.T_JoinedApproveConfig.SingleOrDefault(a => a.Step == step); //string Name = stepMods.Name; //发送短信给下一步审核人 T_User UserModel = db.T_User.SingleOrDefault(a => a.Name == nextName); if (UserModel != null && UserModel.Tel != null) { string[] msg = new string[] { "你有一条入职未审批:请及时审核," }; string res = Lib.SendSMS.Send(msg, "162067", UserModel.Tel); } db.SaveChanges(); } else { //最后一步,主表状态改为 1 => 同意 model.Status = status; T_Department deptModel = db.T_Department.FirstOrDefault(a => a.Name == model.Department); //找到部门 if (deptModel == null) //如果没有就放在好护士下 { deptModel = db.T_Department.Find(1); } T_User used = db.T_User.FirstOrDefault(a => a.Nickname == model.Nickname); //入职时该员工未建立账号的 T_User newUser = new T_User(); //新建一个账号 int UserId = 0; if (used == null) { newUser.DepartmentId = deptModel.ID.ToString(); newUser.IsManagers = "0"; newUser.Name = model.Name; newUser.Nickname = model.Nickname; newUser.PassWord = "******"; newUser.Power = ""; newUser.Tel = model.Tel; db.T_User.Add(newUser); db.SaveChanges(); string uIDstr = "";//给部门添加员工ID uIDstr = "," + newUser.ID; deptModel.employees += uIDstr; db.Entry <T_Department>(deptModel).State = System.Data.Entity.EntityState.Modified; addEmployeesToDepartmentForEidt(deptModel.ID, newUser.ID.ToString()); UserId = newUser.ID; } else { UserId = used.ID; } if (model.PID > 0)//修改档案信息 { T_PersonnelFile pModel = db.T_PersonnelFile.Find(model.PID); pModel.Department = model.Department; pModel.Job = model.Job; pModel.OnJob = 0; pModel.oid = UserId; pModel.Hiredate = model.Hiredate; pModel.Probation = model.Probation; pModel.ProbationSalary = model.ProbationSalary; // pModel.Salary = model.Salary; pModel.ContractFirstDeadline = model.ContractFirstDeadline; pModel.ContractFirstStartTime = model.ContractFirstStartTime; pModel.Code = WorkNum(); string DataStr = ""; #region 给DataStr赋值(入职资料) if (model.DataUserRegister) { if (DataStr == "") { DataStr += "员工登记"; } else { DataStr += ",员工登记"; } } if (model.DataPost) { if (DataStr == "") { DataStr += "应聘申请"; } else { DataStr += ",应聘申请"; } } if (model.DataResult) { if (DataStr == "") { DataStr += "简历"; } else { DataStr += ",简历"; } } if (model.DataIdcard) { if (DataStr == "") { DataStr += "身份证复印"; } else { DataStr += ",身份证复印"; } } if (model.DataQualifications) { if (DataStr == "") { DataStr += "学历证书"; } else { DataStr += ",学历证书"; } } if (model.DataPhoto) { if (DataStr == "") { DataStr += "寸照"; } else { DataStr += ",寸照"; } } if (model.DataDrivingLicense) { if (DataStr == "") { DataStr += "驾驶证"; } else { DataStr += ",驾驶证"; } } if (model.DataExaminationReport) { if (DataStr == "") { DataStr += "体检报告"; } else { DataStr += ",体检报告"; } } #endregion pModel.EntryData = DataStr; pModel.NickName = model.Nickname; db.Entry <T_PersonnelFile>(pModel).State = System.Data.Entity.EntityState.Modified; } } model.Step = step; db.Entry <T_Joined>(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_Joined>(model).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //审核流程结束 申请人编辑后插入下一条记录 result = "保存成功"; } } else { result = "保存失败"; } // ModularByZP(); sc.Complete(); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json("保存失败", JsonRequestBehavior.AllowGet)); } } }