/// <su添加审批配置mmary>
///
/// </summary>
/// <param name="approvalConfiguration"></param>
/// <returns></returns>
public int Add(ApprovalConfiguration approvalConfiguration)
{
using (SqlConnection conn = DapperHelper.GetConnString())
{
conn.Open();
//string sql = @"insert into ApprovalConfiguration(ProcessID,NodeID,ApprovalUserID,NextApprovalUserID,StateID,ConditionID,IsFirst,UseUser) values(:ProcessID,:NodeID,:ApprovalUserID,:NextApprovalUserID,:StateID,:ConditionID,:IsFirst,:UseUser)";
string sql = string.Format("insert into ApprovalConfiguration(ProcessID,NodeID,ApprovalUserID,NextApprovalUserID,StateID,ConditionID,IsFirst,UseUser) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", approvalConfiguration.ProcessID, approvalConfiguration.NodeID, approvalConfiguration.ApprovalUserID, approvalConfiguration.NextApprovalUserID, approvalConfiguration.StateID, approvalConfiguration.ConditionID, approvalConfiguration.IsFirst, approvalConfiguration.UseUser);
return(conn.Execute(sql, null));
}
}
/// <summary>
/// 添加配置方法
/// </summary>
/// <param name="approvalConfiguration"></param>
/// <returns></returns>
public JsonResult AddApprovalConfiguration(ApprovalConfiguration approvalConfiguration)
{
var listApprovalConfiguration = new List <ApprovalConfiguration>();
//查询活动表所有的活动Id
var listRoleUser = HttpClientApi.GetAsync <List <ApprovalConfiguration> >(HttpHelper.Url + "Activity/GetActivityId");
//linq进行筛选是否配置
var firstOrDefault = listRoleUser.Count(p => p.ActivityId.Equals(approvalConfiguration.ActivityId) && p.IsEnable == 0);
//若配置则返回0
if (firstOrDefault > 0)
{
return(Json(new { result = 0 }, new JsonSerializerSettings()));
}
//拿出级别的Id
var level = approvalConfiguration.UserLevelId;
if (level != 0)
{
//获取所有的活动级别
var listUserLevel = HttpClientApi.GetAsync <List <UserLevel> >(HttpHelper.Url + "Activity/GetListUserLevel");
var allLevels = listUserLevel.Where(p => p.Id <= level).ToList();
foreach (var userLevel in allLevels)
{
var configuration = new ApprovalConfiguration()
{
ActivityId = approvalConfiguration.ActivityId,
CreateTime = DateTime.Now,
DownId = 0,
Start = "未审批",
RoleId = userLevel.RoleId,
UserLevelId = level,
UserId = userLevel.UserId,
IsEnable = 0
};
listApprovalConfiguration.Add(configuration);
}
var results = HttpClientApi.PostAsync <List <ApprovalConfiguration>, int>(listApprovalConfiguration, HttpHelper.Url + "Activity/AddApprovalConfiguration");
return(Json(new { results }, new JsonSerializerSettings()));
}
//没有则添加一个状态
approvalConfiguration.Start = "未审批";
//进行一个时间的赋值
approvalConfiguration.CreateTime = DateTime.Now;
approvalConfiguration.IsEnable = 0;
listApprovalConfiguration.Add(approvalConfiguration);
var result = HttpClientApi.PostAsync <List <ApprovalConfiguration>, int>(listApprovalConfiguration, HttpHelper.Url + "Activity/AddApprovalConfiguration");
return(Json(new { result }, new JsonSerializerSettings()));
}
public int Add(ApprovalConfiguration approvalConfiguration)
{
return(ApprovalServices.Add(approvalConfiguration));
}
