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