public void add(WXTemplateSettingModel wxtemplatesetting)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
wxtemplatesettingDal.add(cn, tc, wxtemplatesetting);
DbCacheHelper.UpdateCache<WXTemplateSettingDto>("WXTemplateSettingV", cn, tc);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
protected void ImageBtnSave_Click(object sender, ImageClickEventArgs e)
{
this.WxTemplateSettingModel = MakeUtil.getRequestDataToModel<WXTemplateSettingModel>(Request, typeof(WXTemplateSettingModel), -1);
try
{
var qmlist = new List<QueryModel>();
qmlist.Add(MakeUtil.getQueryModel("TemplateType", "'", SqlWhere.WhereOperator.Equal, WxTemplateSettingModel.TemplateType));
if (_iwxTemplateSettingEbi.getModelList(qmlist, -1).Count == 0)
{
_iwxTemplateSettingEbi.add(WxTemplateSettingModel);
}
else
{
_iwxTemplateSettingEbi.update(WxTemplateSettingModel);
}
MakeUtil.addOperationNote(Request.UserHostAddress, UserId.Trim(), "微信模版发送设置", WxTemplateSettingModel.TemplateId);
Script.alertMsg("修改成功", Page);
Script.scriptRedirect("WXTemplateSeting.aspx?TemplateType=" + WxTemplateSettingModel.TemplateType, this.Page);
}
catch (Make.Exp.MakeException mEx)
{
Script.alertMsg(mEx.Message, this.Page);
this.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (true)
{
TemplateType = MakeUtil.getStringFromRequestByName(Request, "TemplateType", -1);
if (TemplateType == "")
{
TemplateType = Helper.TemplateType.XiaoFeiDuanXin;
}
var qmlist = new List<QueryModel>();
qmlist.Add(MakeUtil.getQueryModel("TemplateType", "'", SqlWhere.WhereOperator.Equal, TemplateType));
WxTemplateSettingModel = _iwxTemplateSettingEbi.getModel(qmlist);
// WxTemplateSettingModel = new WXTemplateSettingModel();
WxPlateList.DataSource = _wxppe.getModelList(null, -1);
this.DataBind();
}
}
public bool update(SqlConnection cn, SqlTransaction tc, WXTemplateSettingModel model)
{
return DbHelperSQL.updateModel<WXTemplateSettingModel>(model, "WXTemplateSetting", "Evenid", model.Evenid.ToString(), "'", cn, tc);
}
public bool add(SqlConnection cn, SqlTransaction tc, WXTemplateSettingModel model)
{
return DbHelperSQL.insertModel<WXTemplateSettingModel>(model, "WXTemplateSetting", cn, tc);
}
