protected void Button1_Click(object sender, EventArgs e) { NCPEP.Bll.T_XMGG bll = new NCPEP.Bll.T_XMGG(); NCPEP.Model.T_XMGG model = new NCPEP.Model.T_XMGG(); if (Request.QueryString["id"] != null) { model = bll.GetModel(int.Parse(Request.QueryString["id"])); } model.bid = int.Parse(this.txtNewsTypeId.SelectedValue); model.xmby = "0"; model.xmneirong = this.content1.Value; try { model.xmsj = DateTime.Parse(this.txtsj.Text).ToString("yyyy-MM-dd"); } catch { } model.xmtitle = this.txtNewsTitle.Text.Trim(); if (Request.QueryString["id"] != null) { if (bll.Update(model)) { MessageBox.ShowAndRedirect(this, "更新成功", "xmgglist.aspx"); } } else { int fid = bll.Add(model); if (fid > 0) { MessageBox.ShowAndRedirect(this, "保存成功", "xmgglist.aspx"); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(NCPEP.Model.T_XMGG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_XMGG set "); strSql.Append("bid=@bid,"); strSql.Append("xmtitle=@xmtitle,"); strSql.Append("xmneirong=@xmneirong,"); strSql.Append("xmsj=@xmsj,"); strSql.Append("xmbz=@xmbz,"); strSql.Append("xmby=@xmby"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@bid", SqlDbType.Int, 4), new SqlParameter("@xmtitle", SqlDbType.VarChar, 50), new SqlParameter("@xmneirong", SqlDbType.NVarChar, -1), new SqlParameter("@xmsj", SqlDbType.NVarChar, 50), new SqlParameter("@xmbz", SqlDbType.NVarChar, 50), new SqlParameter("@xmby", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.bid; parameters[1].Value = model.xmtitle; parameters[2].Value = model.xmneirong; parameters[3].Value = model.xmsj; parameters[4].Value = model.xmbz; parameters[5].Value = model.xmby; parameters[6].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) { BindDll(); if (Request.QueryString["id"] != null) { NCPEP.Model.T_XMGG model = new NCPEP.Model.T_XMGG(); NCPEP.Bll.T_XMGG bll = new NCPEP.Bll.T_XMGG(); model = bll.GetModel(int.Parse(Request.QueryString["id"])); if (model != null) { this.txtNewsTypeId.SelectedValue = model.bid.ToString(); this.txtNewsTitle.Text = model.xmtitle; this.txtsj.Text = model.xmsj; this.content1.Value = model.xmneirong; } } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(NCPEP.Model.T_XMGG model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_XMGG("); strSql.Append("bid,xmtitle,xmneirong,xmsj,xmbz,xmby)"); strSql.Append(" values ("); strSql.Append("@bid,@xmtitle,@xmneirong,@xmsj,@xmbz,@xmby)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@bid", SqlDbType.Int, 4), new SqlParameter("@xmtitle", SqlDbType.VarChar, 50), new SqlParameter("@xmneirong", SqlDbType.NVarChar, -1), new SqlParameter("@xmsj", SqlDbType.NVarChar, 50), new SqlParameter("@xmbz", SqlDbType.NVarChar, 50), new SqlParameter("@xmby", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.bid; parameters[1].Value = model.xmtitle; parameters[2].Value = model.xmneirong; parameters[3].Value = model.xmsj; parameters[4].Value = model.xmbz; parameters[5].Value = model.xmby; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public NCPEP.Model.T_XMGG DataRowToModel(DataRow row) { NCPEP.Model.T_XMGG model = new NCPEP.Model.T_XMGG(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["bid"] != null && row["bid"].ToString() != "") { model.bid = int.Parse(row["bid"].ToString()); } if (row["xmtitle"] != null) { model.xmtitle = row["xmtitle"].ToString(); } if (row["xmneirong"] != null) { model.xmneirong = row["xmneirong"].ToString(); } if (row["xmsj"] != null) { model.xmsj = row["xmsj"].ToString(); } if (row["xmbz"] != null) { model.xmbz = row["xmbz"].ToString(); } if (row["xmby"] != null) { model.xmby = row["xmby"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NCPEP.Model.T_XMGG GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,bid,xmtitle,xmneirong,xmsj,xmbz,xmby from T_XMGG "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; NCPEP.Model.T_XMGG model = new NCPEP.Model.T_XMGG(); 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_XMGG model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(NCPEP.Model.T_XMGG model) { return(dal.Add(model)); }