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