/// <summary> /// 添加审批活动 /// </summary> /// <returns></returns> public int AddApprovalActivity() { using (OracleConnection conn = DapperHelper.GetConnString()) { conn.Open(); ProcessConfiguration pc = new ProcessConfiguration(); int result = 0; string sql = @"select * from ProcessConfiguration"; var configurationList = conn.Query <ProcessConfiguration>(sql, null).ToList(); for (var i = 0; i <= 1; i++) { ApprovalActivity activity = new ApprovalActivity(); activity.ProcessID = configurationList[i].ProcessID; activity.NodeID = configurationList[i].NodeID; activity.ProcessCode = configurationList[i].ProcessCode; activity.ApprovalRoleID = configurationList[i].ApprovalRoleID; activity.NextApprovalRoleID = configurationList[i].NextApprovalRoleID; activity.ApprovalUserID = configurationList[i].ApprovalUserID; activity.NextApprovalUserID = configurationList[i].NextApprovalUserID; activity.JudgmentID = configurationList[i].JudgmentID; activity.CondtionID = configurationList[i].CondtionID; activity.TureCondtionID = configurationList[i].CondtionID; activity.Creator = configurationList[i].Creator; activity.CreateTime = configurationList[i].CreateTime; string sql1 = @"insert into ApprovalActivity (processid,nodeid,processcode,approvalroleid,nextapprovalroleid,approvaluserid,nextapprovaluserid,judgmentid,condtionid,turecondtionid,creator,createtime) values (:processid,:nodeid,:processcode,:approvalroleid,:nextapprovalroleid,:approvaluserid,:nextapprovaluserid,:judgmentid,:condtionid,:turecondtionid,:creator,:createtime)"; result = conn.Execute(sql1, activity); } return(result); } }
public List <ApprovalActivity> GetApprovalActivities(int Id, string UserName) { //定义LIST List <ApprovalActivity> approvalActivitiesList = new List <ApprovalActivity>(); //获取用户角色Id var role = IapprovalActivity.GetUserManagements(Id, UserName); //循环RolesID for (int i = 0; i < role.Count; i++) { //分割 var roles = role[i].RoleId.Split(','); //遍历数组 foreach (var r in roles) { //取值 var perExpId = IapprovalActivity.GetApprovalActivity(Convert.ToInt32(r)); for (int j = 0; j < perExpId.Count; j++) { //approvalActivitiesList = IapprovalActivity.GetPersonnelExpenditures(perExpId[j].PerExpId); var list = IapprovalActivity.GetPersonnelExpenditures(perExpId[j].PerExpId); for (int l = 0; l < list.Count; l++) { ApprovalActivity approvalActivity = new ApprovalActivity { Id = list[l].Id, StaffId = list[l].StaffId, Name = list[l].Name, EmployingUnit = list[l].EmployingUnit, PartnerName = list[l].PartnerName, Year = list[l].Year, Quarter = list[l].Quarter, Completeness = list[l].Completeness, Post = list[l].Post, QuarterlyFees = list[l].QuarterlyFees, CreationTime = list[l].CreationTime, Status = list[l].Status, ApprovalUser = list[l].ApprovalUser, ApprovalOpinion = list[l].ApprovalOpinion, TureCondtion = list[l].TureCondtion, }; approvalActivitiesList.Add(approvalActivity); } } } } return(approvalActivitiesList.ToList()); }
/// <summary> /// 添加审批活动表 /// </summary> /// <param name="approvalActivity"></param> /// <returns></returns> public int AddApprovalActivity(ApprovalActivity approvalActivity) { throw new NotImplementedException(); }