//新建文章 private void toolStripMenuItemNewTxt_Click(object sender, EventArgs e) { //获取选中节点 TreeNode SeleNode = treeViewDir.SelectedNode; if (SeleNode == null) { return; } string ParLang = AccessAdo.ExecuteScalar("select SynId from ttree where NodeId=" + SeleNode.Tag.ToString()).ToString(); ParLang = PubFunc.Synid2Language(ParLang); ProperDialog propDia = new ProperDialog("1", "", ParLang); DialogResult dr = propDia.ShowDialog(); if (dr == DialogResult.OK) { string Title = propDia.ReturnVal[0]; string Language = propDia.ReturnVal[1]; string IsOnRoot = propDia.ReturnVal[2]; string SynId = PubFunc.Language2Synid(Language); if (SeleNode != null) { string NewPid = SeleNode.Tag.ToString(); string NewNodeId = AccessAdo.ExecuteScalar("select max(NodeId) from ttree").ToString(); NewNodeId = NewNodeId == "" ? "1" : (Convert.ToInt32(NewNodeId) + 1).ToString(); string NewTurn = AccessAdo.ExecuteScalar("select max(Turn) from ttree where parentId=" + NewPid).ToString(); NewTurn = NewTurn == "" ? "1" : (Convert.ToInt32(NewTurn) + 1).ToString(); //顶层 if (IsOnRoot == "True") { NewPid = "0"; NewTurn = AccessAdo.ExecuteScalar("select max(Turn) from ttree where parentId=0").ToString(); NewTurn = NewTurn == "" ? "1" : (Convert.ToInt32(NewTurn) + 1).ToString(); } //插入数据库记录 DateTime d1 = DateTime.Parse("1970-01-01 08:00:00"); DateTime d2 = DateTime.Now; TimeSpan dt = d2 - d1; //相差秒数 string Seconds = dt.Seconds.ToString(); //插入TTREE string sql = string.Format("insert into ttree(NodeID,Title,ParentId,Type,CreateTime,SynId,Turn) values({0},'{1}',{2},{3},{4},{5},{6})", NewNodeId, Title, NewPid, 1, Seconds, SynId, NewTurn); AccessAdo.ExecuteNonQuery(sql); //插入TTcontent sql = string.Format("insert into tcontent(NodeId) values({0})", NewNodeId); AccessAdo.ExecuteNonQuery(sql); //插入树节点 TreeNode InsertNodeDoc = new TreeNode(Title); InsertNodeDoc.Tag = NewNodeId; InsertNodeDoc.ImageIndex = 1; InsertNodeDoc.SelectedImageIndex = 1; if (IsOnRoot == "True") { treeViewDir.Nodes.Insert(treeViewDir.Nodes.Count, InsertNodeDoc); } else { SeleNode.Nodes.Insert(SeleNode.Nodes.Count, InsertNodeDoc); } //新窗口打开编辑界面 formParent.openNew(NewNodeId); //打开后设置语言 Language = PubFunc.Synid2LanguageSetLang(SynId); formParent.SetLanguage(Language); } } }
//新建文章 private void toolStripMenuItemNewTxt_Click(object sender, EventArgs e) { //获取选中节点 TreeNode SeleNode = treeViewDir.SelectedNode; if (SeleNode == null) return; string ParLang = AccessAdo.ExecuteScalar("select SynId from ttree where NodeId=" + SeleNode.Tag.ToString()).ToString(); ParLang = PubFunc.Synid2Language(ParLang); ProperDialog propDia = new ProperDialog("1", "", ParLang); DialogResult dr = propDia.ShowDialog(); if (dr == DialogResult.OK) { string Title = propDia.ReturnVal[0]; string Language = propDia.ReturnVal[1]; string IsOnRoot = propDia.ReturnVal[2]; string SynId = PubFunc.Language2Synid(Language); if (SeleNode != null) { string NewPid = SeleNode.Tag.ToString(); string NewNodeId = AccessAdo.ExecuteScalar("select max(NodeId) from ttree").ToString(); NewNodeId = NewNodeId == "" ? "1" : (Convert.ToInt32(NewNodeId) + 1).ToString(); string NewTurn = AccessAdo.ExecuteScalar("select max(Turn) from ttree where parentId=" + NewPid).ToString(); NewTurn = NewTurn == "" ? "1" : (Convert.ToInt32(NewTurn) + 1).ToString(); //顶层 if (IsOnRoot == "True") { NewPid = "0"; NewTurn = AccessAdo.ExecuteScalar("select max(Turn) from ttree where parentId=0").ToString(); NewTurn = NewTurn == "" ? "1" : (Convert.ToInt32(NewTurn) + 1).ToString(); } //插入数据库记录 DateTime d1 = DateTime.Parse("1970-01-01 08:00:00"); DateTime d2 = DateTime.Now; TimeSpan dt = d2 - d1; //相差秒数 string Seconds = dt.Seconds.ToString(); //插入TTREE string sql = string.Format("insert into ttree(NodeID,Title,ParentId,Type,CreateTime,SynId,Turn) values({0},'{1}',{2},{3},{4},{5},{6})", NewNodeId, Title, NewPid, 1, Seconds, SynId, NewTurn); AccessAdo.ExecuteNonQuery(sql); //插入TTcontent sql = string.Format("insert into tcontent(NodeId) values({0})", NewNodeId); AccessAdo.ExecuteNonQuery(sql); //插入树节点 TreeNode InsertNodeDoc = new TreeNode(Title); InsertNodeDoc.Tag = NewNodeId; InsertNodeDoc.ImageIndex = 1; InsertNodeDoc.SelectedImageIndex = 1; if (IsOnRoot == "True") { treeViewDir.Nodes.Insert(treeViewDir.Nodes.Count, InsertNodeDoc); } else { SeleNode.Nodes.Insert(SeleNode.Nodes.Count, InsertNodeDoc); } //新窗口打开编辑界面 formParent.openNew(NewNodeId); //打开后设置语言 Language = PubFunc.Synid2LanguageSetLang(SynId); formParent.SetLanguage(Language); } } }