/// <summary>
/// 更新常用短语
/// </summary>
/// <param name="templateInfo">常用短语业务实体</param>
/// <returns></returns>
public virtual bool UpdateTemplate(EyouSoft.Model.SMSStructure.TemplateInfo templateInfo)
{
DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_UPDATE_UPDATETEMPLATE);
base.SMSStore.AddInParameter(cmd, "CATEGORYID", DbType.Int32, templateInfo.CategoryId);
base.SMSStore.AddInParameter(cmd, "CONTENT", DbType.String, templateInfo.Content);
base.SMSStore.AddInParameter(cmd, "TEMPLATEID", DbType.String, templateInfo.TemplateId);
return(DbHelper.ExecuteSql(cmd, base.SMSStore) > 0 ? true : false);
}
/// <summary>
/// 插入常用短语
/// </summary>
/// <param name="templateInfo">常用短语业务实体</param>
/// <returns></returns>
public virtual bool InsertTemplate(EyouSoft.Model.SMSStructure.TemplateInfo templateInfo)
{
DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_INSERT_INSERTTEMPLATE);
base.SMSStore.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, templateInfo.TemplateId);
base.SMSStore.AddInParameter(cmd, "COMPANYID", DbType.String, templateInfo.CompanyId);
base.SMSStore.AddInParameter(cmd, "USERID", DbType.String, templateInfo.UserId);
base.SMSStore.AddInParameter(cmd, "CLASSID", DbType.String, templateInfo.CategoryId);
base.SMSStore.AddInParameter(cmd, "WORDCONTENT", DbType.String, templateInfo.Content);
return(DbHelper.ExecuteSql(cmd, base.SMSStore) == 1 ? true : false);
}
protected void AddOrUpdatePhrase(string method)
{
if (!IsCompanyCheck)
{
Utils.ResponseMeg(false, "对不起,你尚未审核通过!");
return;
}
string content = Utils.InputText(Server.UrlDecode(Request.Form["content"] ?? "")).Trim();
string cateName = Utils.InputText(Server.UrlDecode(Request.Form["catename"] ?? "")).Trim();
int cateId = Utils.GetInt(Request.Form["cateid"]);
string phraseid = Utils.GetFormValue("phraseid");
EyouSoft.Model.SMSStructure.TemplateInfo tempModel = new EyouSoft.Model.SMSStructure.TemplateInfo();
if (method == "update")//修改短语时获取原短语实体
{
tempModel = tempBll.GetTemplateInfo(phraseid);
}
tempModel.CategoryId = cateId;
tempModel.CategoryName = cateName;
tempModel.CompanyId = SiteUserInfo.CompanyID;
tempModel.Content = content;
tempModel.UserId = SiteUserInfo.ID;
bool isSuccess = true;
if (method == "update")
{
isSuccess = tempBll.UpdateTemplate(tempModel);//更新到数据库
}
else if (method == "add")
{
isSuccess = tempBll.InsertTemplate(tempModel);//添加到数据库
}
if (isSuccess)
{
Utils.ResponseMegSuccess();
}
else
{
Utils.ResponseMegError();
}
}
protected void LoadData()
{
//绑定短语类型
pe_selPhraseClass.DataTextField = "CategoryName";
pe_selPhraseClass.DataValueField = "CategoryId";
pe_selPhraseClass.DataSource = tempBll.GetCategorys(SiteUserInfo.CompanyID);
pe_selPhraseClass.DataBind();
pe_selPhraseClass.Items.Insert(0, new ListItem("选择类别", ""));
string pId = Utils.GetQueryStringValue("phraseid");
if (pId != "")
{
EyouSoft.Model.SMSStructure.TemplateInfo tempModel = tempBll.GetTemplateInfo(pId);
if (tempModel != null)
{
isAdd = "update";
phraseId = pId;
pe_selPhraseClass.Value = tempModel.CategoryId.ToString();
pe_txtContent.Value = tempModel.Content;
}
}
}
/// <summary>
/// 获取常用短语信息
/// </summary>
/// <param name="templateId">常用短语编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.SMSStructure.TemplateInfo GetTemplateInfo(string templateId)
{
EyouSoft.Model.SMSStructure.TemplateInfo templateInfo = null;
DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_SELECT_GETTEMPLATEINFO);
base.SMSStore.AddInParameter(cmd, "TEMPLATEID", DbType.AnsiStringFixedLength, templateId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SMSStore))
{
if (rdr.Read())
{
templateInfo = new EyouSoft.Model.SMSStructure.TemplateInfo(rdr.GetString(rdr.GetOrdinal("ID"))
, rdr.GetString(rdr.GetOrdinal("CompanyID"))
, rdr.GetString(rdr.GetOrdinal("UserID"))
, rdr.GetInt32(rdr.GetOrdinal("ClassID"))
, string.Empty
, rdr["WordContent"].ToString()
, rdr.GetDateTime(rdr.GetOrdinal("IssueTime")));
}
}
return(templateInfo);
}
/// <summary>
/// 插入常用短语
/// </summary>
/// <param name="templateInfo">常用短语业务实体</param>
/// <returns></returns>
public bool InsertTemplate(EyouSoft.Model.SMSStructure.TemplateInfo templateInfo)
{
templateInfo.TemplateId = Guid.NewGuid().ToString();
return(dal.InsertTemplate(templateInfo));
}
/// <summary>
/// 更新常用短语
/// </summary>
/// <param name="templateInfo">常用短语业务实体</param>
/// <returns></returns>
public bool UpdateTemplate(EyouSoft.Model.SMSStructure.TemplateInfo templateInfo)
{
return(dal.UpdateTemplate(templateInfo));
}
