/// <summary> /// 更新一条数据 /// </summary> public bool UpdateNewsClass(Cms.Model.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NewsClass set "); strSql.Append("Title=@Title,"); strSql.Append("ClassOrder=@ClassOrder"); strSql.Append(" where ClassID=@ClassID"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@ClassOrder", SqlDbType.Int, 4), new SqlParameter("@ClassID", SqlDbType.Int, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.ClassOrder; parameters[2].Value = model.ClassID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int AddNewsClass(Cms.Model.NewsClass model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NewsClass("); strSql.Append("Title,ClassOrder)"); strSql.Append(" values ("); strSql.Append("@Title,@ClassOrder)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@ClassOrder", SqlDbType.Int, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.ClassOrder; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public int classId; //ID protected void Page_Load(object sender, EventArgs e) { //取得栏目传参 if (int.TryParse(Request.Params["classId"], out classId)) { model = dal.GetNewsClassModel(classId); if (!Page.IsPostBack) { //数据绑定 ShowInfo(); } } else { Response.Write("<script>alert('您要修改类别的种类不明确或参数不正确!');history.go(-1);</script>"); } }
protected void Page_Load(object sender, EventArgs e) { //取得栏目传参 if (int.TryParse(Request.Params["classId"], out classId)) { model = dal.GetNewsClassModel(classId); if (!Page.IsPostBack) { //数据绑定 ShowInfo(); } } else { Response.Write("<script>alert('您要修改类别的种类不明确或参数不正确!');history.go(-1);</script>"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.NewsClass GetNewsClassModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ClassID,Title,ClassOrder from NewsClass "); strSql.Append(" where ClassID=@ClassID"); SqlParameter[] parameters = { new SqlParameter("@ClassID", SqlDbType.Int, 4) }; parameters[0].Value = Id; Cms.Model.NewsClass model = new Cms.Model.NewsClass(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ClassID"] != null && ds.Tables[0].Rows[0]["ClassID"].ToString() != "") { model.ClassID = int.Parse(ds.Tables[0].Rows[0]["ClassID"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "") { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["ClassOrder"] != null && ds.Tables[0].Rows[0]["ClassOrder"].ToString() != "") { model.ClassOrder = int.Parse(ds.Tables[0].Rows[0]["ClassOrder"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cms.Model.NewsClass GetNewsClassModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ClassID,Title,ClassOrder from NewsClass "); strSql.Append(" where ClassID=@ClassID"); SqlParameter[] parameters = { new SqlParameter("@ClassID", SqlDbType.Int,4) }; parameters[0].Value = Id; Cms.Model.NewsClass model = new Cms.Model.NewsClass(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ClassID"] != null && ds.Tables[0].Rows[0]["ClassID"].ToString() != "") { model.ClassID = int.Parse(ds.Tables[0].Rows[0]["ClassID"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "") { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["ClassOrder"] != null && ds.Tables[0].Rows[0]["ClassOrder"].ToString() != "") { model.ClassOrder = int.Parse(ds.Tables[0].Rows[0]["ClassOrder"].ToString()); } return model; } else { return null; } }