public IList<StatDealContributionDetailEntity> GetDealContributionDetail(StatQuery query) { try { IAuthorInfoService authorService = ServiceContainer.Instance.Container.Resolve<IAuthorInfoService>(); IList<StatDealContributionDetailEntity> listAuthorStat = authorService.GetDealContributionDetail(query); return listAuthorStat; } catch (Exception ex) { LogProvider.Instance.Error("获取编辑、专家处理稿件明细出现异常:" + ex.Message); throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message)); } }
/// <summary> /// 编辑、专家处理稿件明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList<StatDealContributionDetailEntity> GetDealContributionDetail(StatQuery query) { return AuthorInfoBusProvider.GetDealContributionDetail(query); }
/// <summary> /// 编辑、专家处理稿件明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList<StatDealContributionDetailEntity> GetDealContributionDetail(StatQuery query) { IList<StatDealContributionDetailEntity> authorStatList = new List<StatDealContributionDetailEntity>(); DbCommand cmd = null; AuthorInfoEntity authorEntity = GetAuthorInfo(new AuthorInfoQuery { AuthorID = query.AuthorID, JournalID = query.JournalID }); if (authorEntity == null) { authorEntity = new AuthorInfoEntity(); } if (authorEntity.GroupID == 3) { cmd = db.GetStoredProcCommand("UP_GetContributionDealDetail_Expert"); } else { if (query.Status > 1) { cmd = db.GetStoredProcCommand("UP_GetContributionDealDetail_Editor"); } else { cmd = db.GetStoredProcCommand("UP_GetContributionDealDetail"); } } db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID); db.AddInParameter(cmd, "@Status", DbType.Int32, query.Status); db.AddInParameter(cmd, "@AuthorID", DbType.Int64, query.AuthorID); db.AddInParameter(cmd, "@StartDate", DbType.DateTime, query.StartDate == null ? Convert.ToDateTime("2000-01-01") : query.StartDate); db.AddInParameter(cmd, "@EndDate", DbType.DateTime, query.EndDate == null ? DateTime.Now.AddDays(1) : query.EndDate.Value.AddDays(1)); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { StatDealContributionDetailEntity item = new StatDealContributionDetailEntity(); item.CID = TypeParse.ToLong(dr["CID"]); item.CNumber = dr["CNumber"].ToString(); item.Title = dr["Title"].ToString(); item.StatusName = dr["StatusName"].ToString(); if (dr.HasColumn("Adddate")) { item.DealDate = TypeParse.ToDateTime(dr["Adddate"]); } else { item.DealDate = TypeParse.ToDateTime(dr["DealDate"]); } authorStatList.Add(item); } dr.Close(); } return authorStatList; }
/// <summary> /// 编辑、专家处理稿件明细 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList<StatDealContributionDetailEntity> GetDealContributionDetail(StatQuery query) { return AuthorInfoDataAccess.Instance.GetDealContributionDetail(query); }