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); }