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 : Form { public frmHlpInfo() { InitializeComponent(); } public string WherePart; public string sTitle; public string sBill; public string sView; public int CurCol = 0; public int Cur2Col = 0; public string sOtherItem; public string sSQLWhere; TreeNode CurNode = new TreeNode(); public Pub_Class.ClsPub.Enum_OKTag OKTag; Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper(); private void frmHlpInfo_Load(object sender, EventArgs e) { initGrid(); LoadTree(); QueryText(); } //初始化GRID private void initGrid() { grdShow.RowTemplate.Height = 18; //行高设置 grdShow.RowTemplate.MinimumHeight = 18; //最小行高 grdShow.ColumnHeadersHeight = 35; //标题行高 grdShow.RowHeadersVisible = false; //固定列是否显示 grdShow.ColumnHeadersVisible = true; //固定行是否显示 grdShow.ReadOnly = true; //只读--是 // grdShow.RowsDefaultCellStyle.SelectionForeColor = Color.White; //行选中字体颜色 grdShow.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //内容布局（居中，靠右） grdShow.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;//标题行布局（居中，靠右） grdShow.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //选行模式 grdShow.EditMode = DataGridViewEditMode.EditOnEnter; //编辑模式 grdShow.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //标题行高 调整模式 grdShow.EnableHeadersVisualStyles = true; //标题 显示样式 grdShow.AllowUserToAddRows = false; //是否允许自增--否 grdShow.AllowUserToDeleteRows = false; //是否允许删除--否 grdShow.AllowUserToResizeColumns = true; //允许调整列宽--是 grdShow.AllowUserToResizeRows = false; //允许调整行高--否 grdShow.AllowUserToOrderColumns = false; //是否允许拖拽列 grdShow.BackgroundColor = Color.White; //网格背景色 grdShow.GridColor = Color.LightGray; //网格线颜色 grdShow.DefaultCellStyle.SelectionBackColor = Color.Black; //选中时背景颜色 grdShow.ShowCellToolTips = false; //鼠标停留 显示提示 grdShow.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;//网格内容 对齐方式 } //双击 GRID private void grdMain_DblClick(object sender, EventArgs e) { //if (AllowRow()) if (grdShow.CurrentCell == null) { return; } BackData(); } //时间TIMER private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; this.Text = sTitle; //如果过滤框有内容 则自动过滤 if (this.txtFindInfo.Text.Trim()!= "") { QueryText(); } } //返回 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); } QueryTree(); } } //加载树型 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]["物料代码"].ToString() + "~" + Ds.Tables[0].Rows[i]["物料名称"].ToString(), 0, 1); } sNode.Expand(); } catch (Exception e) { //MessageBox.Show("加载子项目失败！" + e.Message); } } } //保存列宽 private void frmHlpInfo_FormClosing(object sender, FormClosingEventArgs e) { //ClsPub.SaveGrid(grdMain, sTitle); } //过滤项目 private void QueryText() { try { string sWhere = ""; if (CurCol != null) { switch (CurCol) { case 0: sWhere = "and Hnumber like '%" + txtFindInfo.Text.Trim() + "%'"; break; case 1: sWhere = "and Hnumber like '%" + txtFindInfo.Text.Trim() + "%'"; break; case 2: sWhere = "and HName like '%" + txtFindInfo.Text.Trim() + "%'"; break; case 3: sWhere = "and HModel like '%" + txtFindInfo.Text.Trim() + "%'"; break; case 4: sWhere = " and HPicNo like '%" + txtFindInfo.Text.Trim() + "%'"; break; default: sWhere = "and Hnumber like '%" + txtFindInfo.Text.Trim() + "%'"; break; } } else { sWhere = "and Hnumber like '%" + txtFindInfo.Text.Trim() + "%'"; } string sWhere2 = ""; if (txtFindInfo2.Text.Trim() != "") { if (Cur2Col != null) { switch (Cur2Col) { case 0: sWhere2 = " and Hnumber like '%" + txtFindInfo2.Text.Trim() + "%'"; break; case 1: sWhere2 = " and Hnumber like '%" + txtFindInfo2.Text.Trim() + "%'"; break; case 2: sWhere2 = " and Hname like '%" + txtFindInfo2.Text.Trim() + "%'"; break; case 3: sWhere2 = " and HModel like '%" + txtFindInfo2.Text.Trim() + "%'"; break; case 4: sWhere2 = " and HPicNo like '%" + txtFindInfo2.Text.Trim() + "%'"; break; default: sWhere2 = " and Hnumber like '%" + txtFindInfo2.Text.Trim() + "%'"; break; } } else { sWhere2 = " and Hnumber like '%" + txtFindInfo2.Text.Trim() + "%'"; } } string sSQL = "Select HItemID,Hnumber 物料代码,Hname 物料名称,HModel 规格型号,HPicNo 图号,HUnitNumber 单位代码,Hunitname 计量单位,HUnitID " + sOtherItem + " from " + sBill + " where HEndFlag=1 " + sWhere + sWhere2 + sSQLWhere + " Order by Hnumber "; //编辑ofrm // ExecSQL(sSQL); return; } catch (Exception e) { MessageBox.Show("显示失败!"+e.Message ); return; } } //执行SQL private void ExecSQL(string sSQL) { DataSet Ds = new DataSet(); Ds = oCn.RunProcReturn(sSQL, sBill); grdShow.DataSource = Ds.Tables[0].DefaultView; //隐藏H列 string s = ""; for (int i = 0; i < grdShow.ColumnCount; i++) { s = grdShow.Columns[i].HeaderText.Trim(); if (s.Substring(0, 1).ToUpper() == "H") { grdShow.Columns[i].Visible = false; } else { grdShow.Columns[i].Visible = true; } } //获取列宽 Pub_Class.ClsPub.GetGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath); } //树形过滤项目 private void QueryTree() { try { string sWhere = ""; if (CurNode != null) { char c = Convert.ToChar("~"); string[] s = CurNode.Text.Split(c); if (s.Length > 1) { sWhere = "and Hnumber like '" + s[0].Trim() + "%'"; } else { sWhere = "";//选中 最大结点的时候 } } else { sWhere = ""; } string sSQL = "Select HItemID,Hnumber 物料代码,Hname 物料名称,HModel 规格型号,HPicNo 图号,HUnitNumber 单位代码,Hunitname 计量单位,HUnitID " + sOtherItem + " from " + sBill + " where HEndFlag=1 " + sWhere + " Order by Hnumber "; //编辑ofrm // ExecSQL(sSQL); return; } catch (Exception e) { MessageBox.Show("显示失败!" + e.Message); return; } } private void chkMH_CheckedChanged(object sender, EventArgs e) { QueryText(); } private void cx_Click(object sender, EventArgs e) { QueryText(); } 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.ColumnIndex >= 0) { lblFindCol.Text = grdShow.Columns[grdShow.CurrentCell.ColumnIndex].HeaderText; CurCol = grdShow.CurrentCell.ColumnIndex; } else { lblFindCol.Text = grdShow.Columns[1].HeaderText; CurCol = 1; } } private void txtFindInfo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { QueryText(); } } private void txtFindInfo_TextChanged(object sender, EventArgs e) { } private void grdShow_MouseClick(object sender, MouseEventArgs e) { if (grdShow.CurrentCell == null) { return; } if (e.Button == MouseButtons.Right) { if (grdShow.CurrentCell.ColumnIndex >= 0) { lblFind2Col.Text = grdShow.Columns[grdShow.CurrentCell.ColumnIndex].HeaderText; Cur2Col = grdShow.CurrentCell.ColumnIndex; } else { lblFind2Col.Text = grdShow.Columns[1].HeaderText; Cur2Col = 1; } } } private void txtFindInfo2_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { QueryText(); } } private void bclk_Click(object sender, EventArgs e) { Pub_Class.ClsPub.SaveGridView(grdShow, this.Name + this.sTitle, Pub_Class.ClsPub.AppPath); } } }