public List <article_categoryInfo> GetList(int Top, string strWhere, string filedOrder) { List <article_categoryInfo> list = new List <article_categoryInfo>(); try { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" * "); strSql.Append(" FROM article_category "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } if (filedOrder.Trim() != "") { strSql.Append(" order by " + filedOrder); } using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text)) { while (dr.Read()) { article_categoryInfo info = GetInfoByDr(dr); list.Add(info); } } return(list); } catch { } return(null); }
public article_categoryInfo GetModel(int id) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from article_category "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; article_categoryInfo info = new article_categoryInfo(); using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters)) { if (dr.Read()) { info = GetInfoByDr(dr); } } return(info); } catch { } return(null); }
public int Update(article_categoryInfo model, ref string resultMsg) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update article_category set "); strSql.Append(" img = @img , "); strSql.Append(" content = @content , "); strSql.Append(" seo_title = @seo_title , "); strSql.Append(" seo_keywords = @seo_keywords , "); strSql.Append(" seo_description = @seo_description , "); strSql.Append(" channel_id = @channel_id , "); strSql.Append(" title = @title , "); strSql.Append(" call_index = @call_index , "); strSql.Append(" parentid = @parentid , "); strSql.Append(" orderby = @orderby , "); strSql.Append(" link_url = @link_url, "); strSql.Append(" companyid = @companyid "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@img", SqlDbType.NVarChar, 255), new SqlParameter("@content", SqlDbType.Text), new SqlParameter("@seo_title", SqlDbType.NVarChar, 255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255), new SqlParameter("@seo_description", SqlDbType.NVarChar, 255), new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@call_index", SqlDbType.NVarChar, 50), new SqlParameter("@parentid", SqlDbType.Int, 4), new SqlParameter("@orderby", SqlDbType.Int, 4), new SqlParameter("@link_url", SqlDbType.NVarChar, 255), new SqlParameter("@companyid", SqlDbType.Int, 4), }; parameters[0].Value = model.id; parameters[1].Value = model.img; parameters[2].Value = model.content; parameters[3].Value = model.seo_title; parameters[4].Value = model.seo_keywords; parameters[5].Value = model.seo_description; parameters[6].Value = model.channel_id; parameters[7].Value = model.title; parameters[8].Value = model.call_index; parameters[9].Value = model.parentid; parameters[10].Value = model.orderby; parameters[11].Value = model.link_url; parameters[12].Value = model.companyid; int rows = SqlDbHelper.ExecuteNonQuery(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters); return(rows); } catch (Exception exc) { resultMsg = exc.Message; } return(0); }
public int Add(article_categoryInfo model, ref string resultMsg) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into article_category("); strSql.Append("img,content,seo_title,seo_keywords,seo_description,channel_id,title,call_index,parentid,orderby,link_url,companyid"); strSql.Append(") values ("); strSql.Append("@img,@content,@seo_title,@seo_keywords,@seo_description,@channel_id,@title,@call_index,@parentid,@orderby,@link_url,@companyid"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@img", SqlDbType.NVarChar, 255), new SqlParameter("@content", SqlDbType.Text), new SqlParameter("@seo_title", SqlDbType.NVarChar, 255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255), new SqlParameter("@seo_description", SqlDbType.NVarChar, 255), new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@call_index", SqlDbType.NVarChar, 50), new SqlParameter("@parentid", SqlDbType.Int, 4), new SqlParameter("@orderby", SqlDbType.Int, 4), new SqlParameter("@link_url", SqlDbType.NVarChar, 255), new SqlParameter("@companyid", SqlDbType.Int, 4), }; parameters[0].Value = model.img; parameters[1].Value = model.content; parameters[2].Value = model.seo_title; parameters[3].Value = model.seo_keywords; parameters[4].Value = model.seo_description; parameters[5].Value = model.channel_id; parameters[6].Value = model.title; parameters[7].Value = model.call_index; parameters[8].Value = model.parentid; parameters[9].Value = model.orderby; parameters[10].Value = model.link_url; parameters[11].Value = model.companyid; object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } } catch (Exception exc) { resultMsg = exc.Message; } return(0); }
private void bind() { ddlarticle_categorybind(); if (id > 0) { hfid.Value = id.ToString(); article_categoryInfo info = BLL.article_categoryBLL.GetModel(id); txbtitle.Text = info.title; txborderby.Text = info.orderby.ToString(); try { ddlarticle_category.SelectedValue = info.parentid.ToString(); } catch { } } else { txborderby.Text = "99"; } }
private article_categoryInfo GetInfoByDr(SqlDataReader dr) { article_categoryInfo info = new article_categoryInfo(); info.id = int.Parse(dr["id"] != DBNull.Value ? dr["id"].ToString() : "0"); info.img = dr["img"] != DBNull.Value ? dr["img"].ToString() : ""; info.content = dr["content"] != DBNull.Value ? dr["content"].ToString() : ""; info.seo_title = dr["seo_title"] != DBNull.Value ? dr["seo_title"].ToString() : ""; info.seo_keywords = dr["seo_keywords"] != DBNull.Value ? dr["seo_keywords"].ToString() : ""; info.seo_description = dr["seo_description"] != DBNull.Value ? dr["seo_description"].ToString() : ""; info.channel_id = int.Parse(dr["channel_id"] != DBNull.Value ? dr["channel_id"].ToString() : "0"); info.title = dr["title"] != DBNull.Value ? dr["title"].ToString() : ""; info.call_index = dr["call_index"] != DBNull.Value ? dr["call_index"].ToString() : ""; info.parentid = int.Parse(dr["parentid"] != DBNull.Value ? dr["parentid"].ToString() : ""); info.orderby = int.Parse(dr["orderby"] != DBNull.Value ? dr["orderby"].ToString() : "0"); info.link_url = dr["link_url"] != DBNull.Value ? dr["link_url"].ToString() : ""; info.companyid = int.Parse(dr["companyid"] != DBNull.Value ? dr["companyid"].ToString() : "0"); return(info); }
/// <summary> /// 树结构 /// </summary> /// <param name="dtNodeSets">菜单记录数据所在的表</param> /// <param name="strParentColumn">表中用于标记父记录的字段</param> /// <param name="strRootValue">第一层记录的父记录值(通常设计为0或者-1或者Null)用来表示没有父记录</param> /// <param name="strIndexColumn">索引字段,也就是放在DropDownList的Value里面的字段</param> /// <param name="strTextColumn">显示文本字段,也就是放在DropDownList的Text里面的字段</param> /// <param name="i">用来控制缩入量的值,请输入-1</param> public ArrayList MakeTreeList(DataTable dtNodeSets, string strParentColumn, string strRootValue, string strIndexColumn, string strTextColumn, int i) { //每向下一层,多一个缩入单位 i++; DataView dvNodeSets = new DataView(dtNodeSets); dvNodeSets.RowFilter = strParentColumn + "=" + strRootValue; string strPading = ""; //缩入字符 //通过i来控制缩入字符的长度,我这里设定的是一个全角的空格 for (int j = 0; j < i; j++) { strPading += " ";//如果要增加缩入的长度,改成两个全角的空格就可以了 } foreach (DataRowView drv in dvNodeSets) { article_categoryInfo info = new article_categoryInfo(); string title = drv[strTextColumn] != DBNull.Value ? drv[strTextColumn].ToString() : ""; if (i > 0) { title = strPading + " ├ " + (drv[strTextColumn] != DBNull.Value ? drv[strTextColumn].ToString() : ""); } info.id = drv["id"] != DBNull.Value ? Convert.ToInt32(drv["id"]) : 0; info.orderby = drv["orderby"] != DBNull.Value ? Convert.ToInt32(drv["orderby"]) : 0; info.title = title; info.parentid = drv["parentid"] != DBNull.Value ? Convert.ToInt32(drv["parentid"]) : 0; info.companyname = drv["companyname"] != DBNull.Value ? drv["companyname"].ToString() : ""; list.Add(info); MakeTreeList(dtNodeSets, strParentColumn, drv[strIndexColumn].ToString(), strIndexColumn, strTextColumn, i); } //递归结束,要回到上一层,所以缩入量减少一个单位 i--; return(list); }
/// <summary> /// 更新一条数据 /// </summary> public static int Update(article_categoryInfo model, ref string resultMsg) { return(dal.Update(model, ref resultMsg)); }
public static int Add(article_categoryInfo info, ref string resultMsg) { return(dal.Add(info, ref resultMsg)); }