/// <summary>
/// 得到稿件编号
/// </summary>
/// <param name="query">查询基类，主要用到站点ID</param>
/// <returns></returns>
public string GetContributeNumber(QueryBase query)
{
StringBuilder sbCNumber = new StringBuilder("");
ContributeSetEntity cSetEntity = GetContributeSetInfo(query);
if (cSetEntity != null)
{
string Separator = string.Empty;
if (!string.IsNullOrEmpty(cSetEntity.Separator))
{
if (cSetEntity.Separator.Contains(","))
{
string[] paras = cSetEntity.Separator.Split(',');
if (paras != null && paras.Length > 0)
{
Separator = paras[0];
if (int.Parse(paras[1]) == 1)
{
IList<ContributionInfoEntity> list = ContributionInfoDataAccess.Instance.GetContributionInfoList(new ContributionInfoQuery() { JournalID = cSetEntity.JournalID });
if (list != null && list.Count > 0)
{
ContributionInfoEntity entity = list[0];
DateTime dt = System.DateTime.Now;
if (dt.Year > entity.AddDate.Year || dt.Month > entity.AddDate.Month)
{
JournalSetInfoDataAccess.Instance.UpdateIDPoolByJournalID(entity.JournalID);
}
}
}
}
}
}
string OrderNO = JournalSetInfoDataAccess.Instance.GetMaxID(query.JournalID, "WKTDB", "ContributeSet", cSetEntity.RandomDigit);
switch (cSetEntity.CCodeType)
{
case 1:// 日期格式
sbCNumber.Append(DateTime.Now.ToString(cSetEntity.CCodeFormat)).Append(string.IsNullOrEmpty(Separator) ? cSetEntity.Separator : Separator).Append(OrderNO);
break;
case 2:// 自定义格式
sbCNumber.Append(cSetEntity.CCodeFormat).Append(string.IsNullOrEmpty(Separator) ? cSetEntity.Separator : Separator).Append(OrderNO);
break;
case 3:// 年份格式
sbCNumber.Append(DateTime.Now.Year).Append(string.IsNullOrEmpty(Separator) ? cSetEntity.Separator : Separator).Append(OrderNO);
break;
}
}
return sbCNumber.ToString();
}
/// <summary>
/// 注册数统计
/// </summary>
/// <returns></returns>
private Highcharts GetAuthorContributeStat()
{
IAuthorFacadeService authorStatService = ServiceContainer.Instance.Container.Resolve<IAuthorFacadeService>();
QueryBase query = new QueryBase();
query.JournalID = JournalID;
IDictionary<string, int> dictAuthorStat = authorStatService.GetAuthorContributeStat(query);
decimal TotalCount = TypeParse.ToDecimal(dictAuthorStat["TotalCount"]);
decimal AuthorCount = TypeParse.ToDecimal(dictAuthorStat["AuthorCount"]);
decimal Rate = AuthorCount / TotalCount;
Rate = Rate * 100;
Highcharts chart = new Highcharts("chart")
.InitChart(new Chart { PlotShadow = false })
.SetTitle(new Title { Text = string.Format("注册量统计：本站共有作者：{0} 人，其中投稿 {1} 人，占总人数的 {2}%", dictAuthorStat["TotalCount"], dictAuthorStat["AuthorCount"], Math.Round(Rate, 2)) })
.SetTooltip(new Tooltip { Formatter = "function() { return '<b>'+ this.point.name +'</b>: '+ this.point.y ; }" })//this.percentage
.SetPlotOptions(new PlotOptions
{
Pie = new PlotOptionsPie
{
AllowPointSelect = true,
Cursor = Cursors.Pointer,
DataLabels = new PlotOptionsPieDataLabels
{
Color = ColorTranslator.FromHtml("#000000"),
ConnectorColor = ColorTranslator.FromHtml("#000000"),
Formatter = "function() { return '<b>'+ this.point.name +'</b>: '+ this.point.y; }"//Highcharts.numberFormat(this.percentage, 2)
}
}
})
.SetSeries(new Series
{
Type = ChartTypes.Pie,
Name = "Browser share",
Data = new Data(new object[]
{
new object[] { "投稿人数", dictAuthorStat["AuthorCount"]},
new object[] { "暂无投稿人数", dictAuthorStat["TotalCount"]-dictAuthorStat["AuthorCount"] }
})
});
return chart;
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(QueryBase query)
{
return SysAccountInfoBusiness.GetSysAccountInfoPageList(query);
}
public IList<AuthorStatEntity> GetAuthorProvinceStat(QueryBase query)
{
try
{
IAuthorInfoService authorService = ServiceContainer.Instance.Container.Resolve<IAuthorInfoService>();
IList<AuthorStatEntity> listAuthorStat = authorService.GetAuthorProvinceStat(query);
return listAuthorStat;
}
catch (Exception ex)
{
LogProvider.Instance.Error("获取作者按省份统计数据出现异常：" + ex.Message);
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message));
}
}
public IDictionary<String, Int32> GetAuthorContributeStat(QueryBase query)
{
try
{
IAuthorInfoService authorService = ServiceContainer.Instance.Container.Resolve<IAuthorInfoService>();
IDictionary<String, Int32> dictAuthorStat = authorService.GetAuthorContributeStat(query);
return dictAuthorStat;
}
catch (Exception ex)
{
LogProvider.Instance.Error("作者总数及投稿作者数量统计出现异常：" + ex.Message);
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message));
}
}
public Pager<AuthorInfoEntity> GetAuthorInfoPageList(QueryBase query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("AuthorInfo", "AuthorID,JournalID,LoginName,Pwd,RealName,Mobile,LoginIP,LoginCount,LoginDate,Status,GroupID,AddDate", " AuthorID DESC", "", query.CurrentPage, query.PageSize, out recordCount);
Pager<AuthorInfoEntity> pager = new Pager<AuthorInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeAuthorInfoList(ds.Tables[0]);
foreach (AuthorInfoEntity item in pager.ItemList)
{
item.Pwd = "";
}
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
/// <summary>
/// 作者总数及投稿作者数量统计
/// </summary>
/// <returns></returns>
public IDictionary<String, Int32> GetAuthorContributeStat(QueryBase query)
{
IDictionary<String, Int32> dictStat = new Dictionary<String, Int32>();
string strSql = "SELECT COUNT(1) AS TotalCount,(select COUNT(DISTINCT AuthorID) FROM dbo.ContributionInfo) AS AuthorCount FROM dbo.AuthorInfo a WITH(NOLOCK) WHERE JournalID=@JournalID AND GroupID=2";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
{
dictStat.Add("TotalCount", TypeParse.ToInt(dr["TotalCount"]));
dictStat.Add("AuthorCount", TypeParse.ToInt(dr["AuthorCount"]));
}
dr.Close();
}
return dictStat;
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<SiteConfigEntity></returns>
public Pager<SiteConfigEntity> GetSiteConfigPageList(QueryBase query)
{
return SiteConfigDataAccess.Instance.GetSiteConfigPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(QueryBase query)
{
return SysAccountInfoDataAccess.Instance.GetSysAccountInfoPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(QueryBase query)
{
return FlowNodeConditionDataAccess.Instance.GetFlowNodeConditionPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<GuestbookEntity></returns>
public Pager<GuestbookEntity> GetGuestbookPageList(QueryBase query)
{
return GuestbookBusProvider.GetGuestbookPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<IssueDownLogEntity></returns>
public Pager<IssueDownLogEntity> GetIssueDownLogPageList(QueryBase query)
{
return IssueDownLogBusProvider.GetIssueDownLogPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<SiteChannelEntity></returns>
public Pager<SiteChannelEntity> GetSiteChannelPageList(QueryBase query)
{
return SiteChannelBusProvider.GetSiteChannelPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<FinanceContributeEntity></returns>
public Pager<FinanceContributeEntity> GetFinanceContributePageList(QueryBase query)
{
return FinanceContributeDataAccess.Instance.GetFinanceContributePageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<FlowNodeConditionEntity></returns>
public Pager<FlowNodeConditionEntity> GetFlowNodeConditionPageList(QueryBase query)
{
return FlowNodeConditionBusProvider.GetFlowNodeConditionPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<PayNoticeEntity></returns>
public Pager<PayNoticeEntity> GetPayNoticePageList(QueryBase query)
{
return PayNoticeBusProvider.GetPayNoticePageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<IssueDownLogEntity></returns>
public Pager<IssueDownLogEntity> GetIssueDownLogPageList(QueryBase query)
{
return IssueDownLogDataAccess.Instance.GetIssueDownLogPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<SiteNoticeEntity></returns>
public Pager<SiteNoticeEntity> GetSiteNoticePageList(QueryBase query)
{
return SiteNoticeBusProvider.GetSiteNoticePageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<FinancePayDetailEntity></returns>
public Pager<FinancePayDetailEntity> GetFinancePayDetailPageList(QueryBase query)
{
return FinancePayDetailBusProvider.GetFinancePayDetailPageList(query);
}
public Pager<ApiServerInfoEntity> GetApiServerInfoPageList(QueryBase query)
{
int recordCount=0;
DataSet ds = db.GetPagingData("ApiServerInfo","ApiServerID,SiteName,SiteUrl,Status,Note,AddDate"," ApiServerID DESC","",query.CurrentPage,query.PageSize,out recordCount);
Pager<ApiServerInfoEntity> pager=new Pager<ApiServerInfoEntity>();
if(ds!=null && ds.Tables.Count>0)
{
pager.ItemList= MakeApiServerInfoList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
/// <summary>
/// 获取作者按性别统计数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorStatEntity> GetAuthorGenderStat(QueryBase query)
{
IList<AuthorStatEntity> authorStatList = new List<AuthorStatEntity>();
string strSql = "SELECT b.Gender,COUNT(DISTINCT b.AuthorID) AS Count FROM dbo.AuthorInfo a WITH(NOLOCK),dbo.AuthorDetail b WITH(NOLOCK) WHERE a.JournalID=@JournalID AND a.GroupID=2 AND a.JournalID=b.JournalID GROUP BY b.Gender";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
int Gender = 0;
while (dr.Read())
{
Gender = TypeParse.ToInt(dr["Gender"]);
AuthorStatEntity item = new AuthorStatEntity();
if (Gender == 1)
{
item.StatItem = "男";
}
else if (Gender == 2)
{
item.StatItem = "女";
}
else
{
item.StatItem = "未知";
}
item.Count = TypeParse.ToInt(dr["Count"]);
authorStatList.Add(item);
}
dr.Close();
}
return authorStatList;
}
public Pager<MessageRecodeEntity> GetMessageRecodePageList(QueryBase query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("MessageRecode", "*", " RecodeID DESC", "", query.CurrentPage, query.PageSize, out recordCount);
Pager<MessageRecodeEntity> pager = new Pager<MessageRecodeEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeMessageRecodeList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
/// <summary>
/// 获取作者按省份统计数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<AuthorStatEntity> GetAuthorProvinceStat(QueryBase query)
{
IList<AuthorStatEntity> authorStatList = new List<AuthorStatEntity>();
string strSql = "SELECT b.Province,COUNT(DISTINCT b.AuthorID) AS Count FROM dbo.AuthorInfo a WITH(NOLOCK),dbo.AuthorDetail b WITH(NOLOCK) WHERE a.JournalID=@JournalID AND a.GroupID=2 AND a.JournalID=b.JournalID GROUP BY b.Province";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
AuthorStatEntity item = new AuthorStatEntity();
item.StatItem = dr.IsDBNull(dr.GetOrdinal("Province")) ? "未知地区" : dr["Province"].ToString();
if (string.IsNullOrEmpty(item.StatItem))
{
item.StatItem = "未知地区";
}
item.Count = TypeParse.ToInt(dr["Count"]);
authorStatList.Add(item);
}
dr.Close();
}
return authorStatList;
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<FinancePayDetailEntity></returns>
public Pager<FinancePayDetailEntity> GetFinancePayDetailPageList(QueryBase query)
{
return FinancePayDetailDataAccess.Instance.GetFinancePayDetailPageList(query);
}
public IList<AuthorStatEntity> GetAuthorJobTitleStat(QueryBase query)
{
try
{
IAuthorInfoService authorService = ServiceContainer.Instance.Container.Resolve<IAuthorInfoService>();
IList<AuthorStatEntity> listAuthorStat = authorService.GetAuthorJobTitleStat(query);
IDictValueService service = ServiceContainer.Instance.Container.Resolve<IDictValueService>();
IDictionary<int, string> dictValues = service.GetDictValueDcit(query.JournalID, EnumDictKey.JobTitle.ToString());
if (listAuthorStat != null)
{
if (dictValues != null)
{
foreach (AuthorStatEntity item in listAuthorStat)
{
if (dictValues.ContainsKey(item.StatID))
{
item.StatItem = dictValues[item.StatID];
}
else
{
item.StatItem = "未知";
}
}
}
}
return listAuthorStat;
}
catch (Exception ex)
{
LogProvider.Instance.Error("获取作者按职称统计数据出现异常：" + ex.Message);
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.ExpectationFailed, ex.Message));
}
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<DictEntity></returns>
public Pager<DictEntity> GetDictPageList(QueryBase query)
{
return DictDataAccess.Instance.GetDictPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<ApiServerInfoEntity></returns>
public Pager<ApiServerInfoEntity> GetApiServerInfoPageList(QueryBase query)
{
return ApiServerInfoBusProvider.GetApiServerInfoPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<RoleInfoEntity></returns>
public Pager<RoleInfoEntity> GetRoleInfoPageList(QueryBase query)
{
return RoleInfoBusProvider.GetRoleInfoPageList(query);
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns>Pager<ContactWayEntity></returns>
public Pager<ContactWayEntity> GetContactWayPageList(QueryBase query)
{
return ContactWayDataAccess.Instance.GetContactWayPageList(query);
}
public Pager<GuestbookEntity> GetGuestbookPageList(QueryBase query)
{
int recordCount=0;
DataSet ds = db.GetPagingData("Guestbook","MessageID,JournalID,PMessageID,UserName,Email,Tel,Title,MessageContent,IP,AddDate"," MessageID DESC","",query.CurrentPage,query.PageSize,out recordCount);
Pager<GuestbookEntity> pager=new Pager<GuestbookEntity>();
if(ds!=null && ds.Tables.Count>0)
{
pager.ItemList= MakeGuestbookList(ds.Tables[0]);
}
pager.CurrentPage=query.CurrentPage;
pager.PageSize=query.PageSize;
pager.TotalRecords=recordCount;
return pager;
}
