/// <summary>
/// 获取所有开启大赛公告
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ApiPageResult GetAllNotices(int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
{
ApiPageResult apiResult = new ApiPageResult();
apiResult.pageIndex = pageIndex;
apiResult.pageSize = pageSize;
BaseBLL <competition_notice> bll = new BaseBLL <competition_notice>();
var list = bll.FindList <int>(o => o.is_delete == 0 && o.is_open == 1);
int count = list.Count();
list = list.OrderBy(o => new { o.topsize, o.competition_season_id }).Skip((pageIndex - 1) * pageSize).Take(pageSize);
apiResult.success = true;
apiResult.message = "获取所有大赛公告";
apiResult.data = list;
apiResult.totalCount = count;
return(apiResult);
}
public ApiPageResult GetAllNotices(DateTime?start = null, DateTime?end = null, int is_show = 1, int pageIndex = GloabManager.PAGEINDEX, int pageSize = GloabManager.PAGESIZE)
{
ApiPageResult apiPageResult = new ApiPageResult();
apiPageResult.pageIndex = pageIndex;
apiPageResult.pageSize = pageSize;
BaseBLL <user_notice> bll = new BaseBLL <user_notice>();
var list = bll.FindList <int>(notice => true);
if (is_show == 0)
{
list = list.Where(o => o.publish_time <= DateTime.Now);
}
if (start.HasValue)
{
list = list.Where(notice => notice.update_time > start.Value &&
notice.update_time < (end ?? DateTime.Now));
}
int count = list.Count();
var top_notice = list.Where(o => o.is_top == 1);
list = list.OrderByDescending(notice => notice.update_time).Skip((pageIndex - 1) * pageSize).Take(pageSize);
var result = list.Select(notice => new
{
notice.notice_id,
notice.title,
notice.content,
notice.is_top,
notice.publish_time,
});
apiPageResult.success = true;
apiPageResult.message = "获取所有通知";
apiPageResult.data = new { result, top_notice };
apiPageResult.totalCount = count;
return(apiPageResult);
}
/// <summary>
/// 添加通知
/// </summary>
/// <param name="data">
/// {
/// "notice_id": 若大于零则为修改，小于零则为新增,
/// "title": 通知标题，
/// "content": 通知内容，
/// "logo": 通知的 logo,
/// "is_top": 0 不置顶，1 置顶，
/// "publish_time": 发布时间，在该时间后才能查询到该通知，若不设置，则为当前时间
/// }
/// </param>
/// <returns></returns>
public ApiResult AddNotice(dynamic data)
{
ApiResult apiResult = new ApiResult();
if (Util.isNotNull(data))
{
string json = Newtonsoft.Json.JsonConvert.SerializeObject(data);
var notice = Newtonsoft.Json.JsonConvert.DeserializeObject <user_notice>(json);
BaseBLL <user_notice> bll = new BaseBLL <user_notice>();
if (notice?.notice_id > 0)
{
//如果是置顶，应先将之前置顶的数据取消
if (notice.is_top == 1)
{
var is_top_notices = bll.FindList <int>(o => o.is_top == 1);
List <user_notice> is_top_notice_list = new List <user_notice>();
foreach (var _notice in is_top_notices)
{
_notice.is_top = 0;
_notice.update_time = DateTime.Now;
is_top_notice_list.Add(_notice);
}
bll.UpdateMore(is_top_notice_list);
}
// 修改
var findNotice = bll.Find(n => n.notice_id == notice.notice_id);
if (findNotice == null)
{
apiResult.success = false;
apiResult.message = "不存在该通知";
return(apiResult);
}
notice.create_time = findNotice.create_time;
notice.update_time = DateTime.Now;
bll.Update(notice);
}
else if (Util.isNotNull(notice))
{
//如果是置顶，应先将之前置顶的数据取消
if (notice.is_top == 1)
{
var is_top_notices = bll.FindList <int>(o => o.is_top == 1);
List <user_notice> is_top_notice_list = new List <user_notice>();
foreach (var _notice in is_top_notices)
{
_notice.is_top = 0;
_notice.update_time = DateTime.Now;
is_top_notice_list.Add(_notice);
}
bll.UpdateMore(is_top_notice_list);
}
// 新增
if (!notice.publish_time.HasValue)
{
notice.publish_time = DateTime.Now;
}
notice.create_time = DateTime.Now;
notice.update_time = DateTime.Now;
bll.Add(notice);
}
else
{
apiResult.success = false;
apiResult.message = "参数错误";
return(apiResult);
}
}
else
{
apiResult.success = false;
apiResult.message = "参数错误";
}
apiResult.success = true;
apiResult.message = "成功";
return(apiResult);
}
/// <summary>
/// 审核/退回
/// formdata
/// state:1退回，2审核
/// return_tag（退回标签）:xxxx,xxxx,xxxx
/// return_remark（退回理由备注）:xxxxxxxxxxx
/// ids:1,2,3,4,5,6,7,8,9,10
/// </summary>
/// <returns></returns>
public ApiResult SubmitArticle()
{
ApiResult apiResult = new ApiResult();
string _state = HttpContext.Current.Request.Form["state"];
string return_tag = HttpContext.Current.Request.Form["return_tag"];
string return_remark = HttpContext.Current.Request.Form["return_remark"];
string _article_id = HttpContext.Current.Request.Form["ids"];
var checkResult = Util.CheckParameters(
new Parameter {
Value = _state, Msg = "state 不能为空值"
},
new Parameter {
Value = _state, Msg = "state 必须是数字类型", Regex = @"^[1-9]\d*$"
},
new Parameter {
Value = _article_id, Msg = "ids 不能为空值"
}
);
if (!checkResult.OK)
{
apiResult.success = false;
apiResult.status = ApiStatusCode.InvalidParam;
apiResult.message = checkResult.Msg;
return(apiResult);
}
int state = int.Parse(_state);
List <int> id_list = new List <int>();
string[] article_ids = _article_id.Split(new char[] { ',', '，' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var id in article_ids)
{
int _id = 0;
int.TryParse(id, out _id);
if (_id > 0)
{
id_list.Add(_id);
}
}
BaseBLL <article_states> state_bll = new BaseBLL <article_states>();
var article_states = state_bll.FindList <int>(o => id_list.Contains(o.article_id));
if (state == 1)
{
List <article_states> back_list = new List <article_states>();
foreach (var article_state in article_states)
{
article_state.article_state = 1;
article_state.update_time = DateTime.Now;
article_state.return_tag = return_tag;
article_state.return_remark = return_remark;
back_list.Add(article_state);
}
state_bll.UpdateMore(back_list);
}
else if (state == 2)
{
List <article_states> sumbit_list = new List <article_states>();
foreach (var article_state in article_states)
{
article_state.article_state = 2;
article_state.update_time = DateTime.Now;
article_state.return_remark = "";
article_state.return_tag = "";
sumbit_list.Add(article_state);
}
state_bll.UpdateMore(sumbit_list);
}
else
{
return(new ApiResult()
{
success = false,
message = "参数错误"
});
}
apiResult.success = true;
apiResult.message = state == 1 ? "退回成功" : "审核成功";
return(apiResult);
}
