//新建文章
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);
}
}
}
