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