📄 frmbasesort.cs
字号:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace EquipmentMS.BaseInfo
{
public partial class frmBaseSort : Form
{
BaseClass.Operation oper = new EquipmentMS.BaseClass.Operation();
int zclbID = 0;
public frmBaseSort()
{
InitializeComponent();
}
private void frmBaseSort_Load(object sender, EventArgs e)
{
this.FillTreeView();
}
private void FillTreeView()
{
trvFile.Nodes.Clear();
DataSet ds = null;
ds = oper.TreeFill();
TreeNode RootNode = null;
DataTable dt = ds.Tables[0].Copy();
DataView dv = new DataView(dt);
dv.RowFilter = "firstID = -1";
if (dv.Count > 0)
{
foreach (DataRowView myRow in dv)
{
trvFile.Nodes.Add(RootNode = new TreeNode(myRow["zclb"].ToString()));
childTreeView(myRow["zclb"].ToString(), trvFile.Nodes[0], myRow);
trvFile.SelectedNode = trvFile.Nodes[0];
}
}
trvFile.ExpandAll();
}
private void childTreeView(string childPart, TreeNode childNode, DataRowView childRow)
{
string strdeptName = "";
DataSet ds = null;
ds = oper.TreeFill();
DataTable dt = ds.Tables[0].Copy();
DataView dv = new DataView(dt);
dv.RowFilter = "firstID = '" + childRow["secondID"].ToString() + "'";
foreach (DataRowView myRow in dv)
{
strdeptName = myRow["zclb"].ToString();
TreeNode myNode = new TreeNode(strdeptName);
childNode.Nodes.Add(myNode);
childTreeView(strdeptName, myNode, myRow);
}
}
private void trvFile_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
try
{
DataSet ds = oper.GetDataSetBaseZclb(e.Node.Text);
zclbID = Convert.ToInt16(ds.Tables[0].Rows[0]["ID"].ToString());
}
catch
{ }
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DataSet ds = oper.GetDataSetBaseZclb(trvFile.SelectedNode.Text);
if (ds.Tables[0].Rows[0]["firstID"].ToString() != "-1" && ds.Tables[0].Rows[0]["firstID"].ToString() != "0")
{
trvFile.LabelEdit = true;
trvFile.SelectedNode.BeginEdit();
}
}
private void btnMain_Click(object sender, EventArgs e)
{
DataSet ds = oper.GetDataSetBaseZclb(trvFile.SelectedNode.Text);
if (ds.Tables[0].Rows[0]["firstID"].ToString() != "-1" && ds.Tables[0].Rows[0]["firstID"].ToString() != "0")
{
string firstID = ds.Tables[0].Rows[0]["firstID"].ToString();
int d = oper.insertBaseZclb(firstID, "Add", (Convert.ToInt16(firstID) + 1).ToString());
this.trvFile.SelectedNode.Parent.Nodes.Add("Add");
}
}
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
DataSet ds = oper.GetDataSetBaseZclb(trvFile.SelectedNode.Text);
if (ds.Tables[0].Rows[0]["firstID"].ToString() != "-1" && ds.Tables[0].Rows[0]["firstID"].ToString() != "0")
{
oper.deleteBaseZclb(Convert.ToInt16(ds.Tables[0].Rows[0]["id"].ToString()));
MessageBox.Show("Delete Succeed","System prompt",MessageBoxButtons.OK,MessageBoxIcon.Information);
this.FillTreeView();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
oper.UpdateBaseZclb(zclbID, trvFile.SelectedNode.Text);
this.FillTreeView();
trvFile.LabelEdit = false;
}
private void trvFile_AfterSelect(object sender, TreeViewEventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -