private void chiamaFormClass(string filtro, Class_SelectionManager CSM)
{
MetaSorting.FilterLocked = true;
MetaSorting.SearchEnabled = false;
MetaSorting.MainSelectionEnabled = true;
MetaSorting.StartFilter = filtro;
MetaSorting.ExtraParameter = filtro;
//if ((currfilter_upb == null) || (currfilter_upb == "")) return;
string edittype = "tree";
bool res = MetaSorting.Edit(this, edittype, true);
if (!res)
{
return;
}
DataRow Selected = MetaSorting.LastSelectedRow;
CSM.SelectRow(Selected);
}
private void btnCodice_Click(Class_SelectionManager CSM)
{
string filterAll = QHS.CmpEq("idsorkind", CSM.idsorkind);
chiamaFormClass(filterAll, CSM);
}
public FrmSelectDetailsFromStock(MetaData Meta, string filtersql, DataSet DS)
{
InitializeComponent();
this.Meta = Meta;
this.Conn = Meta.Conn;
this.Disp = Meta.Dispatcher;
this.filtersql = filtersql;
this.DS = DS;
QHC = new CQueryHelper();
QHS = Meta.Conn.GetQueryHelper();
// Magazzino
DataTable store = Conn.CreateTableByName("store", "*", false);
D = new DataSet();
D.Tables.Add(store);
Conn.RUN_SELECT_INTO_TABLE(store, "description", filtersql, null, true);
cmbMagazzino.DataSource = store;
cmbMagazzino.ValueMember = "idstore";
cmbMagazzino.DisplayMember = "description";
HelpForm.SetComboBoxValue(cmbMagazzino, store.Rows[0]["idstore"]);
cmbMagazzino.Enabled = false;
// Responsabile
DataTable manager = Conn.CreateTableByName("manager", "*", false);
D.Tables.Add(manager);
GetData.MarkToAddBlankRow(manager);
GetData.Add_Blank_Row(manager);
Conn.RUN_SELECT_INTO_TABLE(manager, "title", null, null, true);
cmbResponsabile.DataSource = manager;
cmbResponsabile.ValueMember = "idman";
cmbResponsabile.DisplayMember = "title";
Conn.DeleteAllUnselectable(manager);
MetaSorting = Disp.Get("sorting");
FormInit();
DD = new DataSet("a");
Sorting1 = Conn.CreateTableByName("sorting", "*");
Sorting1.TableName = "sorting1";
Sorting2 = Conn.CreateTableByName("sorting", "*");
Sorting2.TableName = "sorting2";
Sorting3 = Conn.CreateTableByName("sorting", "*");
Sorting3.TableName = "sorting3";
DD.Tables.Add(Sorting1);
DD.Tables.Add(Sorting2);
DD.Tables.Add(Sorting3);
DD.EnforceConstraints = false;
DataAccess.SetTableForReading(Sorting1, "sorting");
DataAccess.SetTableForReading(Sorting2, "sorting");
DataAccess.SetTableForReading(Sorting3, "sorting");
string filter = "(ayear=" + QueryCreator.quotedstrvalue(Meta.GetSys("esercizio"), true) + ")";
DataTable tExpSetup = Meta.Conn.RUN_SELECT("config", "*", null,
filter, null, null, true);
if ((tExpSetup != null) && (tExpSetup.Rows.Count > 0))
{
DataRow R = tExpSetup.Rows[0];
string idsorkind1 = R["idsortingkind1"].ToString();
string idsorkind2 = R["idsortingkind2"].ToString();
string idsorkind3 = R["idsortingkind3"].ToString();
SetGBoxClass(1, idsorkind1);
SetGBoxClass(2, idsorkind2);
SetGBoxClass(3, idsorkind3);
if (idsorkind3 == "")
{
grpAnalitico.Size = new System.Drawing.Size(366, 200);
}
if (idsorkind2 + idsorkind3 == "")
{
grpAnalitico.Size = new System.Drawing.Size(366, 100);
}
if (idsorkind1 + idsorkind2 + idsorkind3 == "")
{
grpAnalitico.Visible = false;
}
if (idsorkind1 != "")
{
CSM1 = new Class_SelectionManager(Meta, txtCodice1, txtDenom1, R["idsortingkind1"]);
}
if (idsorkind2 != "")
{
CSM2 = new Class_SelectionManager(Meta, txtCodice2, txtDenom2, R["idsortingkind2"]);
}
if (idsorkind3 != "")
{
CSM3 = new Class_SelectionManager(Meta, txtCodice3, txtDenom3, R["idsortingkind3"]);
}
}
}