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 frmHlpInfo_View : Form
|
{
|
public frmHlpInfo_View()
|
{
|
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 frmHlpInfo_View_Load(object sender, EventArgs e)
|
{
|
initGrid();
|
LoadTree();
|
}
|
//初始化GRID
|
private void initGrid()
|
{
|
grdShow.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //选中模式--行选中
|
grdShow.ColumnHeadersVisible = true; //标题列显示--是
|
grdShow.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //标题列尺寸模式--（自动调整，可调整）
|
grdShow.RowTemplate.Height = 18;
|
grdShow.RowTemplate.MinimumHeight = 18;
|
grdShow.ColumnHeadersHeight = 35; //标题行高
|
grdShow.RowHeadersVisible = false; //标题行可见--否
|
grdShow.AllowUserToAddRows = false; //是否允许自增--否
|
grdShow.AllowUserToDeleteRows = false; //是否允许删除--否
|
//grdShow.ColumnCount = 0; //总列数--5
|
//grdShow.RowCount = 0;
|
grdShow.AllowUserToResizeColumns = true; //允许调整列宽--是
|
grdShow.AllowUserToResizeRows = false; //允许调整行高--否
|
grdShow.ReadOnly = true; //只读--是
|
grdShow.BackgroundColor = Color.White;
|
grdShow.GridColor = Color.LightGray;
|
grdShow.DefaultCellStyle.SelectionBackColor = Color.Black;
|
grdShow.EnableHeadersVisualStyles = false; //网格标题 样式
|
grdShow.ColumnHeadersDefaultCellStyle.BackColor = Color.LightGray;
|
grdShow.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;//网格内容 对齐方式
|
Pub_Class.ClsPub.GetGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath);
|
}
|
|
//双击 GRID
|
private void grdShow_DblClick(object sender, EventArgs e)
|
{
|
if (grdShow.CurrentCell == null)
|
{
|
return;
|
}
|
//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 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 void frmHlpInfo_View_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
//Pub_Class.ClsPub.SaveGridView(grdShow, sTitle, Pub_Class.ClsPub.AppPath);
|
}
|
|
public Int32 Fun_GetCol(string sCol, DataGridView grdMain)
|
{
|
for (int c = 0; c < grdMain.ColumnCount; c++)
|
{
|
if (Pub_Class.ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
|
{
|
return c;
|
}
|
}
|
return 0;
|
}
|
|
//过滤项目
|
private void QueryItem()
|
{
|
|
|
string sTreeCode;
|
//得到树型 代码
|
try
|
{
|
CurrencyManager cm = (CurrencyManager)BindingContext[grdShow.DataSource];
|
cm.SuspendBinding();
|
//
|
int Col;
|
if (lblFindCol.Text.Trim()!="")
|
Col = Fun_GetCol(lblFindCol.Text.Trim(),grdShow);
|
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;
|
//显示全部
|
for (int i = 0; i < grdShow.Rows.Count; i++)
|
{
|
grdShow.Rows[i].Visible = true;
|
if (grdShow.Rows[i].Cells[Col].Value.ToString().Length < j) //如果长度比 匹配项 小 就先隐藏
|
{
|
grdShow.Rows[i].Visible = false;
|
}
|
else
|
{
|
if (sTreeCode != "")
|
{
|
if (Pub_Class.ClsPub.isStrNull(grdShow.Rows[i].Cells[1].Value.ToString()) != "")
|
{
|
if (grdShow.Rows[i].Cells[1].Value.ToString().ToUpper().Trim() != sTreeCode.ToUpper().Trim())
|
{
|
if (grdShow.Rows[i].Cells[1].Value.ToString().ToUpper().Trim().Contains(sTreeCode+"."))
|
{
|
grdShow.Rows[i].Visible = true;
|
}
|
else
|
{
|
grdShow.Rows[i].Visible = false;
|
}
|
}
|
else
|
{
|
grdShow.Rows[i].Visible = true;
|
}
|
}
|
}
|
else
|
{
|
grdShow.Rows[i].Visible = true;
|
}
|
//txt
|
if (txtFindInfo.Text.Trim() != "")
|
{
|
string txtCode = txtFindInfo.Text.Trim().ToUpper();
|
|
if (Pub_Class.ClsPub.isStrNull(grdShow.Rows[i].Cells[Col].Value.ToString()) != "")
|
{
|
if (grdShow.Rows[i].Cells[Col].Value.ToString().ToUpper().Trim().Contains(txtCode))
|
{
|
grdShow.Rows[i].Visible = true;
|
}
|
else
|
{
|
grdShow.Rows[i].Visible = false;
|
}
|
}
|
else
|
{
|
grdShow.Rows[i].Visible = false;
|
}
|
}
|
//else
|
//{
|
// grdShow.Rows[i].Visible = true;
|
//}
|
}
|
|
}
|
cm.ResumeBinding();
|
Pub_Class.ClsPub.GetGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath);
|
}
|
catch (Exception e)
|
{
|
return;
|
}
|
}
|
|
|
private void txtFindInfo_TextChanged(object sender, EventArgs e)
|
{
|
QueryItem();
|
}
|
|
private void chkMH_CheckedChanged(object sender, EventArgs e)
|
{
|
QueryItem();
|
}
|
|
private void cx_Click(object sender, EventArgs e)
|
{
|
QueryItem();
|
}
|
|
private void grdShow_DoubleClick(object sender, EventArgs e)
|
{
|
if (grdShow.CurrentCell == null)
|
{
|
return;
|
}
|
BackData();
|
}
|
|
private void grdShow_Click(object sender, EventArgs e)
|
{
|
if (grdShow.CurrentCell == null)
|
{
|
return;
|
}
|
if (grdShow.CurrentCell!=null)
|
{
|
lblFindCol.Text = grdShow.Columns[grdShow.CurrentCell.ColumnIndex].HeaderText;
|
}
|
else
|
{
|
lblFindCol.Text = grdShow.Columns[1].HeaderText;
|
}
|
}
|
|
|
|
private void txtFindInfo_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode ==Keys.Enter)
|
{
|
QueryItem();
|
}
|
}
|
|
private void yc_Click(object sender, EventArgs e)
|
{
|
Gy_GridView_Hide oHide = new Gy_GridView_Hide();
|
oHide.KeyItem = this.Name + sBill;
|
oHide.oGrd = grdShow;
|
oHide.ShowDialog();
|
//
|
Pub_Class.ClsPub.HideGridView(grdShow, Name + sBill, Pub_Class.ClsPub.AppPath);//设置隐藏列
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
Pub_Class.ClsPub.SaveGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath);
|
}
|
|
|
|
}
|
}
|
