private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); dgv_Common.Tag = "Sys_RoleGridViewSet"; LoadData(); }
/// <summary> /// 根据菜单添加结构到功能普通树 /// </summary> private void AddFunctionTreeViewNodes() { //string strSql = "SELECT FBH,GNBH,replace(GNMC,'&','') as GNMC FROM SYS_FUNCTION where GNMC<>'-' order by GNBH"; //string strSql = "SELECT sParentFunctionID,sFunctionID,replace(sFunctionName,'&','') as sFunctionName FROM SYS_MainFunctions where sFunctionName<>'-' order by sFunctionID"; string strSql = "SELECT sMenuGroupID,sFunctionID,sFunctionName FROM SYS_Menu order by sSortBy"; DataTable DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); TV.ReadNodesFromDataTable(this.treeViewFunction, DT, false, 0, 1, 2); DT.Clear(); GC.Collect(); }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); gc_UpLoad.Tag = "SYS_DOC"; LoadData(); this.gv_UpLoad.OptionsView.ColumnAutoWidth = false; ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_UpLoad); }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); dgv_Common.Tag = "Bas_BoardQualityPrice"; dgv_Common.AllowUserToAddRows = false; dgv_Customer.Tag = "Bas_Customer"; string CuststrSql = "select '通用' sCustID,'针对所有客户通用' sCustName Union All select sCustID,sCustName from Bas_Customer"; DT_cust = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(CuststrSql).Tables[0]; dgv_Customer.AllowUserToAddRows = false; dgv_Customer.DataSource = DT_cust; ZX.Controls.DataGridViewC.GetDatagridviewFromDB(this.Text + '-' + dgv_Customer.Name, "通用", this.dgv_Customer); LoadData(); }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); gc_Authority.Tag = "SYS_User_Authority"; gc_Role.Tag = "SYS_User_Info"; string strSqlRole = "select distinct(sRole) from SYS_User_Info"; DataTable DTRole = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSqlRole).Tables[0]; this.gc_Role.DataSource = DTRole; ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_Role); this.gv_Authority.OptionsView.ColumnAutoWidth = false; ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_Authority); }
private void button1_Click(object sender, EventArgs e) { ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); TV.SetTreeViewTag(this.treeView1); DataTable DT = TV.SaveToDataTable(this.treeView1, "FBH", "GNBH", "GNMC"); DT.TableName = "SYS_FUNCTION"; if (DT.Rows.Count > 0) { DataColumn DC1 = new DataColumn("WJMC"); DC1.MaxLength = 100; DataColumn DC2 = new DataColumn("MMKJ"); DC1.MaxLength = 200; DataColumn DC3 = new DataColumn("WJICO"); DC1.MaxLength = 500; DataColumn DC4 = new DataColumn("HELPPATH"); DC1.MaxLength = 200; DT.Columns.AddRange(new DataColumn[] { DC1, DC2, DC3, DC4 }); for (int i = 0; i < DT.Rows.Count; i++) { //文本字串格式 //功能菜单名称$功能程序集文件名$功能命名空间加类名$功能图标$功能帮助 string[] SplitStr = DT.Rows[i]["GNMC"].ToString().Split('$'); DT.Rows[i]["GNMC"] = SplitStr[0]; DT.Rows[i]["WJMC"] = SplitStr[1]; DT.Rows[i]["MMKJ"] = SplitStr[2]; DT.Rows[i]["WJICO"] = SplitStr[3]; DT.Rows[i]["HELPPATH"] = SplitStr[4]; } DT.AcceptChanges(); if (SystemClass.AdoNetOperation.DataTableInputDataBase(SystemClass.ConnectString.GetConnectionString(), DT, "SYS_FUNCTION", false) == true) { ZX.Class.Log.WriteLog.Write("ZXSystem.Function.FunManage", "SaveFunctionNode", "保存功能列表到数据库成功", ZX.Class.Log.NormalLogType.InfoLog); } else { SystemClass.MessageBoxShow.ShowMessage("保存功能列表到数据库失败!"); ZX.Class.Log.WriteLog.Write("ZXSystem.Function.FunManage", "SaveFunctionNode", "保存功能列表到数据库失败", ZX.Class.Log.NormalLogType.WarnLog); } } }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); //gc_Client.Tag = "Bas_Client"; gc_CustomerMaster.Tag = "Bas_Customer"; gc_CustomerAddress.Tag = "Bas_CustomerAddress"; gc_CustomerContact.Tag = "Bas_CustomerContact"; LoadData(); //this.gv_Client.OptionsView.ColumnAutoWidth = false; //ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_Client); this.gv_CustomerMaster.OptionsView.ColumnAutoWidth = false; ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_CustomerMaster); gv_CustomerMaster.OptionsView.ShowAutoFilterRow = true; tabPage1.Selected = true; }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); // dgv_Customer.AllowUserToAddRows = false; gridControlEx1.Tag = "Bas_Customer"; gridView1.OptionsView.ColumnAutoWidth = false; LoadData(); ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gridControlEx1); // this. gridView1.Columns[n].BestFit(); }
private void LoadData() { string strSql = "select * from Bas_Area"; //DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; //this.gc_Customer.DataSource = DT; DT= ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; //BindRoot(); //treeList1.DataSource = DT; //treeList1.KeyFieldName = "sAreaID";//设置主键 //treeList1.ParentFieldName = "sParentAreaID";//设置父级主键 //treeList1.RootValue = "";//顶级树结点的值 //TreeListFillInfo(); ZX.Controls.TreeViewC tv = new ZX.Controls.TreeViewC(); tv.ReadNodesFromDataTable(this.treeView1, DT, false, 1, 0, 2); }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); //gc_Customer.Tag = "Bas_Customer"; LoadData(); //this.gv_Customer.OptionsView.ColumnAutoWidth = false; //ZX.Controls.GridControlEx.GetDatagridviewFromDB("通用", gc_Customer); //treeList1.OptionsView.ShowCheckBoxes = true; }
private void FindNodeByTag(string sNodeTag) { treeView1.Focus(); ZX.Controls.TreeViewC tv = new ZX.Controls.TreeViewC(); TreeNode[] TempTreeNode = tv.FindTreeNodeFromTag(this.treeView1, sNodeTag); //iTreeNodeIndex = TempTreeNode.Length; if (iTreeNodeIndex < TempTreeNode.Length) { this.treeView1.SelectedNode = TempTreeNode[iTreeNodeIndex]; iTreeNodeIndex += 1; } else { iTreeNodeIndex = 0; } }
private void Form_Main_Load(object sender, EventArgs e) { ZX.Win.FunctionParameter FP = (ZX.Win.FunctionParameter)this.Tag; ; DataGridView HRDG = FP.MyGridView; ZX.Win.SetToolBarIcon SBI = new ZX.Win.SetToolBarIcon(); SBI.SetImage(Application.StartupPath + @"\Images\TooBarIco", this.ToolStrip1, FP.ToolStripitemDisplayStyle); ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); dgv_Common.Tag = "Bas_PartType"; dgv_Common.AllowUserToAddRows = false; gc_Common.Tag = "Bas_PartType"; LoadData(); ZX.Controls.DataGridViewEx.GridControlEx.GetDatagridviewFromDB("通用", gc_Common); }
/// <summary> /// 根据菜单添加结构到功能普通树 /// </summary> private void AddTreeViewHelpNodes() { string strSql = "SELECT sMenugroupID,sFunctionID,replace(sFunctionName,'&','') as sFunctionName FROM SYS_Menu where sFunctionName<>'-' order by smenugroupid,ssortby"; DataTable DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; #region"用普通的树TreeView控件" ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); TV.ReadNodesFromDataTable(this.treeViewHelp, DT, false, 0, 1, 2); #endregion #region"用HR的树控件" //FromMenuAddNodeToTreeView(); #endregion DT.Clear(); GC.Collect(); }