/**********************************************************************************
* 程序說明： 生成靜態頁面類(復雜型.有參數)
* 創建日期： 2009.6.13
* 修改日期： 2010.12.18
* 程序制作： agui
* 聯系方式： mailto:354990393@QQ.com
* ********************************************************************************/
using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using PlugNT.Safe;
using PlugNT.Database.Common;
using PlugNT.Database.Common.Simple;
using PlugNT.Custom;
using PlugNT.Cms.Model; namespace PlugNT.Cms.DAL
{
/// <summary>
/// 無限極分類（由于字段的長度只能嵌套25層，且只能用于少量重要型的數據存儲）
/// </summary>
public class Category
{
PRivate static string currTableName = WebConfig.TablePrefix + "category";
#region 獲取
/// <summary>
/// 獲取clsno
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public string GetClsno(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 clsno from " + currTableName);
strSql.Append(" where id=" + id.ToString());
return Convert.ToString(DbHelper.GetSingle(strSql.ToString()));
} /// <summary>
/// 獲取clslist
/// </summary>
/// <param name="clsname"></param>
/// <returns></returns>
public string GetClslistByName(string clsname)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 clslist from " + currTableName);
strSql.Append(" where clsname='" + StringHelper.SqlFilter(clsname) + "'");
return Convert.ToString(DbHelper.GetSingle(strSql.ToString()));
} /// <summary>
/// 獲取clslist
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public string GetClslistByNo(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 clslist from " + currTableName);
strSql.Append(" where clsno='" + StringHelper.SqlFilter(clsno) + "'");
return Convert.ToString(DbHelper.GetSingle(strSql.ToString()));
} /// <summary>
/// 根據父級編號得到clsname
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public string GetClsnameByParentNo(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select top 1 clsname From " + currTableName);
strSql.Append(" Where clsparentno='" + StringHelper.SqlFilter(clsno) + "'");
return DbHelper.GetSingle(strSql.ToString()).ToString();
} /// <summary>
/// 得到父級clsno
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public string GetParentClsno(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select top 1 clsparentno From " + currTableName);
strSql.Append(" Where clsno='" + StringHelper.SqlFilter(clsno) + "'");
return DbHelper.GetSingle(strSql.ToString()).ToString();
} /// <summary>
/// 得到模型
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public CategoryInfo GetCategoryInfo(string clsno)
{
DataTable dt = GetCategoryTable(clsno);
CategoryInfo model=null;
if(dt.Rows.Count>0)
{
DataRow dr=dt.Rows[0];
model=new CategoryInfo();
model.id=(int)dr["id"];
model.clsno=dr["clsno"].ToString();
model.clsname=dr["clsname"].ToString();
model.clslist=dr["clslist"].ToString();
model.clsparentno=dr["clsparentno"].ToString();
model.clslistlen=Int32.Parse(dr["clslistlen"].ToString());
}
return model; } /// <summary>
/// 得到類別表
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public DataTable GetCategoryTable(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select top 1 * From " + currTableName);
strSql.Append(" Where clsno='" + StringHelper.SqlFilter(clsno) + "'");
DataTable dt = DbHelper.TabQuery(strSql.ToString());
return dt;
}
#endregion #region 添加，修改，刪除操作 /// <summary>
/// 添加一個菜單項
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(CategoryInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + currTableName);
strSql.Append(" (clsno,clsname,clslist,clsparentno,clslistlen)"); strSql.Append(" values (");
strSql.Append("'" + StringHelper.SqlFilter(model.clsno) + "',");
strSql.Append("'" + StringHelper.SqlFilter(model.clsname) + "',");
strSql.Append("'" + StringHelper.SqlFilter(model.clslist) + "',");
strSql.Append("'" + StringHelper.SqlFilter(model.clsparentno) + "',");
strSql.Append(" " +model.clslistlen ); strSql.Append(")"); return (DbHelper.ExecuteSql(strSql.ToString()) > 0) ? true : false;
} /// <summary>
/// 編輯一個菜單項
/// </summary>
/// <param name="model"></param>
/// <param name="isSubModel">是否下級菜單</param>
/// <returns></returns>
public bool Update(CategoryInfo model, bool isSubModel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + currTableName);
strSql.Append(" set ");
if (!isSubModel)
{
strSql.Append("clsname='" + StringHelper.SqlFilter(model.clsname) + "',");
strSql.Append("clsparentno='" + StringHelper.SqlFilter(model.clsparentno) + "',");
}
strSql.Append("clslist='" + StringHelper.SqlFilter(model.clslist) + "',");
strSql.Append("clslistlen=" + model.clslistlen );
strSql.Append(" where clsno='" + StringHelper.SqlFilter(model.clsno) + "' "); //同步更新子菜單項
DataTable dt = GetOrderSubList(model.clsno);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
CategoryInfo imodel = new CategoryInfo();
string Subclslist = model.clslist + dr["clsno"].ToString().Trim() + ",";
imodel.clslist = Subclslist;
imodel.clslistlen = model.clslistlen + 1;
Update(imodel,true);
}
}
return (DbHelper.ExecuteSql(strSql.ToString()) > 0) ? true : false;
} /// <summary>
/// 刪除菜單項
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public bool Delete(string clsno)
{
StringBuilder strSql = new StringBuilder();
DataTable dt = GetListRow(clsno);
if (dt.Rows.Count > 0)
{
strSql.Append("Delete From " + currTableName);
strSql.Append(" where clslist like '" + dt.Rows[0]["clslist"].ToString().Trim() + "%'");
}
return (DbHelper.ExecuteSql(strSql.ToString()) > 0) ? true : false;
}
#endregion
#region 獲取列表 /// <summary>
/// 判斷一個父類編號是否存在
/// </summary>
public bool ParentExists(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + currTableName);
strSql.Append(" where clsparentno='" + StringHelper.SqlFilter(clsno) + "'");
return DbHelper.Exists(strSql.ToString());
} /// <summary>
/// 獲取全部菜單名及列表
/// </summary>
/// <returns></returns>
public DataTable GetList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,clsno,clsname,clslist,clsparentno,clslistlen from " + currTableName);
return DbHelper.TabQuery(strSql.ToString());
//clsno,clsname,clslist,clslistlen,indexfile,listfile,showfile,createpath,ismap
} /// <summary>
/// 獲取菜單列表(排序)
/// </summary>
/// <returns></returns>
public DataTable GetOrderList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,clsno,clsname,clslist,clsparentno,clslistlen from " + currTableName);
strSql.Append(" Order By clslist Asc"); // Order By clsorder Asc,clslist Asc
return DbHelper.TabQuery(strSql.ToString());
} /// <summary>
/// 獲取clsno的包含菜單列表
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public DataTable GetListRow(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 clsno,clslist,clslistlen from " + currTableName);
strSql.Append(" where clsno='" + StringHelper.SqlFilter(clsno) + "' ");
return DbHelper.TabQuery(strSql.ToString());
} /// <summary>
/// 獲取該菜單項的所有子菜單項(因為clslist在表中都不同所以按clsorder排序無效果)
/// </summary>
/// <param name="clsno"></param>
/// <returns></returns>
public DataTable GetOrderSubList(string clsno)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,clsno,clsname,clslist,clsparentno,clslistlen from " + currTableName);
strSql.Append(" where clsparentno='" + StringHelper.SqlFilter(clsno) + "' ");
strSql.Append(" Order By clslist Asc");
return DbHelper.TabQuery(strSql.ToString());
} #endregion #region contact me
public string Help()
{
return @"mailto:354990393@qq.com";
}
#endregion
} } | 
