public Pager <MessageTemplateEntity> GetPageList(MessageTemplateQuery query)
{
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
Pager <MessageTemplateEntity> pager = service.GetMessageTemplatePageList(query);
return(pager);
}
public IList <MessageTemplateEntity> GetList(MessageTemplateQuery query)
{
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
IList <MessageTemplateEntity> list = service.GetMessageTemplateList(query);
return(list);
}
public ExecResult Del(MessageTemplateQuery query)
{
ExecResult execResult = new ExecResult();
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
Int64[] TemplateIDs = query.TemplateIDs;
if (TemplateIDs == null)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "没有删除任何数据！";
return(execResult);
}
string msg = query.TType == 2 ? "短信模版" : "邮件模版";
bool result = service.BatchDeleteMessageTemplate(TemplateIDs);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "删除" + msg + "成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "删除" + msg + "失败！";
}
return(execResult);
}
public ActionResult GetList(MessageTemplateQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.TType = 1;
IList <MessageTemplateEntity> list = service.GetMessageTempList(query);
return(Json(new { list }));
}
public ActionResult Delete(Int64[] TemplateIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
MessageTemplateQuery query = new MessageTemplateQuery();
query.JournalID = CurAuthor.JournalID;
query.TType = 1;
query.TemplateIDs = TemplateIDs;
ExecResult result = service.DelMessageTemp(query);
return(Json(new { result = result.result, msg = result.msg }));
}
public ActionResult GetPageList(MessageTemplateQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.TType = 1;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager <MessageTemplateEntity> pager = service.GetMessageTempPageList(query);
return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }));
}
public List <MessageTemplateEntity> GetMessageTemplateList(MessageTemplateQuery query)
{
string strSql = "SELECT * FROM dbo.MessageTemplate with(nolock)";
string whereSQL = MessageTemplateQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by TemplateID";
return(db.GetList <MessageTemplateEntity>(strSql, MakeMessageTemplateList));
}
public MessageTemplateEntity GetModel(MessageTemplateQuery query)
{
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
MessageTemplateEntity model = null;
if (query.ModelType == 1)
{
model = service.GetMessageTemplate(query.JournalID, query.TCategory.Value, query.TType.Value);
}
else
{
model = service.GetMessageTemplate(query.TemplateID.Value);
}
return(model);
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string MessageTemplateQueryToSQLWhere(MessageTemplateQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID=" + query.JournalID);
if (query.TType != null)
{
strFilter.AppendFormat(" and TType={0}", query.TType.Value);
}
if (query.TCategory != null)
{
strFilter.AppendFormat(" and TCategory={0}", query.TCategory);
}
query.Title = query.Title.TextFilter();
if (string.IsNullOrWhiteSpace(query.Title))
{
strFilter.AppendFormat(" and Title like '%{0}%'", query.Title);
}
return(strFilter.ToString());
}
private MessageTemplateEntity GetModel(Int64 TemplateID)
{
MessageTemplateEntity model = null;
if (TemplateID > 0)
{
MessageTemplateQuery query = new MessageTemplateQuery();
query.JournalID = CurAuthor.JournalID;
query.TType = 1;
query.TemplateID = TemplateID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetMessageTempModel(query);
}
if (model == null)
{
model = new MessageTemplateEntity();
}
return(model);
}
public Pager <MessageTemplateEntity> GetMessageTemplatePageList(MessageTemplateQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY TemplateID DESC) AS ROW_ID FROM dbo.MessageTemplate with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.MessageTemplate with(nolock)";
string whereSQL = MessageTemplateQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return(db.GetPageList <MessageTemplateEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeMessageTemplateList));
}
public IDictionary <int, string> GetTCategoryDictChecked(MessageTemplateQuery query)
{
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
return(service.GetTCategoryDcit(query.JournalID, query.TType.Value, true));
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string MessageTemplateQueryToSQLOrder(MessageTemplateQuery query)
{
return(" TemplateID DESC");
}
/// <summary>
/// 投稿
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveContributionInfo(ContributionInfoEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post <ExecResult, ContributionInfoEntity>(GetAPIUrl(APIConstant.CONTRIBUTIONINFO_SAVE), model);
if (result.result.Equals(EnumJsonResult.success.ToString()) && model.CID == 0 && model.Status != -1)//新投稿，不是草稿
{
#region 投稿回执
Action action = () =>
{
try
{
SiteConfigFacadeAPIService service = new SiteConfigFacadeAPIService();
MessageTemplateQuery queryTemp = new MessageTemplateQuery();
queryTemp.JournalID = model.JournalID;
queryTemp.TCategory = -5; //回执
var tempList = service.GetMessageTempList(queryTemp).ToList();
if (tempList == null)
{
return;
}
var EmailModel = tempList.Find(p => p.TType == 1);
var SmsModel = tempList.Find(p => p.TType == 2);
if (EmailModel == null && SmsModel == null)
{
return;
}
MessageRecodeEntity LogModel = new MessageRecodeEntity();
LogModel.JournalID = model.JournalID;
LogModel.SendType = -5;
LogModel.SendUser = model.AuthorID;
IDictionary <string, string> dict = service.GetEmailVariable();
var user = new AuthorFacadeAPIService().GetAuthorInfo(new AuthorInfoQuery()
{
JournalID = model.JournalID, AuthorID = model.AuthorID
});
dict["${接收人}$"] = user.RealName;
dict["${邮箱}$"] = user.LoginName;
dict["${手机}$"] = user.Mobile;
dict["${稿件编号}$"] = result.resultStr;
dict["${稿件标题}$"] = model.Title;
dict["$稿件主键$"] = result.resultID.ToString();
ExecResult execResult = new ExecResult();
if (EmailModel != null)
{
LogModel.MsgType = 1;
execResult = service.SendEmailOrSms(new Dictionary <Int64, IDictionary <string, string> >()
{
{ model.AuthorID, dict }
}, LogModel);
}
if (SmsModel != null)
{
LogModel.MsgType = 2;
execResult = service.SendEmailOrSms(new Dictionary <Int64, IDictionary <string, string> >()
{
{ model.AuthorID, dict }
}, LogModel);
}
if (!execResult.result.Equals(EnumJsonResult.success.ToString()))
{
throw new Exception(execResult.msg);
}
}
catch (Exception ex)
{
LogProvider.Instance.Error("发送投稿回执失败,稿件编码【" + result.resultStr + "】：" + ex.ToString());
}
};
action.BeginInvoke(null, null);
#endregion
}
return(result);
}
public IActionResult Index(MessageTemplateQuery model)
{
model.Results = new MessageTemplateRepo(db, partnerManager).GetByPartTitle(model.QMessage, true);
return(View(model));
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="messageTemplateQuery">MessageTemplateQuery查询实体对象</param>
/// <returns>List<MessageTemplateEntity></returns>
public List <MessageTemplateEntity> GetMessageTemplateList(MessageTemplateQuery messageTemplateQuery)
{
return(MessageTemplateBusProvider.GetMessageTemplateList(messageTemplateQuery));
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="messageTemplateQuery">MessageTemplateQuery查询实体对象</param>
/// <returns>Pager<MessageTemplateEntity></returns>
public Pager <MessageTemplateEntity> GetMessageTemplatePageList(MessageTemplateQuery messageTemplateQuery)
{
return(MessageTemplateDataAccess.Instance.GetMessageTemplatePageList(messageTemplateQuery));
}
