/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List<ExpertApplyLogEntity> GetExpertApplyInfoList(ExpertApplyLogQuery query)
{
return ExpertApplyBusProvider.GetExpertApplyInfoList(query);
}
public Pager<ExpertApplyLogEntity> GetPageList(ExpertApplyLogQuery query)
{
IExpertApplyService service = ServiceContainer.Instance.Container.Resolve<IExpertApplyService>();
Pager<ExpertApplyLogEntity> pager = service.GetExpertApplyInfoPageList(query);
return pager;
}
/// <summary>
/// 获取一个实体对象
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExpertApplyLogEntity GetExpertApplyInfo(ExpertApplyLogQuery query)
{
return ExpertApplyBusProvider.GetExpertApplyInfo(query);
}
public IList<ExpertApplyLogEntity> GetList(ExpertApplyLogQuery query)
{
IExpertApplyService service = ServiceContainer.Instance.Container.Resolve<IExpertApplyService>();
IList<ExpertApplyLogEntity> list = service.GetExpertApplyInfoList(query);
return list;
}
public ExpertApplyLogEntity GetModel(ExpertApplyLogQuery query)
{
IExpertApplyService service = ServiceContainer.Instance.Container.Resolve<IExpertApplyService>();
ExpertApplyLogEntity model = service.GetExpertApplyInfo(query);
return model;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ExpertApplyLogEntity> GetExpertApplyInfoPageList(ExpertApplyLogQuery query)
{
return ExpertApplyDataAccess.Instance.GetExpertApplyInfoPageList(query);
}
public ExecResult SubmitApply(ExpertApplyLogEntity expertApplyEntity)
{
ExecResult execResult = new ExecResult();
try
{
IExpertApplyService expertApplyService = ServiceContainer.Instance.Container.Resolve<IExpertApplyService>();
ExpertApplyLogQuery queryExpertApply = new ExpertApplyLogQuery();
queryExpertApply.LoginName = expertApplyEntity.LoginName;
queryExpertApply.JournalID = expertApplyEntity.JournalID;
//验证是否提交过申请
IList<ExpertApplyLogEntity> list = expertApplyService.GetExpertApplyInfoList(queryExpertApply);
if (list != null && list.Count > 0)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "此邮箱提交过申请！请更换其他邮箱提交申请或联系编辑部。";
}
else//提交申请
{
expertApplyService.SubmitApply(expertApplyEntity);
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "申请提交成功，请等待编辑部审核。\r\n审核结果将会以邮件形式发送到您的邮箱。";
}
}
catch (Exception ex)
{
execResult.result = EnumJsonResult.error.ToString();
execResult.msg = "提交申请失败：" + ex.Message;
LogProvider.Instance.Error("提交申请出现异常：" + ex.Message);
}
return execResult;
}
/// <summary>
/// 获取专家申请分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ExpertApplyLogEntity> GetExpertApplyInfoPageList(ExpertApplyLogQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<ExpertApplyLogEntity> pager = clientHelper.Post<Pager<ExpertApplyLogEntity>, ExpertApplyLogQuery>(GetAPIUrl(APIConstant.EXPERTAPPLY_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 获取一个实体对象
/// </summary>
/// <param name="query">专家申请信息</param>
/// <returns>获取一个实体，如果数据不存在返回Null</returns>
public ExpertApplyLogEntity GetExpertApplyInfo(ExpertApplyLogQuery query)
{
return ExpertApplyDataAccess.Instance.GetExpertApplyInfo(query);
}
/// <summary>
/// 获取专家申请信息实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExpertApplyLogEntity GetExpertApplyInfo(ExpertApplyLogQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExpertApplyLogEntity expertApplyEntity = clientHelper.PostAuth<ExpertApplyLogEntity, ExpertApplyLogQuery>(GetAPIUrl(APIConstant.EXPERTAPPLY_GETMODEL), query);
return expertApplyEntity;
}
/// <summary>
/// 获取专家申请信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<ExpertApplyLogEntity> GetExpertApplyInfoList(ExpertApplyLogQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<ExpertApplyLogEntity> listExpertApplyInfo = clientHelper.PostAuth<IList<ExpertApplyLogEntity>, ExpertApplyLogQuery>(GetAPIUrl(APIConstant.EXPERTAPPLY_GETLIST), query);
return listExpertApplyInfo;
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string ExpertApplyQueryToSQLOrder(ExpertApplyLogQuery query)
{
if (query.OrderByStr != null)
return query.OrderByStr;
else
return " PKID DESC";
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">查询对象</param>
/// <returns>Pager<AuthorInfoEntity></returns>
public Pager<ExpertApplyLogEntity> GetExpertApplyInfoPageList(ExpertApplyLogQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("ExpertApplyLog", "PKID,JournalID,LoginName,RealName,Gender,Birthday,Education,JobTitle,Tel,Mobile,WorkUnit,Address,ReviewDomain,ResearchTopics,BankID,BankType,ZipCode,Remark,Status,AddDate,ActionUser,ActionDate", query.OrderByStr, "", query.CurrentPage, query.PageSize, out recordCount);
Pager<ExpertApplyLogEntity> pager = new Pager<ExpertApplyLogEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeExpertApplyInfoList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
public List<ExpertApplyLogEntity> GetExpertApplyInfoList(ExpertApplyLogQuery query)
{
List<ExpertApplyLogEntity> list = new List<ExpertApplyLogEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT * FROM dbo.ExpertApplyLog WITH(NOLOCK)");
string whereSQL = ExpertApplyQueryToSQLWhere(query);
string orderBy = ExpertApplyQueryToSQLOrder(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 = MakeExpertApplyInfoList(dr);
}
return list;
}
/// <summary>
/// 获取专家申请信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExpertApplyLogEntity GetExpertApplyInfo(ExpertApplyLogQuery query)
{
ExpertApplyLogEntity expertApplyEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 * FROM dbo.ExpertApplyLog WITH(NOLOCK)");
string whereSQL = ExpertApplyQueryToSQLWhere(query);
if (!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL);
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using (IDataReader dr = db.ExecuteReader(cmd))
{
expertApplyEntity = MakeExpertApplyInfo(dr);
}
return expertApplyEntity;
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string ExpertApplyQueryToSQLWhere(ExpertApplyLogQuery query)
{
StringBuilder sbWhere = new StringBuilder(" JournalID = " + query.JournalID);
if (query.PKID>0)
{
sbWhere.Append(" AND PKID = " + query.PKID);
}
else
{
if (!string.IsNullOrWhiteSpace(query.LoginName))
{
sbWhere.Append(" AND LoginName = '").Append(WKT.Common.Security.SecurityUtils.SafeSqlString(query.LoginName)).Append("'");
}
//if (!string.IsNullOrWhiteSpace(query.RealName))
//{
// sbWhere.Append(" AND RealName like '%").Append(WKT.Common.Security.SecurityUtils.SafeSqlString(query.RealName)).Append("%'");
//}
//if (query.Status != null)
//{
// sbWhere.Append(" AND Status = '").Append(query.Status).Append("'");
//}
//if (query.ActionUser != null)
//{
// sbWhere.Append(" AND ActionUser = '******'");
//}
}
return sbWhere.ToString();
}