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 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);
}
/// <summary>
/// 获取一个实体对象
/// </summary>
/// <param name="templateID"></param>
/// <returns>获取一个实体，如果数据不存在返回Null</returns>
public MessageTemplateEntity GetMessageTemplate(Int64 templateID)
{
MessageTemplateEntity model = MessageTemplateBusProvider.GetMessageTemplate(templateID);
if (model != null)
{
var dict = GetTCategoryDcit(model.JournalID, model.TType, false);
model.TCategoryName = dict.ContainsKey(model.TCategory) ? dict[model.TCategory] : string.Empty;
}
return(model);
}
/// <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 List <MessageTemplateEntity> MakeMessageTemplateList(DataTable dt)
{
List <MessageTemplateEntity> list = new List <MessageTemplateEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
MessageTemplateEntity messageTemplateEntity = MakeMessageTemplate(dt.Rows[i]);
list.Add(messageTemplateEntity);
}
}
return(list);
}
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>
/// 保存模版
/// </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 MessageTemplateEntity GetMessageTemplate(Int64 templateID)
{
MessageTemplateEntity messageTemplateEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 TemplateID,JournalID,TType,Title,TContent,TCategory,EditUser,EditDate,InUser,AddDate FROM dbo.MessageTemplate WITH(NOLOCK)");
sqlCommandText.Append(" WHERE TemplateID=@TemplateID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@TemplateID", DbType.Int64, templateID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
messageTemplateEntity = MakeMessageTemplate(dr);
}
return(messageTemplateEntity);
}
public ActionResult Save(MessageTemplateEntity model)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model.JournalID = CurAuthor.JournalID;
model.TType = 1;
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 }));
}
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 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);
}
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 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="messageTemplate">MessageTemplateEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteMessageTemplate(MessageTemplateEntity messageTemplate)
{
return(MessageTemplateBusProvider.DeleteMessageTemplate(messageTemplate));
}
public ExecResult Save(MessageTemplateEntity model)
{
IMessageTemplateService service = ServiceContainer.Instance.Container.Resolve <IMessageTemplateService>();
return(service.Save(model));
}
/// <summary>
/// 获取缴费通知实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PayNoticeEntity GetPayNoticeModel(PayNoticeQuery query)
{
PayNoticeEntity model = null;
try
{
if (query.NoticeID > 0)
{
HttpClientHelper clientHelper = new HttpClientHelper();
model = clientHelper.Post <PayNoticeEntity, PayNoticeQuery>(GetAPIUrl(APIConstant.PAYNOTICE_GETMODEL), query);
}
if (model == null)
{
model = new PayNoticeEntity();
model.JournalID = query.JournalID;
model.PayType = query.PayType.Value;
model.CID = query.CID.Value;
SiteConfigFacadeAPIService service = new SiteConfigFacadeAPIService();
MessageTemplateEntity temp = null;
if (model.PayType == 1)
{
temp = service.GetMessageTemplate(model.JournalID, -3, 1);
}
else if (model.PayType == 2)
{
temp = service.GetMessageTemplate(model.JournalID, -4, 1);
}
if (temp != null)
{
model.Body = temp.TContent;
}
if (!string.IsNullOrWhiteSpace(model.Body))
{
AuthorPlatformFacadeAPIService authorService = new AuthorPlatformFacadeAPIService();
ContributionInfoQuery authorQuery = new ContributionInfoQuery();
authorQuery.JournalID = model.JournalID;
authorQuery.CID = model.CID;
authorQuery.IsAuxiliary = false;
var contribution = authorService.GetContributionInfoModel(authorQuery);
if (contribution != null)
{
IDictionary <string, string> dict = service.GetEmailVariable();
var user = new AuthorFacadeAPIService().GetAuthorInfo(new AuthorInfoQuery()
{
JournalID = model.JournalID, AuthorID = contribution.AuthorID
});
if (!query.IsBatch)
{
dict["${接收人}$"] = user.RealName;
dict["${邮箱}$"] = user.LoginName;
dict["${手机}$"] = user.Mobile;
dict["${稿件编号}$"] = contribution.CNumber;
dict["${稿件标题}$"] = contribution.Title;
model.Body = service.GetEmailOrSmsContent(dict, service.GetSiteConfig(model.JournalID), model.Body);
}
else
{
query.AuthorName = user.RealName;
query.LoginName = user.LoginName;
query.Mobile = user.Mobile;
query.CNumber = contribution.CNumber;
query.Title = contribution.Title;
}
}
}
}
}
catch (Exception ex)
{
LogProvider.Instance.Error("获取通知单失败：" + ex.ToString());
model = new PayNoticeEntity();
model.JournalID = query.JournalID;
model.PayType = query.PayType.Value;
model.CID = query.CID.Value;
}
return(model);
}
/// <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(MessageTemplateDataAccess.Instance.DeleteMessageTemplate(messageTemplate));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="messageTemplate">MessageTemplateEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddMessageTemplate(MessageTemplateEntity messageTemplate)
{
return(MessageTemplateBusProvider.AddMessageTemplate(messageTemplate));
}
