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