/// <summary>
/// DDLs the menu_bind.
/// </summary>
void DdlMenu_bind()
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(this.ClassKind);
this.DdlMenu.Items.Clear();
this.DdlMenu.Items.Add(new ListItem("请选择所属分类", ""));
foreach (DataRow dr in ds.Tables[0].Rows)
{
int ClassTj = Convert.ToInt32(dr["ClassTj"]);
string Id = dr["ClassId"].ToString().Trim();
string ClassName = dr["ClassName"].ToString().Trim();
if (ClassTj == 1)
{
this.DdlMenu.Items.Add(new ListItem(ClassName, Id));
}
else
{
ClassName = "├ " + ClassName;
ClassName = ROYcms.Common.StringPlus.StringOfChar(ClassTj - 1, " ") + ClassName;
this.DdlMenu.Items.Add(new System.Web.UI.WebControls.ListItem(ClassName, Id));
}
}
}
/// <summary>
/// 地址
/// </summary>
/// <value>The id.</value>
//public string Path
//{
// get
// {
// if (_Path!= null)
// {
// if (Page.Request["path"] != null)
// {
// _Path = _Path.Replace("{path}".ToLowerInvariant(), Page.Request["path"]);
// }
// }
// return _Path;
// }
// set { _Path= value; }
//}
/// <summary>
/// 输出
/// </summary>
/// <param name="output">The output.</param>
protected override void Render(HtmlTextWriter output)
{
ROYcms.Sys.BLL.ROYcms_class ___ROYcms_class = new ROYcms.Sys.BLL.ROYcms_class();
try
{
output.Write((___ROYcms_class.GetClassField(Convert.ToInt32(Rid), Name)).Replace("{cmspath}/", "/"));
}
catch { output.Write("<!--输出错误！-->"); }
//if (Path == null)
//{
// try
// {
// output.Write((___ROYcms_class.GetClassField(Convert.ToInt32(Rid), Name)).Replace("{cmspath}/", "/"));
// }
// catch { output.Write("<!--输出错误！-->"); }
//}
//else
//{
// try
// {
// output.Write(___ROYcms_class.GetClassField(Convert.ToInt32(___ROYcms_class.GetId("{cmspath}/" + Path + "/")), Name).Replace("{cmspath}/", "/"));
// }
// catch { output.Write("<!--输出错误！-->"); }
//}
}
/// <summary>
/// 静态生成所有频道
/// </summary>
/// <returns></returns>
public static string StaticAllChannel()
{
int s = 0; //成功生成个数
int e = 0; //失败生成个数
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList();
if (ds == null)
{
return("无频道");
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
bool t1, t2 = false;
t1 = StaticHtmlDate.StaticChannel(Convert.ToInt32(dr["Id"]));
t2 = StaticHtmlDate.StaticChannelList(Convert.ToInt32(dr["Id"]), 10);
if (t1 && t2)
{
s++;
}
else
{
e++;
}
}
return(" 成功生成所有频道[" + s.ToString() + "]个失败[" + e.ToString() + "]个！ ");
}
/// <summary>
/// 列表顺序保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSave_Click(object sender, EventArgs e)
{
int UpSum = 0;
bool ReVal = true;
foreach (RepeaterItem RptItem in this.rptMenuList.Items)
{
HiddenField txtClassId = (HiddenField)RptItem.FindControl("txtClassId");
TextBox txtOrder = (TextBox)RptItem.FindControl("txtOrder");
try
{
ReVal = new ROYcms.Sys.BLL.ROYcms_class().UpdateClassOrder(txtClassId.Value.Trim(), Convert.ToInt32(txtOrder.Text));
}
catch
{
ReVal = false;
ROYcms.Common.SystemCms.InsertErrLog("列表操作排序错误！", Request.PhysicalPath);
}
if (ReVal == false)
{
++UpSum;
}
}
if (UpSum == 0)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ajaxjs", "alert('所有设定的栏目顺序都已保存成功！')", true);
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ajaxjs", string.Format("alert('栏目顺序部份保存成功,共有{0}条记录保存失败!')", UpSum), true);
}
BindData();
}
/// <summary>
/// Dels the HTML.
/// </summary>
/// <param name="Model">The model.</param>
/// <returns></returns>
public void DelHtml(int id)
{
try
{
ROYcms.Sys.BLL.ROYcms_news BLL = new ROYcms.Sys.BLL.ROYcms_news();
ROYcms.Sys.BLL.ROYcms_class ClassBLL = new ROYcms.Sys.BLL.ROYcms_class();
ROYcms.Sys.Model.ROYcms_class Model = ClassBLL.GetModel(ClassBLL.GetClassId(Convert.ToInt32(BLL.GetClassName(id))));
ROYcms.Sys.Model.ROYcms_news NewModel = BLL.GetModel(id);
string Path = null;
Model.FilePath = Model.FilePath.Replace("{cmspath}", "~");
Path = (Model.ShowRules.Contains("~/") ? Model.ShowRules : (Model.FilePath + Model.ShowRules)); //文件生成地址
Path = Path.Replace("{yyyy}", Convert.ToDateTime(NewModel.time).ToString("yyyy"));
Path = Path.Replace("{MM}", Convert.ToDateTime(NewModel.time).ToString("MM"));
Path = Path.Replace("{dd}", Convert.ToDateTime(NewModel.time).ToString("dd"));
Path = Path.Replace("{id}", id.ToString());
using (StreamWriter sw = new StreamWriter(HttpContext.Current.Server.MapPath(Path), false, Encoding.GetEncoding(ROYcms.Config.ROYcmsConfig.GetCmsConfigValue("templet_language"))))
{
// File.Delete(HttpContext.Current.Server.MapPath(Path));
sw.WriteLine("文件已经删除！<a href='/inde.aspx'>到首页</a>");
sw.Flush();
}
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
}
}
/// <summary>
/// XML help?
/// </summary>
public string GetUrl(string Id)
{
string Url = null;
ROYcms.Sys.BLL.ROYcms_class ___ROYcms_class = new ROYcms.Sys.BLL.ROYcms_class();
ROYcms.Sys.BLL.ROYcms_news ___ROYcms_news = new ROYcms.Sys.BLL.ROYcms_news();
ROYcms.Sys.BLL.ROYcms_Url ___ROYcms_Url = new ROYcms.Sys.BLL.ROYcms_Url();
int ClassId = Convert.ToInt32(___ROYcms_news.GetField(Convert.ToInt32(Id), "classname"));
string ShowRules = ___ROYcms_class.GetClassField(ClassId, "ShowRules");
string jumpurl = ___ROYcms_news.GetField(Convert.ToInt32(Id), "jumpurl").Trim();
ShowRules = ShowRules.Replace("{id}", Id).Replace("{yyyy}/{MM}/{dd}/", "show_");
if (jumpurl.Length > 2)
{
Url = jumpurl;
}
else
{
if (___ROYcms_Url.Exists_bh(Convert.ToInt32(Id)))
{
Url = ___ROYcms_Url.GetUrl(Convert.ToInt32(Id));
}
else
{
Url = (___ROYcms_class.GetClassField(ClassId, "FilePath").Replace("{cmspath}/", "/")) + ShowRules;
}
}
return(Url);
}
/// <summary>
/// BindData
/// </summary>
private void BindData()
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(this.ClassKind);
this.rptMenuList.DataSource = ds.Tables[0].DefaultView;
this.rptMenuList.DataBind();
}
protected override void OnDataBinding(EventArgs e)
{
ROYcms.Sys.BLL.ROYcms_class ___ROYcms_class = new ROYcms.Sys.BLL.ROYcms_class();
if (ClassKind != null)
{
if (Div != 00)
{
dataSource = (IList)(new DataView(((DataSet)(___ROYcms_class.GetClassList(Convert.ToInt32(ClassKind), Div))).Tables[0]));
}
else
{
dataSource = (IList)(new DataView(((DataSet)(___ROYcms_class.GetClassList(Convert.ToInt32(ClassKind)))).Tables[0]));
}
}
if (Class != null)
{
dataSource = (IList)(new DataView(((DataSet)(___ROYcms_class.GetSubClassList(___ROYcms_class.GetClassId(Convert.ToInt32(Class))))).Tables[0]));
}
if (Path != null)
{
dataSource = (IList)(new DataView(((DataSet)(___ROYcms_class.GetSubClassList(___ROYcms_class.GetClassId(Convert.ToInt32(___ROYcms_class.GetId("{cmspath}/" + Path + "/")))))).Tables[0]));
}
//if (base.DataSource != null)
//{
intItemCount = dataSource.Count;
base.DataSource = dataSource;
base.OnDataBinding(e);
//}
}
/// <summary>
/// 目录和分页重写方法
/// </summary>
/// <param name="URL"></param>
/// <returns></returns>
public static string IsIndexUrl(string URL, string SERVER)
{
ROYcms.Sys.BLL.ROYcms_class ClassBll = new ROYcms.Sys.BLL.ROYcms_class();
string SQL_where = null;
//判断是主域名
if (("http://" + SERVER + "/").ToLowerInvariant() != ROYcms.Config.ROYcmsConfig.GetCmsConfigValue("web_host").ToLowerInvariant())
{
SQL_where = "FilePath ='" + FormatUrl(URL)[0] + "' and DefaultFile='" + FormatUrl(URL)[1] + "' and WebsiteUrl='" + SERVER.ToLowerInvariant() + "' ";
}
else
{
SQL_where = "FilePath ='" + FormatUrl(URL)[0] + "' and DefaultFile='" + FormatUrl(URL)[1] + "' and WebsiteUrl='' ";
}
string TemplateIndex = ClassBll.GetClassField(SQL_where, "TemplateIndex");
if (TemplateIndex != null)
{
return(TemplateIndex + "?class=" + ClassBll.GetClassField(SQL_where, "id"));
}
else
{
return(null);
}
}
/// <summary>
/// 菜单绑定
/// </summary>
void DdClass_bind()
{
this.goods_type.Items.Clear();
this.goods_type.Items.Add(new System.Web.UI.WebControls.ListItem("选择分类", "0"));
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(888888888);
foreach (DataRow dr in ds.Tables[0].Rows)
{
int ClassTj = Convert.ToInt32(dr["ClassTj"]);
string ClassId = dr["Id"].ToString().Trim();
string ClassName = dr["ClassName"].ToString().Trim() + "[ID:" + dr["Id"].ToString() + "]";
if (ClassTj == 1)
{
this.goods_type.Items.Add(new ListItem(ClassName, ClassId));
}
else
{
ClassName = "├ " + ClassName;
ClassName = ROYcms.Common.StringPlus.StringOfChar(ClassTj - 1, " ") + ClassName;
this.goods_type.Items.Add(new System.Web.UI.WebControls.ListItem(ClassName, ClassId));
}
}
}
///// <summary>
///// loop标签的匹配替换
///// </summary>
///// <param name="template">模板内容</param>
public string LoopClass(string template)
{
string Attributes = "";
string Text = "";
string AllText = "";
Regex r = new Regex(@"(\[SG:class\s+(?<attributes>[^\]]*?)\](?<text>[\s\S]*?)\[/SG:class\])", RegexOptions.Compiled | RegexOptions.IgnoreCase);
foreach (Match m in r.Matches(template))
{
Attributes = m.Groups["attributes"].ToString(); //循环属性集
Text = m.Groups["text"].ToString(); //循环的内容不包含SG:Loop
AllText = m.Groups[0].Value.ToString(); //整个匹配的内容包含SG:Loop
#region 取得相关属性
string Count = null; //调用数量
string classID = null;
string Templet = null; // 模板ID
Templet = TagVal(Attributes, "Templet");
Count = TagVal(Attributes, "Count");
classID = TagVal(Attributes, "classID");
#endregion
#region 对循环的内容进行替换
string content = "";
ROYcms.Sys.BLL.ROYcms_class bll = new ROYcms.Sys.BLL.ROYcms_class();
DataSet dt = bll.GetClassList(0);
if (classID != null)
{
dt = bll.GetSubClassList(bll.GetClassId(Convert.ToInt32(classID)));
}
if (dt.Tables[0].Rows.Count > 0)
{
int rowsCount = dt.Tables[0].Rows.Count;
if (Count != null && rowsCount > Convert.ToInt32(Count))
{
rowsCount = Convert.ToInt32(Count);
}
for (int n = 0; n < rowsCount; n++)
{
string str = Text;
str = Replace(str, @"\[SG:ClassName\]", dt.Tables[0].Rows[n]["ClassName"].ToString());
str = Replace(str, @"\[SG:Link\]", config.web_host + TemplateZone.Zpath(this.pageHost) + "list" + Templet + "-" + dt.Tables[0].Rows[n]["Id"].ToString() + config.web_forge);
str = Replace(str, @"\[SG:_Link\]", "list-" + dt.Tables[0].Rows[n]["Id"].ToString() + config.web_forge);
content += str;
}
}
else
{
content = "";
}
#endregion
template = template.Replace(AllText, content);
}
return(template);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
int ClassKind = this.ClassKind; //上一级目录
string ClassId = ROYcms.Common.StringPlus.GetRamCode(); //栏目ID
string ClassName = this.txtClassName.Text.Trim(); //栏目名称
string ClassList = ""; //栏目包含列表
string ClassPre = Request["ClassId"] == null ? "0" : Request["ClassId"].Trim(); //上一级目录
int ClassTj = 1; //栏目深度
if (ClassPre == "0")
{
ClassList = ClassId + ",";
ClassTj = 1;
}
else
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassListByClassId(ClassPre);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
ClassList = dr["ClassList"].ToString().Trim() + ClassId + ",";
ClassTj = Convert.ToInt32(dr["ClassTj"]) + 1;
}
}
model.ClassId = ClassId;
model.ClassName = ROYcms.Common.input.Htmls(ClassName);
model.ClassList = ROYcms.Common.input.Htmls(ClassList);
model.ClassPre = ClassPre;
model.ClassTj = ClassTj;
model.ClassKind = ClassKind;
model.ClassOrder = 0;
model.ListType = 0;
model.GoType = 0;
if (txtDefaultFile.Text != null)
{
model.DefaultFile = txtDefaultFile.Text.Trim();
}
model.FilePath = txtFilePath.Text;
model.ColumnsType = Convert.ToInt32(txtColumnsType.SelectedValue);
model.WebsiteUrl = txtWebsiteUrl.Text;
model.TemplateIndex = txtTemplateIndex.Text;
model.TemplateList = txtTemplateList.Text;
model.TemplateShow = txtTemplateShow.Text;
model.ListeRules = txtListeRules.Text;
model.ShowRules = txtShowRules.Text;
model.keyword = txtkeyword.Text;
model.Description = txtDescription.Text;;
model.contents = Request["content"];
new ROYcms.Sys.BLL.ROYcms_class().ClassAdd(model);
this.txtClassName.Text = "";
ROYcms.Common.MessageBox.Show(this, "添加栏目成功！");
}
/// <summary>
/// DDLs the menu_bind.
/// </summary>
public string Trees()
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(10);
string Text = null;
int Div = 1; //当前层
foreach (DataRow dr in ds.Tables[0].Rows)
{
int ClassTj = Convert.ToInt32(dr["ClassTj"]); //层次
string Id = dr["Id"].ToString().Trim(); //标识
string ClassKind = dr["ClassKind"].ToString().Trim(); //标识
string ClassId = dr["ClassId"].ToString().Trim(); //标识
string ClassName = dr["ClassName"].ToString().Trim(); //名称
string href = "/administrator/objet/send.aspx?classkind=" + ClassKind + "&class=" + Id; //地址
bool issub = false;
//判断是否有子类开始
DataSet DS = new ROYcms.Sys.BLL.ROYcms_class().GetSubClassList(ClassId);
DataTable dt = DS.Tables[0];
//遍历行
if (dt.Rows.Count > 0)
{
issub = true;
}
//判断是否有子类结束
if (issub)
{
Text += "{href:'" + href + "',id:'" + Id + "',text:'" + ClassName + "',hrefTarget:'_blank',cls:'folder',checked:false, children:[";
}
else
{
if (ClassTj < Div)//上一层和当前层深度和层级相同
{
Text += "]},";
Text += "{href:'" + href + "',id:'" + Id + "',text:'" + ClassName + "',hrefTarget:'_blank',cls:'folder',leaf:true,checked:false},";
}
else
{
Text += "{href:'" + href + "',id:'" + Id + "',text:'" + ClassName + "',hrefTarget:'_blank',cls:'folder',leaf:true,checked:false},";
}
}
Div = ClassTj; //当前层
}
//去除尾部,
Text = Text.Replace("},]}", "}]}");
Text = Text.Substring(0, Text.Length - 1);
return(Text);
}
/// <summary>
/// DDLs the menu_bind.
/// </summary>
public string Trees()
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(10);
string Text = null;
int Div = 1; //当前层
foreach (DataRow dr in ds.Tables[0].Rows)
{
int ClassTj = Convert.ToInt32(dr["ClassTj"]); //层次
string Id = dr["ClassId"].ToString().Trim(); //标识
string ClassName = dr["ClassName"].ToString().Trim(); //名称
bool issub = false;
//判断是否有子类开始
DataSet DS = new ROYcms.Sys.BLL.ROYcms_class().GetSubClassList(Id);
DataTable dt = DS.Tables[0];
//遍历行
if (dt.Rows.Count > 0)
{
issub = true;
}
//判断是否有子类结束
if (issub)
{
Text += "{id:\"" + Id + "\",text:\"" + ClassName + "\",cls1:\"r_t\",cls2:\"r_t\",items:[";
}
else
{
if (ClassTj < Div)//上一层和当前层深度和层级相同
{
Text += "]},";
Text += "{id:\"" + Id + "\",text:\"" + ClassName + "\"},";
}
else
{
Text += "{id:\"" + Id + "\",text:\"" + ClassName + "\"},";
}
}
Div = ClassTj; //当前层
}
//去除尾部,
Text = Text.Replace("},]}", "}]}");
Text = Text.Substring(0, Text.Length - 1);
return(Text);
}
/// <summary>
/// Xs the class_bind.
/// </summary>
/// <param name="classid">The classid.</param>
void XClass_bind(string classid)
{
DataSet ds = new DataSet();
if (classid != "")
{
ds = new ROYcms.Sys.BLL.ROYcms_class().GetSubClassList(classid);
}
else
{
ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassList(this.ClassKind);
}
this.Repeater_XClass.DataSource = ds;
this.Repeater_XClass.DataBind();
}
/// <summary>
/// 生成所有栏目 News all HTML.
/// </summary>
/// <returns></returns>
public bool NewAllHtml(int?ClassKind)
{
ROYcms.Sys.BLL.ROYcms_class BLL = new ROYcms.Sys.BLL.ROYcms_class();
ROYcms.Sys.Model.ROYcms_class Model = new ROYcms.Sys.Model.ROYcms_class();
DataSet ds = new DataSet();
ds = BLL.GetClassList(Convert.ToInt32(ClassKind));
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Model = BLL.GetModel(dr["ClassId"].ToString());
NewHtml(Model);
err = true;
}
return(err);
}
/// <summary>
/// 文章详细页面重写
/// </summary>
/// <param name="URL"></param>
/// <returns></returns>
public static string IsShowUrl(string URL)
{
ROYcms.Sys.BLL.ROYcms_news NewBll = new ROYcms.Sys.BLL.ROYcms_news();
ROYcms.Sys.BLL.ROYcms_class ClassBll = new ROYcms.Sys.BLL.ROYcms_class();
string NewUrlModel = ROYcms.Config.ROYcmsConfig.GetCmsConfigValue("new_url_model");
if (NewUrlModel == "" || NewUrlModel == null)
{
NewUrlModel = "show";
}
if (URL.Contains("/" + NewUrlModel + "_"))
{
string[] Parameters = URL.Substring(URL.LastIndexOf("/" + NewUrlModel + "_") + 6, URL.LastIndexOf(".") - (URL.LastIndexOf("/" + NewUrlModel + "_") + 6)).Split('_');
string ClassId = Convert.ToString(NewBll.GetClassName(Convert.ToInt32(Parameters[0])));
string NewPath = ClassBll.GetClassField(Convert.ToInt32(ClassId), "TemplateShow");;
if (NewPath != "")
{
if (Parameters.Length > 1)
{
NewPath = NewPath + String.Format("?id={0}&class={1}&page={2}", Parameters[0], ClassId, Parameters[1]);
}
else
{
NewPath = NewPath + String.Format("?id={0}&class={1}", Parameters[0], ClassId);
}
return(NewPath);
}
else
{
return(null);
}
}
else
{
return(URL);
}
}
/// <summary>
/// Handles the Click event of the Button_add control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void Button_add_Click(object sender, EventArgs e)
{
string Class = "";
for (int i = 0; i < Repeater_XClass.Items.Count; i++)
{
int id = Convert.ToInt32(((Label)Repeater_XClass.Items[i].FindControl("Label_id")).Text);
CheckBox CK = (CheckBox)Repeater_XClass.Items[i].FindControl("ID_list");
if (CK.Checked)
{
Class += "," + id;
}
}
//当筛选到最后一一级分类的时候
if (Repeater_XClass.Items.Count < 1)
{
if (DdlMenu.SelectedValue != "")
{
ROYcms.Sys.Model.ROYcms_class Model = new ROYcms.Sys.BLL.ROYcms_class().GetModel(DdlMenu.SelectedValue);
Class = "," + Model.Id;
}
else
{
ROYcms.Common.MessageBox.Show(this, "没有分类请创建分类！");
}
}
//什么也没有选择
if (Class != "")
{
Class = Class.Substring(1, Class.Length - 1);
Response.Redirect("Insert.aspx?ClassKind=" + this.ClassKind + "&Class=" + Class);
}
else
{
ROYcms.Common.MessageBox.Show(this, "请在需要发布到的分类上打钩！");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ROYcms.Sys.Model.ROYcms_product model)
{
//
//级联更新 删除以前的分类关联 新建一个分类关联
//
ROYcms.Sys.BLL.ROYcms_Class_News ROYcms_Class_product_bll = new ROYcms.Sys.BLL.ROYcms_Class_News();
ROYcms.Sys.Model.ROYcms_Class_News ROYcms_Class_product_model = new ROYcms.Sys.Model.ROYcms_Class_News();
ROYcms.Sys.BLL.ROYcms_class ROYcms_Class_bll = new ROYcms.Sys.BLL.ROYcms_class();
ROYcms.Sys.Model.ROYcms_class ROYcms_Class_model = ROYcms_Class_bll._GetModel(model.classname.ToString());
//删除
ROYcms_Class_product_bll.Delete(" (news_id=" + model.bh + ") AND (Class=" + GetClassName(model.bh) + ") ");
//添加
ROYcms_Class_product_model.news_id = model.bh;
ROYcms_Class_product_model.Class = Convert.ToInt32(model.classname);
ROYcms_Class_product_model.class_id = ROYcms_Class_model.ClassId;
ROYcms_Class_product_model.class_list = ROYcms_Class_model.ClassList;
ROYcms_Class_product_model.Time = DateTime.Now;
ROYcms_Class_product_model.GUID = model.GUID;
ROYcms_Class_product_bll.Add(ROYcms_Class_product_model);
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ROYcms.Sys.Model.ROYcms_product model)
{
int news_id = dal.Add(model);
//
//级联添加
//
if (news_id != 1)
{
ROYcms.Sys.BLL.ROYcms_Class_News ROYcms_Class_product_bll = new ROYcms.Sys.BLL.ROYcms_Class_News();
ROYcms.Sys.Model.ROYcms_Class_News ROYcms_Class_product_model = new ROYcms.Sys.Model.ROYcms_Class_News();
ROYcms.Sys.BLL.ROYcms_class ROYcms_Class_bll = new ROYcms.Sys.BLL.ROYcms_class();
ROYcms.Sys.Model.ROYcms_class ROYcms_Class_model = ROYcms_Class_bll._GetModel(model.classname.ToString());
ROYcms_Class_product_model.news_id = news_id;
ROYcms_Class_product_model.Class = Convert.ToInt32(model.classname);
ROYcms_Class_product_model.class_id = ROYcms_Class_model.ClassId;
ROYcms_Class_product_model.class_list = ROYcms_Class_model.ClassList;
ROYcms_Class_product_model.Time = DateTime.Now;
ROYcms_Class_product_model.GUID = model.GUID;
ROYcms_Class_product_bll.Add(ROYcms_Class_product_model);
}
return(news_id);
}
public string ClassWheres()
{
string Strs = null;
ROYcms.Sys.BLL.ROYcms_class Bll = new ROYcms.Sys.BLL.ROYcms_class();
DataSet DS = Bll.GetSubClassList(Bll.GetClassId(Convert.ToInt32(this.Class)));
DataTable dt = DS.Tables[0];
//遍历行
if (dt.Rows.Count < 1)
{
Strs = this.Class + ",";
}
else
{
foreach (DataRow dr in dt.Rows)
{
Strs += dr["Id"].ToString() + ",";
}
}
Strs = Strs.Substring(0, Strs.Length - 1);
return(Strs);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnEdit_Click(object sender, EventArgs e)
{
int Id = Convert.ToInt32(Request["Id"]);
string ClassId = Request["ClassId"];
string ClassName = this.txtClassName.Text.Trim();
string ClassList = ""; //栏目包含列表
string ClassPre = Request["ClassPre"]; //上一级目录
int ClassTj = 1; //栏目深度
int ClassKind = Convert.ToInt32(Request["ClassKind"]);
if (ClassPre == "0")
{
ClassList = ClassId + ",";
ClassTj = 1;
}
else
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassListByClassId(ClassPre);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
ClassList = dr["ClassList"].ToString().Trim() + ClassId + ",";
ClassTj = Convert.ToInt32(dr["ClassTj"]) + 1;
}
}
model.Id = Id;
model.ClassId = ClassId;
model.ClassName = ClassName;
model.ClassList = ClassList;
model.ClassPre = ClassPre;
model.ClassTj = ClassTj;
model.ClassOrder = 0;
model.ClassKind = ClassKind;
model.ListType = 0;
model.GoType = 0;
model.DefaultFile = txtDefaultFile.Text;
model.FilePath = txtFilePath.Text;
model.ColumnsType = Convert.ToInt32(txtColumnsType.SelectedValue);
model.WebsiteUrl = txtWebsiteUrl.Text;
model.TemplateIndex = txtTemplateIndex.Text;
model.TemplateList = txtTemplateList.Text;
model.TemplateShow = txtTemplateShow.Text;
model.ListeRules = txtListeRules.Text;
model.ShowRules = txtShowRules.Text;
model.keyword = txtkeyword.Text;
model.Description = txtDescription.Text;;
model.contents = Request["content"];
if (new ROYcms.Sys.BLL.ROYcms_class().ClassUpdate(model))
{
NewXml(model.Id);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ajaxjs", "alert('栏目编辑成功！')", true);
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ajaxjs", "alert('栏目保存操作失败！')", true);
}
//this.txtClassName.Text = "";
}
/// <summary>
/// 添加一个频道
/// </summary>
public int Insert()
{
Model.Id = ROYcms.Common.Request.GetFormInt("Id");
if (Model.Id > 0) // 如果是编辑
{
Model = BLL._GetModel(Model.Id.ToString());
}
else
{
Model.ClassId = ROYcms.Common.StringPlus.GetRamCode();
string ClassList = ""; //栏目包含列表
string ClassPre = ROYcms.Common.Request.GetFormString("ClassId") == "" ? "0" : ROYcms.Common.Request.GetFormString("ClassId"); //父亲级ID
int ClassTj = 1; //栏目深度
if (ClassPre == "0") //是顶层
{
ClassList = Model.ClassId + ",";
ClassTj = 1;
}
else
{
DataSet ds = new ROYcms.Sys.BLL.ROYcms_class().GetClassListByClassId(ClassPre);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
ClassList = dr["ClassList"].ToString().Trim() + Model.ClassId + ",";
ClassTj = Convert.ToInt32(dr["ClassTj"]) + 1;
}
}
Model.ClassList = ClassList;
Model.ClassPre = ClassPre;
Model.ClassTj = ClassTj;
}
Model.ClassName = ROYcms.Common.Request.GetFormString("ClassName");
Model.ClassKind = ROYcms.Common.Request.GetFormInt("ClassKind");
Model.ClassOrder = 0;
Model.ListType = 0;
Model.GoType = 0;
Model.ContentType = 0;
Model.DefaultFile = ROYcms.Common.Request.GetFormString("DefaultFile");
Model.FilePath = ROYcms.Common.Request.GetFormString("FilePath");
Model.ColumnsType = ROYcms.Common.Request.GetFormInt("ColumnsType");
Model.WebsiteUrl = ROYcms.Common.Request.GetFormString("WebsiteUrl");
Model.TemplateIndex = ROYcms.Common.Request.GetFormString("TemplateIndex");
Model.TemplateList = ROYcms.Common.Request.GetFormString("TemplateList");
Model.TemplateShow = ROYcms.Common.Request.GetFormString("TemplateShow");
Model.ListeRules = ROYcms.Common.Request.GetFormString("ListeRules");
Model.ShowRules = ROYcms.Common.Request.GetFormString("ShowRules");
Model.keyword = ROYcms.Common.Request.GetFormString("keyword");
Model.Description = ROYcms.Common.Request.GetFormString("Description");
Model.contents = ROYcms.Common.Request.GetFormString("contents");
if (Model.Id > 0)
{
if (!BLL.Exists(Model.FilePath, Model.DefaultFile)) //不存在
{
return(BLL.ClassUpdate(Model) == true ? 1 : 0);
}
else
{
if (BLL.GetId(Model.FilePath, Model.DefaultFile) == Model.Id)//当前的地址
{
return(BLL.ClassUpdate(Model) == true ? 1 : 0);
}
else
{
return(-1);
}
}
}
else
{
if (!BLL.Exists(Model.FilePath, Model.DefaultFile))
{
return(BLL.ClassAdd(Model) == true ? 1 : 0);
}
else
{
return(-1);
}
}
}
///// <summary>
///// loopPage分页标签的匹配替换
///// </summary>
///// <param name="template">模板内容</param>
public string loopPage(string template)
{
string Attributes = "";
string Text = "";
string AllText = "";
Regex r = new Regex(@"(\[SG:loopPage\s+(?<attributes>[^\]]*?)\](?<text>[\s\S]*?)\[/SG:loopPage\])", RegexOptions.Compiled | RegexOptions.IgnoreCase);
foreach (Match m in r.Matches(template))
{
Attributes = m.Groups["attributes"].ToString(); //循环属性集
Text = m.Groups["text"].ToString(); //循环的内容不包含SG:Loop
AllText = m.Groups[0].Value.ToString(); //整个匹配的内容包含SG:Loop
#region 取得相关属性
string NewsCount = null; //调用数量
string TitleNum = null; //新闻标题的显示字符数量
string ding = null;
string tuijian = null;
string NewsType = null; //调用新闻的类型
string Templet = null; // 模板ID
string Pagesize = null; //
string SQL = null;
NewsCount = TagVal(Attributes, "NewsCount");
if (NewsCount == null)
{
NewsCount = "1000";
}
TitleNum = TagVal(Attributes, "TitleNum");
if (TitleNum == null)
{
TitleNum = "100";
}
ding = TagVal(Attributes, "ding");
if (ding == null)
{
ding = "false";
}
tuijian = TagVal(Attributes, "tuijian");
if (tuijian == null)
{
tuijian = "false";
}
NewsType = TagVal(Attributes, "NewsType");
if (NewsType == null)
{
NewsType = "0";
}
if (this.classs != null)
{
NewsType = this.classs;
}
Templet = TagVal(Attributes, "Templet");
Pagesize = TagVal(Attributes, "Pagesize");
if (Pagesize == null)
{
Pagesize = "30";
}
SQL = TagVal(Attributes, "SQL");
#endregion
#region 构造 查询SQL语句
//SQL语句拼接
string strWher = "";
StringBuilder strSql = new StringBuilder();
if (SQL == null)
{
strWher = "classname='" + NewsType + "'";
strSql.Append("select top ");
strSql.Append(NewsCount);
strSql.Append(" * from [" + config.date_prefix + "news] where ");
strSql.Append(strWher);
strSql.Append(" AND switchs='0'");
if (ding == "true")
{
strSql.Append(" AND ding='0'");
}
if (tuijian == "true")
{
strSql.Append(" AND tuijian='0'");
}
strSql.Append(" order by switchs,bh DESC");
}
else
{
strSql.Append(SQL);
}
#endregion
#region 对循环的内容进行替换
string content = "";
DataSet Pa = Bll.GetDataSet(strSql.ToString());
int PageContent = Pa.Tables[0].Rows.Count;//数据总数 分页用
int PS = Convert.ToInt32(Pagesize);
int p = Convert.ToInt32(pageNum == null ? "1" : pageNum) - 1;
DataTable dt = new DataTable();
dt = Pa.Tables[0];
if (dt.Rows.Count > 0)
{
int rowsCount = p * PS + PS;
if ((p * PS + PS) - dt.Rows.Count > 0)
{
rowsCount = dt.Rows.Count;
}
for (int n = p * PS; n < rowsCount; n++)
{
string str = Text;
str = Replace(str, @"\[SG:Title\]", ROYcms.Common.input.GetSubString(dt.Rows[n]["title"].ToString(), Convert.ToInt32(TitleNum)));
str = Replace(str, @"\[SG:Id\]", dt.Rows[n]["bh"].ToString());
str = Replace(str, @"\[SG:Url\]", dt.Rows[n]["url"].ToString());
str = Replace(str, @"\[SG:Link\]", dt.Rows[n]["jumpurl"].ToString() == "" ? (config.web_host + TemplateZone.Zpath(this.pageHost) + "show" + Templet + "-" + dt.Rows[n]["bh"].ToString() + "-" + Convert.ToDateTime(dt.Rows[n]["time"]).ToString("yyyyMM") + config.web_forge) : dt.Rows[n]["jumpurl"].ToString());
str = Replace(str, @"\[SG:_Link\]", dt.Rows[n]["jumpurl"].ToString() == "" ? ("show-" + dt.Rows[n]["bh"].ToString() + "-" + Convert.ToDateTime(dt.Rows[n]["time"]).ToString("yyyyMM") + config.web_forge) : dt.Rows[n]["jumpurl"].ToString());
str = Replace(str, @"\[SG:Pic\]", dt.Rows[n]["pic"].ToString());
str = Replace(str, @"\[SG:Zhaiyao\]", dt.Rows[n]["zhaiyao"].ToString());
str = Replace(str, @"\[SG:Keyword\]", dt.Rows[n]["keyword"].ToString());
str = Replace(str, @"\[SG:classname\]", dt.Rows[n]["classname"].ToString());
str = Replace(str, @"\[SG:Content\]", dt.Rows[n]["contents"].ToString());
str = Replace(str, @"\[SG:Infor\]", dt.Rows[n]["infor"].ToString());
str = Replace(str, @"\[SG:Author\]", dt.Rows[n]["author"].ToString());
str = Replace(str, @"\[SG:Tag\]", dt.Rows[n]["tag"].ToString());
str = Replace(str, @"\[SG:Dig\]", dt.Rows[n]["dig"].ToString());
str = Replace(str, @"\[SG:Hits\]", dt.Rows[n]["hits"].ToString());
str = Replace(str, @"\[SG:Time\]", dt.Rows[n]["time"].ToString());
str = Replace(str, @"\[SG:Year\]", Convert.ToDateTime(dt.Rows[n]["time"]).Date.Year.ToString());
str = Replace(str, @"\[SG:Month\]", Convert.ToDateTime(dt.Rows[n]["time"]).Date.Month.ToString());
str = Replace(str, @"\[SG:Day\]", Convert.ToDateTime(dt.Rows[n]["time"]).Date.Day.ToString());
content += str;
}
}
else
{
content = "";
}
#endregion
template = template.Replace(AllText, content);
template = template.Replace(@"[SG:Page]", PageContent.ToString());
if (this.classs != null)
{
ROYcms.Sys.BLL.ROYcms_class ROYcms_classBLL = new ROYcms.Sys.BLL.ROYcms_class();
template = template.Replace(@"[SG:ClassTitle]", ROYcms_classBLL.GetClassTitle(Convert.ToInt32(this.classs)));
}
}
return(template);
}
