/// <summary>
/// 根据分类Cid 分类ID返回字段数组
/// </summary>
/// <param name="Cid"></param>
/// <param name="Field"></param>
/// <returns></returns>
public string[] GetTableList(int Cid, string Field)
{
string[] TableLists = null;
string TableList = null;
string Mid = new ROYcms.Sys.BLL.ROYcms_Class_Model().CidGetP("Mid", "Cid=" + Cid);
if (Mid != null)
{
DataSet FieldDs = new ROYcms.Sys.BLL.ROYcms_Field().GetList("Rid=" + Mid);
if (FieldDs.Tables[0].Rows.Count > 0)
{
foreach (DataRow Dr in FieldDs.Tables[0].Rows)
{
string Name = Dr["Name"].ToString(); //字段名字
string NameC = Dr[Field].ToString(); //字段名字
if (!Name.Contains("_R")) //去除默认的字段进行表的创建
{
TableList += NameC + ",";
}
}
}
}
if (TableList != null)
{
TableList = TableList.Substring(0, TableList.Length - 1);
TableLists = TableList.Split(',');//列表数组
}
return(TableLists);
}
/// <summary>
/// 根据分类Cid 分类ID返回智能关联表的表名
/// </summary>
/// <param name="Cid"></param>
/// <returns></returns>
public string GetTableName(int Cid)
{
//得到表名
string TableName = null;
string Mid = new ROYcms.Sys.BLL.ROYcms_Class_Model().CidGetP("Mid", "Cid=" + Cid);//得到模型ID
if (new ROYcms.Sys.BLL.ROYcms_Model().GetModel(Convert.ToInt32(Mid)) != null)
{
TableName = new ROYcms.Sys.BLL.ROYcms_Model().GetModel(Convert.ToInt32(Mid)).TableName;
}
return(TableName);
}
/// <summary>
/// 删除一个菜单项
/// </summary>
/// <param name="ClassId"></param>
/// <returns></returns>
public bool DelByClassId(string ClassId)
{
//级联删除分类关联
ROYcms.Sys.BLL.ROYcms_Class_News ROYcms_Class_News_bll = new ROYcms.Sys.BLL.ROYcms_Class_News();
//删除
ROYcms_Class_News_bll.Delete(" class_id='" + ClassId + "'");
//级联删除新闻
ROYcms.Sys.BLL.ROYcms_news ROYcms_news_bll = new ROYcms.Sys.BLL.ROYcms_news();
ROYcms_news_bll.Delete(" classname=" + GetIdForClassId(ClassId));
//级联删除智能表单模型关联
ROYcms.Sys.BLL.ROYcms_Class_Model ROYcms_Class_Model_bll = new ROYcms.Sys.BLL.ROYcms_Class_Model();
ROYcms_Class_Model_bll.CidDelete(GetIdForClassId(ClassId));
bool err = dal.DelByClassId(ClassId);
return(err);
}
