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