/// <summary> /// 更新一条数据 /// </summary> public void Update(DtCms.Model.Channel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Channel set "); strSql.Append("Title=@Title,"); strSql.Append("ParentId=@ParentId,"); strSql.Append("ClassList=@ClassList,"); strSql.Append("ClassLayer=@ClassLayer,"); strSql.Append("ClassOrder=@ClassOrder,"); strSql.Append("PageUrl=@PageUrl,"); strSql.Append("KindId=@KindId"); strSql.Append(" where Id=@Id "); OleDbParameter[] parameters = { new OleDbParameter("@Title", OleDbType.VarWChar, 50), new OleDbParameter("@ParentId", OleDbType.Integer, 4), new OleDbParameter("@ClassList", OleDbType.VarWChar, 300), new OleDbParameter("@ClassLayer", OleDbType.Integer, 4), new OleDbParameter("@ClassOrder", OleDbType.Integer, 4), new OleDbParameter("@PageUrl", OleDbType.VarWChar, 250), new OleDbParameter("@KindId", OleDbType.Integer, 4), new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.ParentId; parameters[2].Value = model.ClassList; parameters[3].Value = model.ClassLayer; parameters[4].Value = model.ClassOrder; parameters[5].Value = model.PageUrl; parameters[6].Value = model.KindId; parameters[7].Value = model.Id; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DtCms.Model.Channel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Channel("); strSql.Append("Title,ParentId,ClassList,ClassLayer,ClassOrder,PageUrl,KindId)"); strSql.Append(" values ("); strSql.Append("@Title,@ParentId,@ClassList,@ClassLayer,@ClassOrder,@PageUrl,@KindId)"); OleDbParameter[] parameters = { new OleDbParameter("@Title", OleDbType.VarWChar, 50), new OleDbParameter("@ParentId", OleDbType.Integer, 4), new OleDbParameter("@ClassList", OleDbType.VarWChar, 300), new OleDbParameter("@ClassLayer", OleDbType.Integer, 4), new OleDbParameter("@ClassOrder", OleDbType.Integer, 4), new OleDbParameter("@PageUrl", OleDbType.VarWChar, 250), new OleDbParameter("@KindId", OleDbType.Integer, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.ParentId; parameters[2].Value = model.ClassList; parameters[3].Value = model.ClassLayer; parameters[4].Value = model.ClassOrder; parameters[5].Value = model.PageUrl; parameters[6].Value = model.KindId; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 返回栏目名称 /// </summary> protected string GetChannel_Title(int _classId) { DtCms.BLL.Channel bll = new DtCms.BLL.Channel(); if (bll.Exists(_classId)) { DtCms.Model.Channel model = bll.GetModel(_classId); return(model.Title); } return(""); }
//输出栏目名称 public static string ViewChannelTitle(int classId) { DtCms.BLL.Channel bll = new DtCms.BLL.Channel(); if (bll.Exists(classId)) { DtCms.Model.Channel model = bll.GetModel(classId); return(model.Title); } return("所有列表"); }
/// <summary> /// 得到一个对象实体 /// </summary> public DtCms.Model.Channel GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Title,ParentId,ClassList,ClassLayer,SortId,PageUrl,KindId from dt_Channel "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DtCms.Model.Channel model = new DtCms.Model.Channel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } model.ClassList = ds.Tables[0].Rows[0]["ClassList"].ToString(); if (ds.Tables[0].Rows[0]["ClassLayer"].ToString() != "") { model.ClassLayer = int.Parse(ds.Tables[0].Rows[0]["ClassLayer"].ToString()); } if (ds.Tables[0].Rows[0]["SortId"].ToString() != "") { model.SortId = int.Parse(ds.Tables[0].Rows[0]["SortId"].ToString()); } model.PageUrl = ds.Tables[0].Rows[0]["PageUrl"].ToString(); if (ds.Tables[0].Rows[0]["KindId"].ToString() != "") { model.KindId = int.Parse(ds.Tables[0].Rows[0]["KindId"].ToString()); } return(model); } else { return(null); } }
public int classId; //ID protected void Page_Load(object sender, EventArgs e) { chkLoginLevel("editChannel"); //取得栏目传参 if (int.TryParse(Request.Params["kindId"], out kindId) && int.TryParse(Request.Params["classId"], out classId)) { model = bll.GetModel(classId); if (!Page.IsPostBack) { ShowInfo(); } } else { JscriptMsg(350, 230, "错误提示", "<b>出现错误啦!</b>您要修改类别的种类不明确或参数不正确。", "back", "Error"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Channel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_Channel set "); strSql.Append("Title=@Title,"); strSql.Append("ParentId=@ParentId,"); strSql.Append("ClassList=@ClassList,"); strSql.Append("ClassLayer=@ClassLayer,"); strSql.Append("SortId=@SortId,"); strSql.Append("PageUrl=@PageUrl,"); strSql.Append("KindId=@KindId"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@ClassList", SqlDbType.NVarChar, 500), new SqlParameter("@ClassLayer", SqlDbType.Int, 4), new SqlParameter("@SortId", SqlDbType.Int, 4), new SqlParameter("@PageUrl", SqlDbType.NVarChar, 250), new SqlParameter("@KindId", SqlDbType.Int, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.Title; parameters[2].Value = model.ParentId; parameters[3].Value = model.ClassList; parameters[4].Value = model.ClassLayer; parameters[5].Value = model.SortId; parameters[6].Value = model.PageUrl; parameters[7].Value = model.KindId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Channel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_Channel("); strSql.Append("Title,ParentId,ClassList,ClassLayer,SortId,PageUrl,KindId)"); strSql.Append(" values ("); strSql.Append("@Title,@ParentId,@ClassList,@ClassLayer,@SortId,@PageUrl,@KindId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@ClassList", SqlDbType.NVarChar, 500), new SqlParameter("@ClassLayer", SqlDbType.Int, 4), new SqlParameter("@SortId", SqlDbType.Int, 4), new SqlParameter("@PageUrl", SqlDbType.NVarChar, 250), new SqlParameter("@KindId", SqlDbType.Int, 4) }; parameters[0].Value = model.Title; parameters[1].Value = model.ParentId; parameters[2].Value = model.ClassList; parameters[3].Value = model.ClassLayer; parameters[4].Value = model.SortId; parameters[5].Value = model.PageUrl; parameters[6].Value = model.KindId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DtCms.Model.Channel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DtCms.Model.Channel model) { return(dal.Add(model)); }