public static string GetQuery(string PgmName, string Columns, string _Where) { string RtValue = ""; QueryDataForm _qyFrom = null; _qyFrom = new QueryDataForm(PgmName, Columns, _Where); // _qyFrom.StartPosition = FormStartPosition.Manual; // _qyFrom.Location = new Point(Cursor.Position.X, Cursor.Position.Y); // _qyFrom.TopMost = true; if (_qyFrom.ShowDialog() == DialogResult.Yes) { RtValue = _qyFrom.ID; _qyFrom.Dispose(); } return(RtValue); }
public static Dictionary <string, object> GetQuery1(string PgmName, string Columns, string _Where) { Dictionary <string, object> _ht = new Dictionary <string, object>(); if (PgmName == "Employee_MutSelect" || PgmName == "Item") { string _PgmName = PgmName; bool Mutselect = false; if (PgmName == "Employee_MutSelect") { _PgmName = "Employee"; Mutselect = true; } QueryTreeDataForm _qyFrom = null; _qyFrom = new QueryTreeDataForm(_PgmName, Columns, _Where, Mutselect); //_qyFrom.StartPosition = FormStartPosition.Manual; //_qyFrom.Location = new Point(Cursor.Position.X, Cursor.Position.Y); // _qyFrom.TopMost = true; if (_qyFrom.ShowDialog() == DialogResult.Yes) { _ht["ID"] = _qyFrom.ID; _ht["DESC"] = _qyFrom.DESC; _qyFrom.Dispose(); } } else { QueryDataForm _qyFrom = null; _qyFrom = new QueryDataForm(PgmName, Columns, _Where); //_qyFrom.StartPosition = FormStartPosition.Manual; //_qyFrom.Location = new Point(Cursor.Position.X, Cursor.Position.Y); //_qyFrom.TopMost = true; if (_qyFrom.ShowDialog() == DialogResult.Yes) { _ht["ID"] = _qyFrom.ID; _ht["DESC"] = _qyFrom.DESC; _qyFrom.Dispose(); } } return(_ht); }