protected void ImageBtnSave_Click(object sender, ImageClickEventArgs e)
{
this.mpmodel = MakeUtil.getRequestDataToModel<MainPageFeaturesModel>(Request, typeof(MainPageFeaturesModel), -1);
try
{
if (mpmodel.SchoolNo == "")
{
throw new Exception("请选择学校");
}
var flcount = mpmodel.Features.Split(',').Count();
if (flcount > mpmodel.FeaturesNum)
{
throw new Exception("功能数量过多");
}
var qmlist = new List<QueryModel>();
qmlist.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, mpmodel.SchoolNo));
var model = _mainPageFeaturesEbi.getModel(qmlist);
if (model.Evenid <= 0)
{
_mainPageFeaturesEbi.add(mpmodel);
}
else
{
mpmodel.Evenid = model.Evenid;
_mainPageFeaturesEbi.update(mpmodel);
}
MakeUtil.addOperationNote(Request.UserHostAddress, UserId.Trim(), "主页功能设置", mpmodel.SchoolNo);
Script.alertMsg("修改成功", Page);
this.DataBind();
}
catch (Make.Exp.MakeException mEx)
{
Script.alertMsg(mEx.Message, this.Page);
this.DataBind();
}
catch (Exception mEx)
{
Script.alertMsg(mEx.Message, this.Page);
this.DataBind();
}
}
public void add(MainPageFeaturesModel mainpagefeatures)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
mainpagefeaturesDal.add(cn, tc, mainpagefeatures);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
public bool update(SqlConnection cn, SqlTransaction tc, MainPageFeaturesModel model)
{
return DbHelperSQL.updateModel<MainPageFeaturesModel>(model, "MainPageFeatures", "Evenid", model.Evenid.ToString(), "'", cn, tc);
}
public bool add(SqlConnection cn, SqlTransaction tc, MainPageFeaturesModel model)
{
return DbHelperSQL.insertModel<MainPageFeaturesModel>(model, "MainPageFeatures", cn, tc);
}
protected void Page_Load(object sender, EventArgs e)
{
SchoolNo = MakeUtil.getStringFromRequestByName(Request, "SchoolNo", -1);
if (IsPostBack)
{
var qmlist = new List<QueryModel>();
qmlist.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, SchoolNo));
mpmodel = _mainPageFeaturesEbi.getModel(qmlist);
this.DataBind();
}
}