public FrmUserFunc(BindingList <QueryBuilder.Node> nodes, QueryBuilder.Node node) { InitializeComponent(); _Nodes = nodes; if (node != null) { _Node = node; btnNew.Visible = true; txtName.Enabled = false; int vitri = -1; for (int i = 0; i < nodes.Count; i++) { if (node.Code == nodes[i].Code) { vitri = i; } } if (vitri != -1) { nodes.RemoveAt(vitri); } } else { btnNew.Visible = false; } }
private void dgvSelectNodes_MouseDown(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Left) { if (dgvSelectNodes.CurrentRow != null) { QueryBuilder.Node x = (QueryBuilder.Node)dgvSelectNodes.CurrentRow.DataRow; if (x != null) { DoDragDrop("[" + x.MyCode + "]", DragDropEffects.All); } } } }
private void btSave_Click(object sender, EventArgs e) { DialogResult = DialogResult.OK; string type = ""; if (rdDate.Checked) { type = "SD"; } else if (rdNum.Checked) { type = "N"; } _Node = new QueryBuilder.Node("", txtName.Text, txtName.Text, type, ""); _Node.Expresstion = txtMain.Text; Close(); }
private void btSave_Click(object sender, EventArgs e) { DialogResult = DialogResult.OK; string type = ""; if (rdDate.Checked) { type = "SDN"; } else if (rdNum.Checked) { type = "N"; } else if (rbD.Checked) { type = "D"; } QueryBuilder.Node _Node = new QueryBuilder.Node("", "__" + txtName.Text, "__" + txtName.Text, type, ""); //_Node.Expresstion = txtMain.Text; _Filter = new QueryBuilder.Filter(_Node); _Filter.FilterFrom = _Filter.ValueFrom = txtMain.Text; Close(); }
private void frmFilterSelect_Load(object sender, EventArgs e) { QueryBuilder.Node node = _sqlBuidler.Filters[_indexFilter].Node; if (node.FType == "SPN") { _sqlBuidler.SelectedNodes.Clear(); _sqlBuidler.SelectedNodes.Add(_sqlBuidler.Filters[_indexFilter].Node); _sqlBuidler.Filters.RemoveAt(_indexFilter); try { _sqlBuidler.SelectedNodes[0].Agregate = "Min"; object min = _sqlBuidler.BuildObject("", _connectString); _sqlBuidler.SelectedNodes[0].Agregate = "Max"; object max = _sqlBuidler.BuildObject("", _connectString); int minyear = DateTime.Now.Year - 2; int maxyear = DateTime.Now.Year + 2; if (min != null) { minyear = ((int)min) / 1000; } if (max != null) { maxyear = ((int)max) / 1000; } DataTable dt = new DataTable(); DataColumn[] col = new DataColumn[] { new DataColumn("SELECTED", typeof(bool)), new DataColumn("VALUE"), new DataColumn("Lookup"), new DataColumn("Description") }; dt.Columns.AddRange(col); for (int i = minyear; i <= maxyear; i++) { for (int j = 1; j < 13; j++) { DataRow row = dt.NewRow(); row["SELECTED"] = false; row["VALUE"] = i.ToString("0000") + j.ToString("000"); row["Lookup"] = i.ToString("0000"); row["Description"] = j.ToString("000") + "/" + i.ToString("0000"); dt.Rows.Add(row); } } dgvSelect.RootTable.Columns["VALUE"].Caption = "Code"; dgvSelect.DataSource = dt; } catch (Exception ex) { } } else { _sqlBuidler.SelectedNodes.Clear(); _sqlBuidler.SelectedNodes.Add(_sqlBuidler.Filters[_indexFilter].Node); if (_sqlBuidler.Filters[_indexFilter].Node.NodeDesc != "") { QueryBuilder.Node nodeNew = new QueryBuilder.Node(_sqlBuidler.Filters[_indexFilter].Node.NodeDesc, "Description"); nodeNew.AddMeToParent(_sqlBuidler.Filters[_indexFilter].Node.MyFamily); _sqlBuidler.SelectedNodes.Add(nodeNew); } else { dgvSelect.RootTable.Columns["Description"].Visible = false; } _sqlBuidler.Filters.RemoveAt(_indexFilter); _sqlBuidler.StrConnectDes = _connectString; try { DataTable dt = _sqlBuidler.BuildDataTable(""); dgvSelect.RootTable.Columns["VALUE"].Caption = dt.Columns[0].ColumnName; dgvSelect.RootTable.Columns["VALUE"].DataMember = dt.Columns[0].ColumnName; if (dt.Columns.Count == 2) { dgvSelect.RootTable.Columns["Description"].Caption = dt.Columns[1].ColumnName; dgvSelect.RootTable.Columns["Description"].DataMember = dt.Columns[1].ColumnName; } //dt.Columns[0].ColumnName = "VALUE"; DataColumn col = new DataColumn("SELECTED", typeof(bool)); dt.Columns.Add(col); foreach (DataRow row in dt.Rows) { row["SELECTED"] = false; } dgvSelect.DataSource = dt; } catch (Exception ex) { } } dgvSelect.RootTable.Columns["VALUE"].Width = 100; //dgvSelect.RootTable.Columns["VALUE"].ReadOnly = true; txtFilterFrom.Text = _filterFrom; txtFilterTo.Text = _filterTo; }