using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Pub_Control { public partial class frmHlpTree : Form { public frmHlpTree() { InitializeComponent(); } public string WherePart; public string sTitle; public string sBill; public string sView; TreeNode CurNode=new TreeNode(); public Pub_Class.ClsPub.Enum_OKTag OKTag; Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); private void frmHlpTree_Load(object sender, EventArgs e) { initGrid(); LoadTree(); } //初始化GRID private void initGrid() { //grdMain.Rows = 1; grdMain.FixedCols = 0; //grdMain.FixedRows = 1; grdMain.RowHeightMin = 250; grdMain.set_RowHeight(0, 450); grdMain.ExplorerBar = VSFlex7.ExplorerBarSettings.flexExSort; grdMain.AllowBigSelection = false; grdMain.AllowSelection = true; grdMain.SelectionMode = VSFlex7.SelModeSettings.flexSelectionListBox; grdMain.AllowUserResizing = VSFlex7.AllowUserResizeSettings.flexResizeColumns; grdMain.set_ColAlignment(-1, VSFlex7.AlignmentSettings.flexAlignLeftCenter); // Pub_Class.ClsPub.GetGrid(grdMain, sTitle, Pub_Class.ClsPub.AppPath); // lblCaption.Text = sTitle; this.Text = sTitle; // grdMain.set_ColWidth(grdMain.Cols - 1, 10); grdMain.ExtendLastCol = true; grdMain.Col = 1; } //选中项目验证 private bool AllowRow() { if (grdMain.Row >= grdMain.FixedRows && grdMain.Row <= grdMain.Rows - 1) return true; else return false; } //双击 GRID private void grdMain_DblClick(object sender, EventArgs e) { if (AllowRow()) BackData(); } //时间TIMER private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; this.Text = sTitle; } //返回 private void BackData() { OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_OK; this.Visible = false; } //退出 private void tc_Click(object sender, EventArgs e) { OKTag = Pub_Class.ClsPub.Enum_OKTag.OKTag_Cancel; this.Visible = false; } //返回按钮 private void fh_Click(object sender, EventArgs e) { BackData(); } //单击树形 private void tvProcess_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { CurNode = e.Node; if (CurNode != null) { if (CurNode.Nodes.Count == 0) { LoadAllNodes(CurNode); } QueryItem(); } } //加载树型 private void LoadTree() { try { tvTree.Nodes.Clear(); tvTree.ImageList = imageList1; TreeNode sNode = tvTree.Nodes.Add("T0", this.Text, 0, 1); LoadAllNodes(sNode); } catch (Exception e) { MessageBox.Show(this,"加载树型失败！" + e.Message,"提示"); } } //加载子项目 private void LoadAllNodes(TreeNode sNode) { if (sNode != null) { try { long sName = Convert.ToInt64(sNode.Name.Substring(1, sNode.Name.Length - 1)); sNode.Nodes.Clear(); DataSet Ds = oCn.RunProcReturn("select HItemID,HNumber,HName from " + sBill + " where HEndFlag=0 and HParentID='" + sName + "'", sBill); for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) { TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + "-" + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1); } sNode.Expand(); } catch (Exception e) { //MessageBox.Show("加载子项目失败！" + e.Message); } } } //合理的选中列 private bool AllowCol() { if (grdMain.Col >= grdMain.FixedCols && grdMain.Col <= grdMain.Cols - 1) { return true; } else { return false; } } //保存列宽 private void frmHlpTree_FormClosing(object sender, FormClosingEventArgs e) { Pub_Class.ClsPub.SaveGrid(grdMain, sTitle, Pub_Class.ClsPub.AppPath); } //过滤项目 private void QueryItem() { string sTreeCode; //得到树型 代码 try { // int Col; if (AllowCol()) Col = grdMain.Col; else Col = 1; // if (CurNode != null) { char c = Convert.ToChar("-"); string[] s = CurNode.Text.Split(c); if (s.Length > 1) { sTreeCode = s[0].Trim().ToUpper(); } else { sTreeCode = "";//选中 最大结点的时候 } } else { sTreeCode = ""; } int j = sTreeCode.Length; //显示全部 grdMain.Redraw = VSFlex7.RedrawSettings.flexRDNone; for (int i = grdMain.FixedRows; i < grdMain.Rows; i++) { if (grdMain.get_TextMatrix(i, 1).Length <= j ) { grdMain.set_RowHidden(i, true); } else { if (sTreeCode != "") { if (Pub_Class.ClsPub.isStrNull(grdMain.get_TextMatrix(i, 1)) != "") { if (grdMain.get_TextMatrix(i, 1).ToUpper().Trim() != sTreeCode) { if (grdMain.get_TextMatrix(i, 1).ToUpper().Trim().Substring(0, j + 1) == sTreeCode + ".") { grdMain.set_RowHidden(i, false); } else { grdMain.set_RowHidden(i, true); } } else { grdMain.set_RowHidden(i, false); } } } else { grdMain.set_RowHidden(i, false); } //txt if (txtFindInfo.Text.Trim() != "") { string txtCode = txtFindInfo.Text.Trim().ToUpper(); if (chkMH.Checked == true) { if (Pub_Class.ClsPub.isStrNull(grdMain.get_TextMatrix(i, Col)) != "") { if (grdMain.get_TextMatrix(i, Col).ToUpper().Trim().Contains(txtCode)) { grdMain.set_RowHidden(i, false); } else { grdMain.set_RowHidden(i, true); } } } else { if (Pub_Class.ClsPub.isStrNull(grdMain.get_TextMatrix(i, Col)) != "") { if (grdMain.get_TextMatrix(i, Col).ToUpper().Trim() == txtCode) { grdMain.set_RowHidden(i, false); } else { grdMain.set_RowHidden(i, true); } } } } } } grdMain.Redraw = VSFlex7.RedrawSettings.flexRDBuffered; } catch (Exception e) { return; } } private void txtFindInfo_TextChanged(object sender, EventArgs e) { if(this.Visible==true) QueryItem(); } private void chkMH_CheckedChanged(object sender, EventArgs e) { QueryItem(); } private void cx_Click(object sender, EventArgs e) { QueryItem(); } private void grdMain_RowColChange(object sender, EventArgs e) { if (grdMain.Col >= grdMain.FixedCols) lblFindCol.Text =Pub_Class.ClsPub.isStrNull(grdMain.get_TextMatrix(0, grdMain.Col)); else lblFindCol.Text = Pub_Class.ClsPub.isStrNull(grdMain.get_TextMatrix(0, 1)); } private void grdMain_SelChange(object sender, EventArgs e) { } } }