/// <summary> /// 返回审批配置对象 /// </summary> /// <param name="placed"></param> /// <returns></returns> public ApproveCourse GetApproveCoursesList(int placed) { var db = SugerBase.GetInstance(); ApproveCourse approveCourse = db.Queryable <ApproveCourse>().Where(m => m.ID == placed).Single(); return(approveCourse); }
/// <summary> /// 审核通过 /// </summary> /// <param name="id"></param> /// <param name="bussiness"></param> /// <returns></returns> public IActionResult PassApprove(int id, int bussiness, int inStanceId) { string user = HttpContext.Session.GetString("user"); UserAndRole userAndRole = JsonConvert.DeserializeObject <UserAndRole>(user); int userID = userAndRole.ID; Approve approve = _approve.GetApproveById(id); Instance instance = _policeCase.GetInstanceById(inStanceId); ApproveCourse approveCourse = new ApproveCourse(); if (approve.PlaceID != 0) { approveCourse = _approve.GetApproveCoursesList(approve.PlaceID); string str = approveCourse.Condition; if (!str.Contains(instance.InstanceState.ToString())) { approve.PlaceID = 0; } } //approve.Ideas = ""; //approve.State = "2"; //approve.ApprovePeopleId = userID; //approve.Time = DateTime.Now; //int i = _approve.UpdateApprove(approve); //if (i > 0) //{ if (approve.PlaceID == 0) { approve.Ideas = ""; approve.State = "2"; approve.ApprovePeopleId = userID; approve.Time = DateTime.Now; int result = _approve.UpdateApprove(approve); if (result > 0) { //Instance instance = _policeCase.GetInstanceById(inStanceId); instance.ApproveState = 2; int a = _policeCase.UpdateinStance(instance); if (a > 0) { return(Content("<script>alert('审核通过!');location.href='/BackWebSet/Index'</script>", "text/html;charset=utf-8")); } } } else { //ApproveCourse approveCourse = _approve.GetApproveCoursesList(approve.PlaceID); //Approve approves = new Approve() { BusinesstypeId = approve.BusinesstypeId, OriginalId = approve.OriginalId, PlaceID = approveCourse.PostpositionID, RoleId = approveCourse.ApproveRoleId, State = "1" }; approve.PlaceID = approveCourse.PostpositionID; approve.RoleId = approveCourse.ApproveRoleId; int result = _approve.UpdateApprove(approve); if (result > 0) { return(Content("<script>alert('您的审核通过!正在进行下一级审核');location.href='/BackWebSet/Index'</script>", "text/html;charset=utf-8")); } } //} return(View()); }
/// <summary> /// 添加案件时添加审批表并返回 /// </summary> /// <param name="instance"></param> /// <returns></returns> public Approve GetApprove(Instance instance) { var db = SugerBase.GetInstance(); List <ApproveCourse> course = db.SqlQueryable <ApproveCourse>("select * from ApproveCourse where Condition like '%" + instance.InstanceState + "%' and BusinesstypeId=" + instance.InstanceTypes).ToList(); ApproveCourse approveCourse = course[0]; //ApproveCourse approveCourse= db.Queryable<ApproveCourse>().Where(m => (m.Condition.Contains(instance.InstanceState.ToString()) && m.BusinesstypeId == Convert.ToInt32(instance.InstanceTypes))).Single(); Approve approve = new Approve() { RoleId = approveCourse.ApproveRoleId, BusinesstypeId = approveCourse.BusinesstypeId, PlaceID = approveCourse.PostpositionID, OriginalId = instance.ID, Ideas = "", State = "1" }; return(approve); }