protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
M_Node node = new M_Node();
node.NodeID = DataConverter.CLng(this.HdnNodeID.Value);
node.NodeName = this.TxtNodeName.Text;
node.NodeType = 2;
node.NodePic = this.TxtNodePicUrl.Text;
node.NodeDir = this.TxtNodeDir.Text;
node.NodeUrl = "";
node.ParentID = DataConverter.CLng(this.HdnParentId.Value);
node.Child = 0;
node.Depth = DataConverter.CLng(this.HdnDepth.Value);
node.OrderID = DataConverter.CLng(this.HdnOrderID.Value);
node.Tips = this.TxtTips.Text;
node.Description = this.TxtDescription.Text;
node.Meta_Keywords = this.TxtMetaKeywords.Text;
node.Meta_Description = this.TxtMetaDescription.Text;
node.OpenNew = DataConverter.CBool(this.RBLOpenType.SelectedValue);
node.ItemOpenType = true;
node.PurviewType = false;
node.CommentType = false;
node.HitsOfHot = 0;
node.ListTemplateFile = this.TxtTemplate.Text;
node.ContentModel = "";
node.ListPageHtmlEx = DataConverter.CLng(this.RBLListEx.SelectedValue);
node.ContentFileEx = 0;
node.ContentPageHtmlRule = 0;
this.bll.UpdateNode(node);
Response.Redirect("NodeManage.aspx");
}
}
private string FileSavePath(string fileName)
{
string str = "";
if (SiteConfig.SiteOption.EnableUploadFiles)
{
this.m_NodeInfo = bnode.GetNode(DataConverter.CLng(this.ViewState["NodeId"].ToString()));
str = this.m_NodeInfo.NodeDir + "/{$FileType}/{$Year}/{$Month}/";
str = str.Replace("{$FileType}", Path.GetExtension(fileName).ToLower().Replace(".", "")).Replace("{$Year}", DateTime.Now.Year.ToString()).Replace("{$Month}", DateTime.Now.Month.ToString()).Replace("\\", "/");
this.m_ShowPath = str;
}
return str;
}
/// <summary>
/// 保存节点
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
M_Node node = new M_Node();
node.NodeID = 0;
node.NodeName = this.TxtNodeName.Text;
node.NodeType = 1;
node.NodePic = this.TxtNodePicUrl.Text;
node.NodeDir = this.TxtNodeDir.Text;
node.NodeUrl = "";
node.ParentID = DataConverter.CLng(this.HdnParentId.Value);
node.Child = 0;
node.Depth = DataConverter.CLng(this.HdnDepth.Value);
node.OrderID = DataConverter.CLng(this.HdnOrderID.Value);
node.Tips = this.TxtTips.Text;
node.Description = this.TxtDescription.Text;
node.Meta_Keywords = this.TxtMetaKeywords.Text;
node.Meta_Description = this.TxtMetaDescription.Text;
node.OpenNew = DataConverter.CBool(this.RBLOpenType.SelectedValue);
node.ItemOpenType = DataConverter.CBool(this.RBLItemOpenType.SelectedValue);
node.PurviewType = DataConverter.CBool(this.RBLPurviewType.SelectedValue);
node.CommentType = DataConverter.CBool(this.RBLCommentType.SelectedValue);
node.HitsOfHot = DataConverter.CLng(this.TxtHitsOfHot.Text);
node.ListTemplateFile = this.TxtTemplate.Text;
node.IndexTemplate = this.TxtIndexTemplate.Text;
string modellist = this.Page.Request.Form["ChkModel"];
if (modellist == null)
modellist = "";
node.ContentModel = modellist;
node.ListPageHtmlEx = DataConverter.CLng(this.RBLListEx.SelectedValue);
node.ContentFileEx = DataConverter.CLng(this.RBLContentEx.SelectedValue);
node.ContentPageHtmlRule = DataConverter.CLng(this.DDLContentRule.SelectedValue);
int newNode=this.bll.AddNode(node);
string[] ModelArr = modellist.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
//this.bll.DelTemplate(newNode);
for (int i = 0; i < ModelArr.Length; i++)
{
if (!string.IsNullOrEmpty(this.Page.Request.Form["TxtModelTemplate_" + ModelArr[i]].Trim()))
{
//将模型模板设定写入数据库
string temp = this.Page.Request.Form["TxtModelTemplate_" + ModelArr[i]].Trim();
this.bll.AddModelTemplate(newNode, DataConverter.CLng(ModelArr[i]), temp);
}
}
if (node.ParentID > 0)
this.bll.SetChildAdd(node.ParentID);
Response.Redirect("NodeManage.aspx");
}
}
int ID_Node.AddNode(M_Node NodeInfo)
{
string strSql = "PR_Nodes_Add";
SqlParameter[] cmdParams = GetParameters(NodeInfo);
return SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.StoredProcedure,strSql,cmdParams));
}
/// <summary>
/// 将节点信息的各属性值传递到参数中
/// </summary>
/// <param name="administratorInfo"></param>
/// <returns></returns>
private static SqlParameter[] GetParameters(M_Node Nodeinfo)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@NodeID", SqlDbType.Int, 4),
new SqlParameter("@NodeName", SqlDbType.NVarChar, 50),
new SqlParameter("@NodeType", SqlDbType.Int, 4),
new SqlParameter("@Tips", SqlDbType.NVarChar, 255),
new SqlParameter("@NodeDir", SqlDbType.NVarChar, 50),
new SqlParameter("@NodeUrl", SqlDbType.NVarChar, 255),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Child", SqlDbType.Int, 4),
new SqlParameter("@Depth", SqlDbType.Int, 4),
new SqlParameter("@NodePicUrl", SqlDbType.NVarChar, 255),
new SqlParameter("@Description", SqlDbType.NVarChar, 255),
new SqlParameter("@Meta_Keywords", SqlDbType.NVarChar, 255),
new SqlParameter("@Meta_Description", SqlDbType.NVarChar, 255),
new SqlParameter("@OpenType", SqlDbType.Bit, 1),
new SqlParameter("@PurviewType", SqlDbType.Bit, 1),
new SqlParameter("@CommentType", SqlDbType.Bit, 1),
new SqlParameter("@HitsOfHot", SqlDbType.Int, 4),
new SqlParameter("@ListTemplateFile", SqlDbType.NVarChar, 255),
new SqlParameter("@IndexTemplate", SqlDbType.NVarChar, 255),
new SqlParameter("@ContentModel", SqlDbType.NVarChar, 255),
new SqlParameter("@ItemOpenType", SqlDbType.Bit, 1),
new SqlParameter("@ContentHtmlRule", SqlDbType.Int, 4),
new SqlParameter("@ListPageHtmlEx", SqlDbType.Int, 4),
new SqlParameter("@ContentFileEx", SqlDbType.Int, 4),
new SqlParameter("@OrderID", SqlDbType.Int, 4)
};
parameter[0].Value = Nodeinfo.NodeID;
parameter[1].Value = Nodeinfo.NodeName;
parameter[2].Value = Nodeinfo.NodeType;
parameter[3].Value = Nodeinfo.Tips;
parameter[4].Value = Nodeinfo.NodeDir;
parameter[5].Value = Nodeinfo.NodeUrl;
parameter[6].Value = Nodeinfo.ParentID;
parameter[7].Value = Nodeinfo.Child;
parameter[8].Value = Nodeinfo.Depth;
parameter[9].Value = Nodeinfo.NodePic;
parameter[10].Value = Nodeinfo.Description;
parameter[11].Value = Nodeinfo.Meta_Keywords;
parameter[12].Value = Nodeinfo.Meta_Description;
parameter[13].Value = Nodeinfo.OpenNew;
parameter[14].Value = Nodeinfo.PurviewType;
parameter[15].Value = Nodeinfo.CommentType;
parameter[16].Value = Nodeinfo.HitsOfHot;
parameter[17].Value = Nodeinfo.ListTemplateFile;
parameter[18].Value = Nodeinfo.IndexTemplate;
parameter[19].Value = Nodeinfo.ContentModel;
parameter[20].Value = Nodeinfo.ItemOpenType;
parameter[21].Value = Nodeinfo.ContentPageHtmlRule;
parameter[22].Value = Nodeinfo.ListPageHtmlEx;
parameter[23].Value = Nodeinfo.ContentFileEx;
parameter[24].Value = Nodeinfo.OrderID;
return parameter;
}
/// <summary>
/// 从DataReader中读取管理员记录
/// </summary>
/// <param name="rdr">DataReader</param>
/// <returns>M_Node 节点信息</returns>
private static M_Node GetNodeFromReader(SqlDataReader rdr)
{
M_Node info = new M_Node();
info.NodeID = DataConverter.CLng(rdr["NodeID"]);
info.NodeName = rdr["NodeName"].ToString();
info.NodeType = DataConverter.CLng(rdr["NodeType"]);
info.Tips = rdr["Tips"].ToString();
info.ParentID = DataConverter.CLng(rdr["ParentID"]);
info.OrderID = DataConverter.CLng(rdr["OrderID"]);
info.Child = DataConverter.CLng(rdr["Child"]);
info.Depth = DataConverter.CLng(rdr["Depth"]);
info.NodeDir = rdr["NodeDir"].ToString();
info.NodeUrl = rdr["NodeUrl"].ToString();
info.NodePic = rdr["NodePicUrl"].ToString();
info.Description = rdr["Description"].ToString();
info.Meta_Keywords = rdr["Meta_Keywords"].ToString();
info.Meta_Description = rdr["Meta_Description"].ToString();
info.OpenNew = DataConverter.CBool(rdr["OpenType"].ToString());
info.PurviewType = DataConverter.CBool(rdr["PurviewType"].ToString());
info.CommentType = DataConverter.CBool(rdr["CommentType"].ToString());
info.HitsOfHot = DataConverter.CLng(rdr["HitsOfHot"]);
info.ListTemplateFile = rdr["ListTemplateFile"].ToString();
info.IndexTemplate = rdr["IndexTemplate"].ToString();
info.ContentModel = rdr["ContentModel"].ToString();
info.ItemOpenType = DataConverter.CBool(rdr["ItemOpenType"].ToString());
info.ContentPageHtmlRule = DataConverter.CLng(rdr["ContentHtmlRule"]);
info.ListPageHtmlEx = DataConverter.CLng(rdr["ListPageHtmlEx"]);
info.ContentFileEx = DataConverter.CLng(rdr["ContentFileEx"]);
return info;
}
bool ID_Node.UpdateNode(M_Node NodeInfo)
{
string strSql = "PR_Nodes_Update";
SqlParameter[] cmdParams = GetParameters(NodeInfo);
return SqlHelper.ExecuteProc(strSql, cmdParams);
}
/// <summary>
/// 添加节点到数据库
/// </summary>
/// <param name="node"></param>
public int AddNode(M_Node node)
{
return this.dal.AddNode(node);
}
/// <summary>
/// 更改节点数据
/// </summary>
/// <param name="node"></param>
public void UpdateNode(M_Node node)
{
this.dal.UpdateNode(node);
}
