public SiteConfigEntity GetSiteConfigModel(SiteConfigQuery query)
{
SiteConfigEntity model = null;
ISiteConfigService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigService>();
model = service.GetSiteConfig(query);
return model;
}
public ActionResult Index()
{
//获取配置信息
DataTable GlobalSetDT = GetSiteSetCfg.GetSiteGlobalSet(CurAuthor.JournalID.ToString());
DataTable PersonalSetDT = GetSiteSetCfg.GetSitePersonalSet(CurAuthor.JournalID.ToString(), CurAuthor.AuthorID.ToString());
//获取基本信息
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = service.GetSiteConfigModel(query);
if (model == null)
model = new SiteConfigEntity();
ViewBag.AuthorID = CurAuthor.AuthorID;
ViewBag.IsShowPwdInput = CurAuthor.LoginName == GlobalSetDT.Rows[0]["SysSuperAdmin"].ToString() ? 1 : 0;//是否显示password类型的输入框中的内容
ViewBag.IsEnableRegActivate = GlobalSetDT.Rows[0]["IsEnableRegActivate"].ToString();
ViewBag.IsHideEditorInfoForAuthor = GlobalSetDT.Rows[0]["IsHideEditorInfoForAuthor"].ToString();
ViewBag.IsHideEditorInfoForExpert = GlobalSetDT.Rows[0]["IsHideEditorInfoForExpert"].ToString();
ViewBag.ShowNameForHide = GlobalSetDT.Rows[0]["ShowNameForHide"].ToString();
ViewBag.IsStopNotLoginDownPDF = GlobalSetDT.Rows[0]["IsStopNotLoginDownPDF"].ToString();
ViewBag.ShowMoreFlowInfoForAuthor = GlobalSetDT.Rows[0]["ShowMoreFlowInfoForAuthor"].ToString();
ViewBag.ShowHistoryFlowInfoForExpert = GlobalSetDT.Rows[0]["ShowHistoryFlowInfoForExpert"].ToString();
ViewBag.isAutoHandle = GlobalSetDT.Rows[0]["isAutoHandle"].ToString();
ViewBag.isStatByGroup = GlobalSetDT.Rows[0]["isStatByGroup"].ToString();
ViewBag.Personal_Order = PersonalSetDT.Rows[0]["Personal_Order"].ToString();
ViewBag.Personal_OnlyMySearch = PersonalSetDT.Rows[0]["Personal_OnlyMySearch"].ToString();
return View(model);
}
public ActionResult Index()
{
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = service.GetSiteConfigModel(query);
if (model == null)
model = new SiteConfigEntity();
ViewBag.AuthorID = CurAuthor.AuthorID;
return View(model);
}
/// <summary>
/// 获取站点信息实体
/// </summary>
/// <param name="loginAuthor"></param>
/// <returns></returns>
public SiteConfigEntity GetSiteConfigModel(SiteConfigQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
SiteConfigEntity model = clientHelper.PostAuth<SiteConfigEntity, SiteConfigQuery>(GetAPIUrl(APIConstant.GETSITECONFIGMODELAJAX), query);
return model;
}
/// <summary>
/// 获取站点配置实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public SiteConfigEntity GetSiteConfig(SiteConfigQuery query)
{
return SiteConfigDataAccess.Instance.GetSiteConfig(query);
}
/// <summary>
/// 更新总访问数
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public bool UpdateSiteAccessCount(SiteConfigQuery query)
{
return SiteConfigDataAccess.Instance.UpdateSiteAccessCount(query);
}
public ActionResult Welcome()
{
string qq = SiteConfig.QQ;
ViewBag.qq = qq;
ViewBag.Group = CurAuthor.GroupID;
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = service.GetSiteConfigModel(query);
if (model == null)
model = new SiteConfigEntity();
return View(model);
}
public ActionResult UpdateLocalDataAjax(Int64 PKID)
{
//获取站点配置信息
SiteConfigQuery sitequery = new SiteConfigQuery();
sitequery.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService siteservice = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = siteservice.GetSiteConfigModel(sitequery);
//获取DOI注册日志实体
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
DoiRegLogQuery query = new DoiRegLogQuery();
query.PKID = PKID;
query.JournalID = CurAuthor.JournalID;
string DoiFileName = service.GetDoiRegLog(query).DoiFileName.Trim();
//保存DOI注册结果
DoiRegResultFilePath = System.DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-fff") + ".xml";
WKT.Common.Utils.DoiUtils.GetDoiRegResult(DoiFileName, model.DoiUserName, model.DoiUserPwd, Utils.GetMapPath(SiteConfig.RootPath + "/data/" + DoiRegResultFilePath));
XElement root = XElement.Load(Utils.GetMapPath(SiteConfig.RootPath + "/data/" + DoiRegResultFilePath), LoadOptions.SetLineInfo);
XElement journal = root.Element("body").Element("journal");
var Articles = from Article in journal.Elements("journal_article")
select Article;
foreach (var Article in Articles)
{
string doi = Article.Element("doi_data").Element("doi").Value;
string resource = Article.Element("doi_data").Element("resource").Value;
Int64 ContentID = Convert.ToInt64(resource.Substring(resource.LastIndexOf('=') + 1, resource.Length - resource.LastIndexOf('=') - 4));
IIssueFacadeService IssueService = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
IssueContentEntity issueContentEntity = new IssueContentEntity();
//获取期刊实体
IssueContentQuery IssueQuery = new IssueContentQuery();
IssueQuery.JournalID = CurAuthor.JournalID;
IssueQuery.contentID = ContentID;
IssueQuery.IsAuxiliary = true;
issueContentEntity=IssueService.GetIssueContentModel(IssueQuery);
//更新期刊DOI数据
issueContentEntity.DOI = doi;
issueContentEntity.isRegDoi = true;
ExecResult result = IssueService.SaveIssueContent(issueContentEntity);
}
//更新DOI注册日志
DoiRegLogEntity doiRegLogEntity = new DoiRegLogEntity();
doiRegLogEntity.State = "已更新";
doiRegLogEntity.PKID = PKID;
doiRegLogEntity.isUpdate = true;
service.SaveDoiRegLog(doiRegLogEntity);
//删除临时文件
System.IO.File.Delete(Utils.GetMapPath(SiteConfig.RootPath + "/data/" + DoiRegResultFilePath));
return Json(new { flag = 1 });
}
public ActionResult IssueDoiRegQueryAjax(Int64[] ContentIDs)
{
//获取期刊详细数据
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
IssueContentQuery query = new IssueContentQuery();
query.JournalID = CurAuthor.JournalID;
query.contentIDs = ContentIDs;
query.CurrentPage = 1;
query.PageSize = 50;
query.SortName = " EditDate ";
query.SortOrder = " DESC ";
IList<IssueContentEntity> list = service.GetIssueContentList(query);
//获取站点配置信息
SiteConfigQuery sitequery = new SiteConfigQuery();
sitequery.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService siteservice = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = siteservice.GetSiteConfigModel(sitequery);
//生成注册用XML文件
CreateDoiRegFilePath = System.DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-fff") + ".xml";
WKT.Common.Utils.DoiUtils.CreateDoiRegisterFile(Utils.GetMapPath(SiteConfig.RootPath + "/data/DoiRegister.xml"), Utils.GetMapPath(SiteConfig.RootPath + "/data/" + CreateDoiRegFilePath), model.DoiJournalID, model.DoiPrefix, model.Title, model.EnTitle, model.ISSN, model.CN, list[0].Year, list[0].Volume, list[0].Issue, list, model.Home);
//上传注册用XML文件到中文DOI网站
string ReturnXMLFile = WKT.Common.Utils.DoiUtils.Upload(Utils.GetMapPath(SiteConfig.RootPath + "/data/" + CreateDoiRegFilePath), model.DoiUserName, model.DoiUserPwd, 3);
//获取DOI注册结果
string DoiRegResult = WKT.Common.Utils.DoiUtils.GetDoiRegResult(ReturnXMLFile, model.DoiUserName, model.DoiUserPwd);
//保存DOI注册日志
DoiRegLogEntity doiRegLogEntity = new DoiRegLogEntity();
doiRegLogEntity.JournalID = CurAuthor.JournalID;
doiRegLogEntity.DoiFileName = ReturnXMLFile;
doiRegLogEntity.State = DoiRegResult;
doiRegLogEntity.Year = list[0].Year; ;
doiRegLogEntity.Issue = list[0].Issue; ;
doiRegLogEntity.AdminID = CurAuthor.AuthorID;
if (service.SaveDoiRegLog(doiRegLogEntity).result == "success")
{
//删除生成的XML注册文件
System.IO.File.Delete(Utils.GetMapPath(SiteConfig.RootPath + "/data/" + CreateDoiRegFilePath));
return Json(new { flag = 1 });
}
else
return Json(new { flag = 0 });
}
public ActionResult Stat()
{
try
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = JournalID;
service.UpdateSiteAccessCount(query);
}
catch (Exception ex)
{
WKT.Log.LogProvider.Instance.Error("记录访问次数出现异常：" + ex.Message);
}
return Content("");
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="siteConfigQuery">SiteConfigQuery查询实体对象</param>
/// <returns>List<SiteConfigEntity></returns>
public List<SiteConfigEntity> GetSiteConfigList(SiteConfigQuery siteConfigQuery)
{
return SiteConfigBusProvider.GetSiteConfigList(siteConfigQuery);
}
/// <summary>
/// 获取站点配置实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public SiteConfigEntity GetSiteConfig(SiteConfigQuery query)
{
return SiteConfigBusProvider.GetSiteConfig(query);
}
/// <summary>
/// 获取总访问数
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public int GetSiteAccessCount(SiteConfigQuery query)
{
return SiteConfigBusProvider.GetSiteAccessCount(query);
}
public bool UpdateSiteAccessCount(SiteConfigQuery query)
{
ISiteConfigService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigService>();
return service.UpdateSiteAccessCount(query);
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string SiteConfigQueryToSQLWhere(SiteConfigQuery query)
{
return string.Empty;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="siteConfigQuery">SiteConfigQuery查询实体对象</param>
/// <returns>Pager<SiteConfigEntity></returns>
public Pager<SiteConfigEntity> GetSiteConfigPageList(SiteConfigQuery siteConfigQuery)
{
return SiteConfigBusProvider.GetSiteConfigPageList(siteConfigQuery);
}
/// <summary>
/// 更新总访问数
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public bool UpdateSiteAccessCount(SiteConfigQuery query)
{
bool flag = false;
try
{
string strSql = "UPDATE dbo.SiteConfig SET Hits=Hits+1";
strSql += string.Format(" WHERE JournalID={0}", query.JournalID);
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.ExecuteNonQuery(cmd);
}
catch (SqlException ex)
{
throw ex;
}
return flag;
}
/// <summary>
/// 更新总访问数
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public bool UpdateSiteAccessCount(SiteConfigQuery query)
{
return SiteConfigBusProvider.UpdateSiteAccessCount(query);
}
/// <summary>
/// 审稿单
/// </summary>
/// <param name="ActionID">当前所做操作ID</param>
/// <param name="StatusID">当前状态</param>
/// <param name="CIDS">稿件ID,多个稿件ID用逗号分隔</param>
/// <returns></returns>
public ActionResult AuditBill(long ActionID, long StatusID, string CIDS)
{
//继续送交
int IsContinueSubmit = 0;
int ActionType = 0;//操作类型:标识继续送交/继续送专家复审
if (ActionID == 0)
{
ActionType = 0;
ISiteConfigFacadeService facadeService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
DictEntity dicteEntity = facadeService.GetDictModelByKey(new DictQuery() { JournalID = CurAuthor.JournalID, DictKey = "MoreSubmit" });
if (dicteEntity != null)
{
IsContinueSubmit = 1;
ISiteConfigFacadeService currentService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
IList<DictValueEntity> list = currentService.GetDictValueList(new DictValueQuery() { JournalID = CurAuthor.JournalID, DictKey = dicteEntity.DictKey });
if (list != null && list.Count > 0)
{
DictValueEntity entity = list.Single<DictValueEntity>();
if (entity != null)
{
ActionID = entity.ValueID;
}
}
}
else
{
IsContinueSubmit = -1;
}
}
//继续送复审
int IsContinueReSubmit = 0;
if (ActionID == -1)
{
ActionType = -1;
ISiteConfigFacadeService facadeService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
DictEntity dicteEntity = facadeService.GetDictModelByKey(new DictQuery() { JournalID = CurAuthor.JournalID, DictKey = "MoreReSubmit" });
if (dicteEntity != null)
{
IsContinueReSubmit = 1;
ISiteConfigFacadeService currentService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
IList<DictValueEntity> list = currentService.GetDictValueList(new DictValueQuery() { JournalID = CurAuthor.JournalID, DictKey = dicteEntity.DictKey });
if (list != null && list.Count > 0)
{
DictValueEntity entity = list.Single<DictValueEntity>();
if (entity != null)
{
ActionID = entity.ValueID;
}
}
}
else
{
IsContinueReSubmit = -1;
}
}
//新加实体
SiteConfigQuery SiteConfigQuery = new SiteConfigQuery();
SiteConfigQuery.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService SiteConfigService = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = SiteConfigService.GetSiteConfigModel(SiteConfigQuery);
if (model == null)
model = new SiteConfigEntity();
CirculationEntity cirEntity = new CirculationEntity();
cirEntity.ActionID = ActionID;
cirEntity.JournalID = JournalID;
cirEntity.StatusID = StatusID;
IDictionary<long, long> dictCIDMap = new Dictionary<long, long>();
string[] CIDArray = CIDS.Split(',');
long CID = 0;
long FlowLogID = 0;
foreach (string CIDLogID in CIDArray)
{
if (!string.IsNullOrEmpty(CIDLogID))
{
string[] CIDANDLogID = CIDLogID.Split(':');
CID = TypeParse.ToLong(CIDANDLogID[0]);
FlowLogID = TypeParse.ToLong(CIDANDLogID[1]);
if (!dictCIDMap.ContainsKey(CID) && CID > 0)
{
dictCIDMap.Add(CID, FlowLogID);
}
}
}
cirEntity.CIDS = string.Join(",", dictCIDMap.Keys);
cirEntity.DictLogID = dictCIDMap;
IFlowFacadeService flowService = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
FlowStep flowStepInfo = flowService.GetNextFlowStep(cirEntity);
# region 让当前用户排第一个
if (flowStepInfo.FlowAuthorList != null)
{
WKT.Model.AuthorInfoEntity curEditor = null;
foreach (WKT.Model.AuthorInfoEntity item in flowStepInfo.FlowAuthorList)
{
if (item.AuthorID == CurAuthor.AuthorID)
{
curEditor = item;
break;
}
}
if (curEditor != null)
{
flowStepInfo.FlowAuthorList.Remove(curEditor);
flowStepInfo.FlowAuthorList.Insert(0, curEditor);
}
}
# endregion
flowStepInfo.DictLogID = dictCIDMap;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
MessageTemplateQuery query = new MessageTemplateQuery();
query.JournalID = CurAuthor.JournalID;
query.TType = 1;
if (flowStepInfo.FlowAction != null)
{
if (flowStepInfo.FlowAction.EmailTemplate > 0)
{
query.TemplateID = flowStepInfo.FlowAction.EmailTemplate;
flowStepInfo.EmailTemplate = service.GetMessageTempModel(query);
if (CIDArray.Length == 1)//仅选择一篇稿件处理时，替换其中的稿件编号/标题变量为具体内容
flowStepInfo.EmailTemplate.TContent = ReplaceContent(CID,flowStepInfo.EmailTemplate.TContent);
}
if (flowStepInfo.FlowAction.SMSTemplate > 0)
{
query.TType = 2;
query.TemplateID = flowStepInfo.FlowAction.SMSTemplate;
flowStepInfo.SMSTemplate = service.GetMessageTempModel(query);
if (CIDArray.Length == 1)
flowStepInfo.SMSTemplate.TContent = ReplaceContent(CID, flowStepInfo.SMSTemplate.TContent);
}
}
else
{
flowStepInfo.FlowAction = new FlowActionEntity { ActionID = -1, ActionType = 1, ActionRoleID = 0 };
flowStepInfo.FlowConfig = new FlowConfigEntity();
}
ViewBag.StatusID = StatusID;
ViewBag.ActionType = ActionType;
ViewBag.IsContinueSubmit = IsContinueSubmit;
ViewBag.IsContinueReSubmit = IsContinueReSubmit;
return View(flowStepInfo);
}
/// <summary>
/// 获取总访问数
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public int GetSiteAccessCount(SiteConfigQuery query)
{
int totalAccessCount = 0;
string strSql = "SELECT TOP 1 Hits FROM dbo.SiteConfig WITH(NOLOCK)";
strSql += string.Format(" WHERE JournalID={0}", query.JournalID);
DbCommand cmd = db.GetSqlStringCommand(strSql);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
{
totalAccessCount = WKT.Common.Utils.TypeParse.ToInt(dr["Hits"]);
}
dr.Close();
}
return totalAccessCount;
}
public ActionResult ReCheckDoiStateAjax(Int64 PKID)
{
//获取站点配置信息
SiteConfigQuery sitequery = new SiteConfigQuery();
sitequery.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService siteservice = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = siteservice.GetSiteConfigModel(sitequery);
//获取DOI注册日志实体
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
DoiRegLogQuery query = new DoiRegLogQuery();
query.PKID = PKID;
query.JournalID = CurAuthor.JournalID;
string DoiFileName = service.GetDoiRegLog(query).DoiFileName.Trim();
//CreateDoiRegFilePath = Utils.GetMapPath(SiteConfig.RootPath + "/data/" + DoiFileName);
string DoiRegResult = WKT.Common.Utils.DoiUtils.GetDoiRegResult(DoiFileName, model.DoiUserName, model.DoiUserPwd);
if (DoiRegResult == "已完成")
{
DoiRegLogEntity doiRegLogEntity = new DoiRegLogEntity();
doiRegLogEntity.State = "已完成";
doiRegLogEntity.PKID = PKID;
doiRegLogEntity.isUpdate = true;
service.SaveDoiRegLog(doiRegLogEntity);
return Json(new { flag = 1 });
}
if (DoiRegResult == "不合格")
{
DoiRegLogEntity doiRegLogEntity = new DoiRegLogEntity();
doiRegLogEntity.State = "不合格";
doiRegLogEntity.PKID = PKID;
doiRegLogEntity.isUpdate = true;
service.SaveDoiRegLog(doiRegLogEntity);
return Json(new { flag = 1 });
}
if (DoiRegResult == "未审核")
{
return Json(new { flag = -1 });
}
else
return Json(new { flag = 0 });
}
/// <summary>
/// 获取站点配置实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public SiteConfigEntity GetSiteConfig(SiteConfigQuery query)
{
string strSql = "SELECT TOP 1 * FROM dbo.SiteConfig WITH(NOLOCK)";
strSql += string.Format(" WHERE JournalID={0}", query.JournalID);
DbCommand cmd = db.GetSqlStringCommand(strSql);
using (IDataReader dr = db.ExecuteReader(cmd))
{
return MakeSiteConfig(dr);
}
}
//信封导出打印
public ActionResult LetterPrint()
{
//获取站点配置信息
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = CurAuthor.JournalID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigEntity model = service.GetSiteConfigModel(query);
if (model == null)
model = new SiteConfigEntity();
return View(model);
}
public List<SiteConfigEntity> GetSiteConfigList(SiteConfigQuery query)
{
List<SiteConfigEntity> list = new List<SiteConfigEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT * FROM dbo.SiteConfig WITH(NOLOCK)");
string whereSQL = SiteConfigQueryToSQLWhere(query);
string orderBy=SiteConfigQueryToSQLOrder(query);
if(!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL);
if(!string.IsNullOrEmpty(orderBy)) sqlCommandText.Append(" ORDER BY " + orderBy);
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using(IDataReader dr = db.ExecuteReader(cmd))
{
list = MakeSiteConfigList(dr);
}
return list;
}
private SiteConfigEntity GetSiteConfig()
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = CurAuthor.JournalID;
return service.GetSiteConfigModel(query);
}
public Pager<SiteConfigEntity> GetSiteConfigPageList(SiteConfigQuery query)
{
int recordCount=0;
string whereSQL=SiteConfigQueryToSQLWhere(query);
string orderBy=SiteConfigQueryToSQLOrder(query);
DataSet ds = db.GetPagingData("SiteConfig", "SiteConfigID,JournalID,Title,EnTitle,CN,ISSN,Home,Keywords,Description,ICPCode,ZipCode,Address,SendMail,MailServer,MailPort,MailAccount,MailPwd,MailIsSSL,SMSUserName,SMSPwd,DoiUserName,DoiUserPwd,DoiJournalID,DoiPrefix,InUserID,EditUserID,EditDate,AddDate,EBankType,EBankAccount,EBankCode,EBankEncryKey", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount);
Pager<SiteConfigEntity> pager=new Pager<SiteConfigEntity>();
if(ds!=null && ds.Tables.Count>0)
{
pager.ItemList= MakeSiteConfigList(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 int GetSiteAccessCount(SiteConfigQuery query)
{
return SiteConfigDataAccess.Instance.GetSiteAccessCount(query);
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string SiteConfigQueryToSQLOrder(SiteConfigQuery query)
{
return " SiteConfigID DESC";
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="siteConfigQuery">SiteConfigQuery查询实体对象</param>
/// <returns>List<SiteConfigEntity></returns>
public List<SiteConfigEntity> GetSiteConfigList(SiteConfigQuery siteConfigQuery)
{
return SiteConfigDataAccess.Instance.GetSiteConfigList(siteConfigQuery);
}
/// <summary>
/// 获取站点配置实体
/// </summary>
/// <param name="JournalID"></param>
/// <returns></returns>
public SiteConfigEntity GetSiteConfig(Int64 JournalID)
{
SiteConfigQuery query = new SiteConfigQuery();
query.JournalID = JournalID;
SiteConfigEntity model = GetSiteConfigModel(query);
if (string.IsNullOrWhiteSpace(model.SendMail))
model.SendMail = model.MailAccount;
return model;
}
