private int addcata(long cid, string title, int parentid)
{
int calssid = 0;
int classLayer = 1; //栏目深度
string classList = "";
int sort = new Spread.BLL.Catalog().GetMaxSortID(parentid);
Spread.BLL.Catalog bll = new Spread.BLL.Catalog();
Spread.Model.Catalog model = new Spread.Model.Catalog();
model.CatalogID = cid;
model.Title = title;
model.ParentId = parentid;
model.ClassList = "";
model.ClassOrder = sort;
model.IsShow = true;
model.IsLock = false;
model.IsMenu = false;
//添加栏目
calssid = bll.Add(model);
//修改栏目的下属栏目ID列表
if (parentid > 0)
{
DataSet ds = bll.GetCatalogListByClassId(parentid);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
classList = dr["ClassList"].ToString().Trim() + calssid + ",";
classLayer = Convert.ToInt32(dr["ClassLayer"]) + 1;
}
}
else
{
classList = "," + calssid + ",";
classLayer = 1;
}
model.Id = calssid;
model.ClassList = classList;
model.ClassLayer = classLayer;
new Spread.BLL.Catalog().Update(model);
return calssid;
}
public int classId; //ID
protected void Page_Load(object sender, EventArgs e)
{
chkLoginLevel("editCatalog");
//取得栏目传参
if ( 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 Spread.Model.Catalog GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CatalogID,Title,ParentId,ClassList,ClassLayer,ClassOrder,IsShow,IsLock,IsMenu from [Catalog] ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = Id;
Spread.Model.Catalog model = new Spread.Model.Catalog();
DataSet ds = DbHelper.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());
}
if (ds.Tables[0].Rows[0]["CatalogID"].ToString() != "")
{
model.CatalogID = long.Parse(ds.Tables[0].Rows[0]["CatalogID"].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]["ClassOrder"].ToString() != "")
{
model.ClassOrder = int.Parse(ds.Tables[0].Rows[0]["ClassOrder"].ToString());
}
if (ds.Tables[0].Rows[0]["IsShow"].ToString() != "")
{
model.IsShow = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsShow"].ToString());
}
if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["IsMenu"].ToString() != "")
{
model.IsMenu = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsMenu"].ToString());
}
return model;
}
else
{
return null;
}
}