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;
}
