/// <summary>
/// 更新常用短语
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCommonWords(EyouSoft.Model.SMSStructure.CommonWords model)
{
bool result = false;
result = Dal.UpdateCommonWords(model);
handleLogsBll.Add(AddLogs("修改了常用短语", result));
return(result);
}
/// <summary>
/// 更新常用短语
/// </summary>
/// <param name="model">常用短语实体</param>
/// <returns></returns>
public bool UpdateCommonWords(EyouSoft.Model.SMSStructure.CommonWords model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_UPDATE_UPDATETEMPLATE);
this._db.AddInParameter(cmd, "CATEGORYID", DbType.Int32, model.ClassID);
this._db.AddInParameter(cmd, "CONTENT", DbType.String, model.WordContent);
this._db.AddInParameter(cmd, "TEMPLATEID", DbType.String, model.ID);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 添加常用短语
/// </summary>
/// <param name="model">常用短语实体</param>
/// <returns></returns>
public bool AddCommonWords(EyouSoft.Model.SMSStructure.CommonWords model)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_INSERTTEMPLATE);
this._db.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString());
this._db.AddInParameter(cmd, "COMPANYID", DbType.String, model.CompanyID);
this._db.AddInParameter(cmd, "USERID", DbType.String, model.UserID);
this._db.AddInParameter(cmd, "CLASSID", DbType.String, model.ClassID);
this._db.AddInParameter(cmd, "WORDCONTENT", DbType.String, model.WordContent);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) == 1 ? true : false);
}
/// <summary>
/// 添加常用短语
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddCommonWords(EyouSoft.Model.SMSStructure.CommonWords model)
{
if (model == null)
{
return(false);
}
bool result = false;
result = Dal.AddCommonWords(model);
handleLogsBll.Add(AddLogs("新增常用短语", result));
return(result);
}
/// <summary>
/// 获取一个常用短语实体
/// </summary>
/// <param name="Id">常用短语编号</param>
/// <returns></returns>
public EyouSoft.Model.SMSStructure.CommonWords GetCommonWords(string Id)
{
EyouSoft.Model.SMSStructure.CommonWords templateInfo = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GETTEMPLATEINFO);
this._db.AddInParameter(cmd, "TEMPLATEID", DbType.AnsiStringFixedLength, Id);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
templateInfo = new EyouSoft.Model.SMSStructure.CommonWords(rdr.GetString(rdr.GetOrdinal("ID")).Trim()
, rdr.GetInt32(rdr.GetOrdinal("CompanyID"))
, rdr.GetInt32(rdr.GetOrdinal("UserID"))
, rdr.GetInt32(rdr.GetOrdinal("ClassID"))
, rdr.IsDBNull(rdr.GetOrdinal("WordContent")) ? "" : rdr["WordContent"].ToString()
, rdr.GetDateTime(rdr.GetOrdinal("IssueTime"))
, string.Empty);
}
}
return(templateInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目, true);
return;
}
string sId = Utils.GetQueryStringValue("sid"); //短语Id
string method = Utils.GetFormValue("hidMethod"); //当前操作
EyouSoft.BLL.SMSStructure.CommonWords commonBll = new EyouSoft.BLL.SMSStructure.CommonWords();
if (method != "")
{
bool result = false;
Utils.InputText(txtSmsContent.Value, 200);//短信内容
Utils.InputText(selClass.Value);
string showMess = "数据保存成功！";
if (method == "save" || method == "continue")//如果是保存数据
{
#region 保存短语
int classId = Utils.GetInt(Utils.GetFormValue(selClass.UniqueID));
string commonWord = Utils.InputText(txtSmsContent.Value);
EyouSoft.Model.SMSStructure.CommonWords wordModel = new EyouSoft.Model.SMSStructure.CommonWords
{
ClassID = classId,
CompanyID = CurrentUserCompanyID,
IssueTime = DateTime.Now,
UserID = SiteUserInfo.ID,
WordContent = commonWord
};
if (sId != "")//短语id不为空修改
{
wordModel.ID = sId;
result = commonBll.UpdateCommonWords(wordModel);
}
else//短语id为空添加
{
result = commonBll.AddCommonWords(wordModel);
}
if (!result)
{
showMess = "数据保存失败";
}
if (method == "save")//如果是保存则关闭弹窗否则刷新页面
{
MessageBox.ResponseScript(this, string.Format(";alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='/SMS/CommonSms.aspx';", showMess, Utils.GetQueryStringValue("iframeId")));
}
else
{
MessageBox.ShowAndRedirect(this, showMess, "EditCommonSms.aspx");
}
return;
#endregion
}
if (method == "addClass")//添加类别
{
#region 添加类别
string className = Utils.GetFormValue("className");
EyouSoft.Model.SMSStructure.CommonWordClass wordClass =
new EyouSoft.Model.SMSStructure.CommonWordClass
{
ClassName = className,
CompanyID = CurrentUserCompanyID,
IssueTime = DateTime.Now,
UserID = SiteUserInfo.ID
};
int classId = commonBll.AddCommonWordsClass(wordClass);
//添加类别
Utils.ResponseMeg(classId != 0, classId.ToString());
return;
#endregion
}
if (method == "delClass")//删除类别
{
#region 除类别
int classId = Utils.GetInt(Utils.GetFormValue("classId"));
//删除类别
result = commonBll.DeleteCommonWordsClass(classId);
Utils.ResponseMeg(result, string.Empty);
return;
#endregion
}
}
else
{
#region 初始化数据
//绑定短语类别
IList <EyouSoft.Model.SMSStructure.CommonWordClass> classList = commonBll.GetCommonWordsClass(CurrentUserCompanyID);
if (classList != null && classList.Count > 0)
{
selClass.DataTextField = "ClassName";
selClass.DataValueField = "ID";
selClass.DataSource = classList;
selClass.DataBind();
}
selClass.Items.Insert(0, new ListItem("请选择", ""));
//初始化短语
if (sId != "")
{
EyouSoft.Model.SMSStructure.CommonWords wordModel = commonBll.GetCommonWords(sId);
if (wordModel != null)
{
txtSmsContent.Value = wordModel.WordContent;
selClass.Value = wordModel.ClassID.ToString();
}
}
#endregion
}
}