protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.CdModel = new SchoolDataModel(); } }
protected void ImageBtnSave_Click(object sender, EventArgs e) { this.CdModel = MakeUtil.getRequestDataToModel<SchoolDataModel>(Request, typeof(SchoolDataModel), -1); try { bll.add(CdModel); DbCacheHelper.UpdateCache<SchoolDataModel>("SchoolData"); MakeUtil.addOperationNote(Request.UserHostAddress, UserId.Value.Trim(), "学校资料新增", cdModel.SchoolNo); 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(SchoolDataModel schooldata) { SqlConnection cn = null; SqlTransaction tc = null; try { cn = DbHelperSQL.getConnection(); tc = DbHelperSQL.startTransaction(cn); //执行新增写进数据库 schooldataDal.add(cn, tc, schooldata); 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, SchoolDataModel model) { return DbHelperSQL.updateModel<SchoolDataModel>(model, "SchoolData", "Evenid", model.Evenid.ToString(), "'", cn, tc); }
public bool add(SqlConnection cn, SqlTransaction tc, SchoolDataModel model) { return DbHelperSQL.insertModel<SchoolDataModel>(model, "SchoolData", cn, tc); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // IList<QueryModel> qmList = new List<QueryModel>(); // qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, this.PrimaryKey)); // this.cdModel = bll.getModel(qmList); var list = DbCacheHelper.GetCache<SchoolDataModel>("SchoolData").Where(p=>p.SchoolNo == this.PrimaryKey); this.cdModel = list.FirstOrDefault(); if (cdModel == null || this.cdModel.SchoolNo == "") { Script.alertMsg("学校资料:" + PrimaryKey, this.Page); Script.closeDivWin(this.Page, "SchoolDataModify" + PrimaryKey); return; } this.DataBind(); } }