/// <summary>
/// 批量更改状态
/// </summary>
/// <param name="ids"></param>
/// <param name="status"></param>
/// <param name="role"></param>
/// <param name="operatorAccount"></param>
public static void UpdateAuditStatuses(IEnumerable <Guid> ids, AduiteStatus status, PublishRole role, string operatorAccount)
{
string content = "";
foreach (var id in ids)
{
var model = AnnounceService.Query(id);
if (model == null)
{
throw new ArgumentException("公告信息不存在");
}
var orginalStatus = QueryAduiteStatus(id);
content += string.Format("公告Id:{0},标题:{1},内容:{2},公告类型:{3},发布时间:{4},审核状态:{5};", id, model.Title, model.Content, model.AnnounceType, model.PublishTime.Date.ToString("yyyy-MM-dd HH:mm:ss"), orginalStatus);
}
var repository = Factory.CreateAnnounceReposity();
repository.UpdateStatuses(ids, status);
// 记录日志
string newContent = "";
foreach (var id in ids)
{
var model = AnnounceService.Query(id);
newContent += string.Format("公告Id:{0},标题:{1},内容:{2},公告类型:{3},发布时间:{4},审核状态:{5};", id, model.Title, model.Content, model.AnnounceType, model.PublishTime.Date.ToString("yyyy-MM-dd HH:mm:ss"), status);
}
OperatorRole operatorRole = getOperatorRole(role);
saveUpdateLog("审核状态", content, newContent, operatorRole, ids.Join(",", item => item.ToString()), operatorAccount);
}
public int UpdateStatuses(IEnumerable <Guid> ids, AduiteStatus status)
{
string sql = string.Format("UPDATE [dbo].[T_Announce] SET [AduiteStatus]= {0} WHERE [Id] IN ({1})", (int)status, ids.Join(",", item => "'" + item.ToString() + "'"));
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int UpdateStatus(Guid id, AduiteStatus status)
{
string sql = "UPDATE [dbo].[T_Announce] SET [AduiteStatus]=@Status WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Status", (int)status);
dbOperator.AddParameter("Id", id);
return(dbOperator.ExecuteNonQuery(sql));
}
}
/// <summary>
/// 审核状态
/// </summary>
/// <param name="Id">公告信息Id</param>
/// <param name="status">审核状态</param>
/// <param name="operatorAccount">操作员帐号</param>
public static void UpdateAduiteStatus(Guid id, AduiteStatus status, PublishRole role, string operatorAccount)
{
var announceModel = AnnounceService.Query(id);
if (announceModel == null)
{
throw new ArgumentException("公告信息不存在");
}
var model = AnnounceService.QueryAduiteStatus(id);
var repository = Factory.CreateAnnounceReposity();
repository.UpdateStatus(id, status);
// 记录日志
var view = AnnounceService.Query(id);
string originalContent = string.Format("公告Id:{0},标题:{1},公告类型:{2},内容:{3},审核状态:{4}", id, view.Title, view.AnnounceType, view.Content, model);
string newContent = string.Format("公告Id:{0},标题:{1},公告类型:{2},内容:{3},审核状态:{1}", id, view.Title, view.AnnounceType, view.Content, status);
OperatorRole operatorRole = getOperatorRole(role);
saveUpdateLog("审核状态", originalContent, newContent, operatorRole, id.ToString(), operatorAccount);
}
