protected void ImageBtnSave_Click(object sender, EventArgs e) { try { IList<QueryModel> qmList = new List<QueryModel>(); qmList.Add(MakeUtil.getQueryModel("Evenid", "'", SqlWhere.WhereOperator.Equal, this.PrimaryKey)); qmList.Add(MakeUtil.getQueryModel("NewsType", "'", SqlWhere.WhereOperator.Equal, this.NewsType)); this.lModel = _schoolNewsEbi.getModel(qmList); if (this.lModel.Evenid <= 0) { Script.alertMsg("没找此资料", this.Page); Script.closeDivWin(this.Page, "SchoolNews" + NewsType + "Modify" + PrimaryKey); return; } DateTime tempHappenDate = lModel.HappenDate; this.LModel = MakeUtil.getRequestDataToModel<SchoolNewsModel>(Request, typeof(SchoolNewsModel), -1); if (lModel.Remarks.Trim() == "") { Script.alertMsg("查看全文内容不能为空,保存失败", Page); this.DataBind(); return; } LModel.HappenDate = tempHappenDate; _schoolNewsEbi.update(this.LModel); MakeUtil.addOperationNote(Request.UserHostAddress, UserId.Value.Trim(), NewsTypeName + "资料修改", lModel.Evenid.ToString()); Script.alertMsg("修改成功", Page); Script.scriptRedirect(Request.RawUrl, this.Page); } catch (Make.Exp.MakeException mEx) { Script.alertMsg(mEx.Message, this.Page); this.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IList<QueryModel> qmList = new List<QueryModel>(); qmList.Add(MakeUtil.getQueryModel("Evenid", "'", SqlWhere.WhereOperator.Equal, this.PrimaryKey)); this.lModel = _schoolNewsEbi.getModel(qmList); if (this.lModel.Evenid <= 0) { Response.Redirect("WX_SchoolAbout.aspx"); } this.DataBind(); } }
protected void ImageBtnSave_Click(object sender, EventArgs e) { this.lModel = MakeUtil.getRequestDataToModel<SchoolNewsModel>(Request, typeof(SchoolNewsModel), -1); if (lModel.Remarks.Trim() == "") { Script.alertMsg("查看全文内容不能为空,保存失败", Page); this.DataBind(); return; } try { lModel.HappenDate = DateTime.Now; _schoolNewsEbi.add(lModel); MakeUtil.addOperationNote(Request.UserHostAddress, userid.Trim(), "最新动态新增", lModel.Headlines); Script.alertMsg("新增成功", Page); Script.scriptRedirect(Request.RawUrl, this.Page); } catch (Make.Exp.MakeException mEx) { Script.alertMsg(mEx.Message, this.Page); this.DataBind(); } }
public void add(SchoolNewsModel schoolnews) { SqlConnection cn = null; SqlTransaction tc = null; try { cn = DbHelperSQL.getConnection(); tc = DbHelperSQL.startTransaction(cn); //执行新增写进数据库 schoolnewsDal.add(cn, tc, schoolnews); 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, SchoolNewsModel model) { return DbHelperSQL.updateModel<SchoolNewsModel>(model, "SchoolNews", "Evenid", model.Evenid.ToString(), "'", cn, tc); }
public bool add(SqlConnection cn, SqlTransaction tc, SchoolNewsModel model) { return DbHelperSQL.insertModel<SchoolNewsModel>(model, "SchoolNews", cn, tc); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IList<QueryModel> qmList = new List<QueryModel>(); qmList.Add(MakeUtil.getQueryModel("Evenid", "'", SqlWhere.WhereOperator.Equal, this.PrimaryKey)); qmList.Add(MakeUtil.getQueryModel("NewsType", "'", SqlWhere.WhereOperator.Equal, this.NewsType)); this.lModel = _schoolNewsEbi.getModel(qmList); if (this.lModel.Evenid <= 0) { Script.alertMsg("没找此资料", this.Page); Script.closeDivWin(this.Page, "SchoolNews" + NewsType + "Modify" + PrimaryKey); return; } Remarks.Text = lModel.Remarks; this.DataBind(); } }