protected void Button1_Click(object sender, EventArgs e) { NCPEP.Model.T_YQ model = new NCPEP.Model.T_YQ(); NCPEP.Bll.T_YQ bll = new NCPEP.Bll.T_YQ(); if (Request.QueryString["id"] != null) { model = bll.GetModel(int.Parse(Request.QueryString["id"])); } model.yqleixing = this.txtNewsTypeId.SelectedValue; model.yqlianjie = this.txtNewsSubheading.Text.Trim(); model.yqname = this.txtNewsTitle.Text.Trim(); if (Request.QueryString["id"] != null) { if (bll.Update(model)) { MessageBox.ShowAndRedirect(this, "更新成功", "yqlist.aspx"); } } else { int fid = bll.Add(model); if (fid > 0) { MessageBox.ShowAndRedirect(this, "保存成功", "yqlist.aspx"); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(NCPEP.Model.T_YQ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_YQ set "); strSql.Append("yqname=@yqname,"); strSql.Append("yqleixing=@yqleixing,"); strSql.Append("yqlianjie=@yqlianjie,"); strSql.Append("beiyong=@beiyong"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@yqname", SqlDbType.NVarChar, 500), new SqlParameter("@yqleixing", SqlDbType.NVarChar, 500), new SqlParameter("@yqlianjie", SqlDbType.NVarChar, 500), new SqlParameter("@beiyong", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.yqname; parameters[1].Value = model.yqleixing; parameters[2].Value = model.yqlianjie; parameters[3].Value = model.beiyong; parameters[4].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { try { adminUser = Session["SuperAdminUserSession"] as AdminUser; if (null == adminUser) { if (!string.IsNullOrEmpty(Request.Cookies["AdminCookies"].Value)) { adminUser = new GetUserCookiesPlug().GetUserCookies(Request.Cookies["AdminCookies"]["SuperAdminUserSession"]); Session["SuperAdminUserSession"] = adminUser; } } } catch { adminUser = null; } if (null == adminUser) { ClientScript.RegisterClientScriptBlock(this.GetType(), "reload", " <script>parent.location.reload();</script>"); } if (!IsPostBack) { if (Request.QueryString["id"] != null) { NCPEP.Bll.T_YQ bll = new NCPEP.Bll.T_YQ(); NCPEP.Model.T_YQ model = new NCPEP.Model.T_YQ(); model = bll.GetModel(int.Parse(Request.QueryString["id"])); this.txtNewsSubheading.Text = model.yqlianjie; this.txtNewsTitle.Text = model.yqname; this.txtNewsTypeId.SelectedValue = model.yqleixing; } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(NCPEP.Model.T_YQ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_YQ("); strSql.Append("yqname,yqleixing,yqlianjie,beiyong)"); strSql.Append(" values ("); strSql.Append("@yqname,@yqleixing,@yqlianjie,@beiyong)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@yqname", SqlDbType.NVarChar, 500), new SqlParameter("@yqleixing", SqlDbType.NVarChar, 500), new SqlParameter("@yqlianjie", SqlDbType.NVarChar, 500), new SqlParameter("@beiyong", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.yqname; parameters[1].Value = model.yqleixing; parameters[2].Value = model.yqlianjie; parameters[3].Value = model.beiyong; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public NCPEP.Model.T_YQ DataRowToModel(DataRow row) { NCPEP.Model.T_YQ model = new NCPEP.Model.T_YQ(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["yqname"] != null) { model.yqname = row["yqname"].ToString(); } if (row["yqleixing"] != null) { model.yqleixing = row["yqleixing"].ToString(); } if (row["yqlianjie"] != null) { model.yqlianjie = row["yqlianjie"].ToString(); } if (row["beiyong"] != null) { model.beiyong = row["beiyong"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NCPEP.Model.T_YQ GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,yqname,yqleixing,yqlianjie,beiyong from T_YQ "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; NCPEP.Model.T_YQ model = new NCPEP.Model.T_YQ(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(NCPEP.Model.T_YQ model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(NCPEP.Model.T_YQ model) { return(dal.Add(model)); }