public bool AddMessageTemplate(MessageTemplateEntity messageTemplateEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @TType"); sqlCommandText.Append(", @Title"); sqlCommandText.Append(", @TContent"); sqlCommandText.Append(", @TCategory"); sqlCommandText.Append(", @InUser"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.MessageTemplate ({0}) VALUES ({1})",sqlCommandText.ToString().Replace("@", ""),sqlCommandText.ToString())); db.AddInParameter(cmd,"@JournalID",DbType.Int64,messageTemplateEntity.JournalID); db.AddInParameter(cmd,"@TType",DbType.Byte,messageTemplateEntity.TType); db.AddInParameter(cmd,"@Title",DbType.AnsiString,messageTemplateEntity.Title); db.AddInParameter(cmd,"@TContent",DbType.AnsiString,messageTemplateEntity.TContent); db.AddInParameter(cmd,"@TCategory",DbType.Int32,messageTemplateEntity.TCategory); db.AddInParameter(cmd,"@InUser",DbType.Int64,messageTemplateEntity.InUser); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }
private MessageTemplateEntity GetModel(Int64 TemplateID) { MessageTemplateEntity model = null; if (TemplateID > 0) { MessageTemplateQuery query = new MessageTemplateQuery(); query.JournalID = CurAuthor.JournalID; query.TType = 2; query.TemplateID = TemplateID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>(); model = service.GetMessageTempModel(query); } if (model == null) model = new MessageTemplateEntity(); return model; }
public ActionResult Save(MessageTemplateEntity model) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>(); model.JournalID = CurAuthor.JournalID; model.TType = 2; if (model.TemplateID == 0) model.InUser = CurAuthor.AuthorID; else model.EditUser = CurAuthor.AuthorID; model.TContent = Server.UrlDecode(model.TContent); ExecResult result = service.SaveMessageTemp(model); return Json(new { result = result.result, msg = result.msg }); }
public ExecResult Save(MessageTemplateEntity model) { IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve<IMessageTemplateService>(); return service.Save(model); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="messageTemplate">MessageTemplateEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteMessageTemplate(MessageTemplateEntity messageTemplate) { return MessageTemplateDataAccess.Instance.DeleteMessageTemplate(messageTemplate); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="messageTemplate">MessageTemplateEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddMessageTemplate(MessageTemplateEntity messageTemplate) { return MessageTemplateDataAccess.Instance.AddMessageTemplate(messageTemplate); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="messageTemplate">MessageTemplateEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteMessageTemplate(MessageTemplateEntity messageTemplate) { return MessageTemplateBusProvider.DeleteMessageTemplate(messageTemplate); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="messageTemplate">MessageTemplateEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddMessageTemplate(MessageTemplateEntity messageTemplate) { return MessageTemplateBusProvider.AddMessageTemplate(messageTemplate); }
/// <summary> /// 保存模版 /// </summary> /// <param name="model"></param> /// <returns></returns> public ExecResult Save(MessageTemplateEntity model) { ExecResult execResult = new ExecResult(); bool result = false; model.Title = model.Title.TextFilter(); string msg = string.Empty; if (model.TType == 2) { msg = "短信模版"; model.TContent = model.TContent.TextFilter(); } else { msg = "邮件模版"; model.TContent = model.TContent.HtmlFilter(); } if (model.TemplateID == 0) { result = AddMessageTemplate(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "新增" + msg + "成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "新增" + msg + "失败!"; } } else { result = UpdateMessageTemplate(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "修改" + msg + "成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "修改" + msg + "失败!"; } } return execResult; }
public bool UpdateMessageTemplate(MessageTemplateEntity messageTemplateEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" TemplateID=@TemplateID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" Title=@Title"); sqlCommandText.Append(", TContent=@TContent"); sqlCommandText.Append(", TCategory=@TCategory"); sqlCommandText.Append(", EditUser=@EditUser"); sqlCommandText.Append(", EditDate=getdate()"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.MessageTemplate SET {0} WHERE {1}",sqlCommandText.ToString(),whereCommandText.ToString())); db.AddInParameter(cmd,"@TemplateID",DbType.Int64,messageTemplateEntity.TemplateID); db.AddInParameter(cmd,"@Title",DbType.AnsiString,messageTemplateEntity.Title); db.AddInParameter(cmd,"@TContent",DbType.AnsiString,messageTemplateEntity.TContent); db.AddInParameter(cmd,"@TCategory",DbType.Int32,messageTemplateEntity.TCategory); db.AddInParameter(cmd,"@EditUser",DbType.Int64,messageTemplateEntity.EditUser); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }
public List<MessageTemplateEntity> MakeMessageTemplateList(IDataReader dr) { List<MessageTemplateEntity> list=new List<MessageTemplateEntity>(); while(dr.Read()) { MessageTemplateEntity messageTemplateEntity=new MessageTemplateEntity(); messageTemplateEntity.TemplateID = (Int64)dr["TemplateID"]; messageTemplateEntity.JournalID = (Int64)dr["JournalID"]; messageTemplateEntity.TType = Convert.IsDBNull(dr["TType"]) ? (Byte)1 : (Byte)dr["TType"]; messageTemplateEntity.Title = Convert.IsDBNull(dr["Title"]) ? string.Empty : (String)dr["Title"]; messageTemplateEntity.TContent = Convert.IsDBNull(dr["TContent"]) ? string.Empty : (String)dr["TContent"]; messageTemplateEntity.TCategory = Convert.IsDBNull(dr["TCategory"]) ? -1 : (Int32)dr["TCategory"]; messageTemplateEntity.EditUser = (Int64)dr["EditUser"]; messageTemplateEntity.EditDate = (DateTime)dr["EditDate"]; messageTemplateEntity.InUser = (Int64)dr["InUser"]; messageTemplateEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(messageTemplateEntity); } dr.Close(); return list; }
public MessageTemplateEntity MakeMessageTemplate(DataRow dr) { MessageTemplateEntity messageTemplateEntity=null; if(dr!=null) { messageTemplateEntity=new MessageTemplateEntity(); messageTemplateEntity.TemplateID = (Int64)dr["TemplateID"]; messageTemplateEntity.JournalID = (Int64)dr["JournalID"]; messageTemplateEntity.TType = Convert.IsDBNull(dr["TType"]) ? (Byte)1 : (Byte)dr["TType"]; messageTemplateEntity.Title = Convert.IsDBNull(dr["Title"]) ? string.Empty : (String)dr["Title"]; messageTemplateEntity.TContent = Convert.IsDBNull(dr["TContent"]) ? string.Empty : (String)dr["TContent"]; messageTemplateEntity.TCategory = Convert.IsDBNull(dr["TCategory"]) ? -1 : (Int32)dr["TCategory"]; messageTemplateEntity.EditUser = (Int64)dr["EditUser"]; messageTemplateEntity.EditDate = (DateTime)dr["EditDate"]; messageTemplateEntity.InUser = (Int64)dr["InUser"]; messageTemplateEntity.AddDate = (DateTime)dr["AddDate"]; } return messageTemplateEntity; }
/// <summary> /// 获取短信邮件模版实体 /// </summary> /// <param name="JournalID"></param> /// <param name="TCategory"></param> /// <param name="TType"></param> /// <returns></returns> public MessageTemplateEntity GetMessageTemplate(Int64 JournalID, Int32 TCategory, Byte TType) { MessageTemplateEntity model = new MessageTemplateEntity(); string strSql = string.Format("SELECT top 1 * FROM dbo.MessageTemplate with(nolock) where JournalID={0} and TCategory={1} and TType={2}", JournalID, TCategory, TType); DbCommand cmd = db.GetSqlStringCommand(strSql); using (IDataReader dr = db.ExecuteReader(cmd)) { model = MakeMessageTemplate(dr); } return model; }
public bool DeleteMessageTemplate(MessageTemplateEntity messageTemplateEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.MessageTemplate"); sqlCommandText.Append(" WHERE TemplateID=@TemplateID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd,"@TemplateID",DbType.Int64,messageTemplateEntity.TemplateID); try { db.ExecuteNonQuery(cmd); flag = true; } catch(SqlException sqlEx) { throw sqlEx; } return flag; }
/// <summary> /// 保存邮件短信模版数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public ExecResult SaveMessageTemp(MessageTemplateEntity model) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult result = clientHelper.Post<ExecResult, MessageTemplateEntity>(GetAPIUrl(APIConstant.MESSAGETEMP_SAVE), model); return result; }