public static void DropDown(DataGridView gv, Int32 intNAVID, tblAppColumns tbl, RexrothData.RexrothEntities db, Int32 intApp, Int32 intAPPID, Int32 intASID)
{
DataGridViewComboBoxColumnCredo gvCbo = new DataGridViewComboBoxColumnCredo();
switch (tbl.APCOID)
{
//case 2:
// var qry = new Dictionary<int, string>();
// try
// {
// var q = db.p_DropDown(intNAVID, tbl.APC_Desc, "", intASID).ToList();
// qry = q.ToDictionary(pl => pl.ID, pl => pl.Display);
// }
// catch (Exception ex)
// {
// }
// if (qry.Count > 0)
// {
// gvCbo.DataSource = qry.ToList();
// }
// break;
//case 21:
// var qry2 = new Dictionary<string, string>();
// try
// {
// List<p_DropDownFilter_Result> q = db.p_DropDownFilter(intNAVID, tbl.APC_Desc, "", tbl.APC_QueryField, intASID).ToList<p_DropDownFilter_Result>();
// qry2 = q.ToDictionary(pl => pl.ID, pl => pl.Display);
// }
// catch (Exception ex)
// {
// }
// if (qry2.Count > 0)
// {
// gvCbo.DataSource = qry2.ToList();
// }
// break;
//case 25:
// var qry25 = new Dictionary<string, string>();
// try
// {
// List<p_DropDownFilter_Result> q = db.p_DropDownFilter(intNAVID, tbl.APC_Desc, "", tbl.APC_QueryField, intASID).ToList<p_DropDownFilter_Result>();
// qry25 = q.ToDictionary(pl => pl.ID, pl => pl.Display);
// }
// catch (Exception ex)
// {
// }
// if (qry25.Count > 0)
// {
// gvCbo.DataSource = qry25.ToList();
// }
// break;
}
string strName = tbl.APC_Desc;
gvCbo.DisplayMember = "Value";
gvCbo.ValueMember = "Key";
gvCbo.FlatStyle = FlatStyle.Flat;
gvCbo.Name = tbl.APC_Desc;
gvCbo.HeaderText = tbl.APC_Name;
gvCbo.DataPropertyFilterName = tbl.APC_QueryField;
gvCbo.DataPropertyName = strName;
gvCbo.Tag = tbl.APCID.ToString();
gvCbo.ReadOnly = Convert.ToBoolean(tbl.APC_ReadOnly);
if (tbl.APC_Width == 0)
{
gvCbo.Visible = false;
}
else
{
gvCbo.Width = tbl.APC_Width;
}
gvCbo.AutoComplete = true;
gv.Columns.Add(gvCbo);
}
public static void DropDown(DataGridView gv, Int32 intNAVID, tblAppColumns tbl, HRLData.HRLEntities db, Int32 intApp, Int32 intAPPID, Int32 intASID, Boolean fShowArrow)
{
DataGridViewComboBoxColumnCredo gvCbo = new DataGridViewComboBoxColumnCredo();
switch (tbl.APCOID)
{
case 2:
var qry = new Dictionary <int, string>();
try
{
List <p_DropDown_Result> q = db.p_DropDown(intAPPID, intNAVID, tbl.APC_Desc, "", intASID).ToList <p_DropDown_Result>();
qry = q.ToDictionary(pl => pl.ID, pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry.Count > 0)
{
gvCbo.DataSource = qry.ToList();
}
break;
case 21:
var qry2 = new Dictionary <string, string>();
try
{
List <p_DropDownFilter_Result> q = db.p_DropDownFilter(intNAVID, tbl.APC_Desc, "", tbl.APC_QueryField, intASID).ToList <p_DropDownFilter_Result>();
qry2 = q.ToDictionary(pl => pl.ID, pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry2.Count > 0)
{
gvCbo.DataSource = qry2.ToList();
}
break;
case 25:
var qry25 = new Dictionary <string, string>();
try
{
string strSQL = "p_DropDownFilter " + intNAVID.ToString() + ", '" + tbl.APC_Desc + "', '','" + tbl.APC_QueryField + "', " + intASID.ToString();
DataSet ds = clsDAL.ProcessSQL(strSQL, "app");
//var q = (from myRow in ds.Tables[0].AsEnumerable()
// select new {ID = myRow.Field<Int32>("ID"), Display = myRow.Field<string>("Display")}).ToList();
var q = (from myRow in ds.Tables[0].AsEnumerable()
select new { ID = myRow.Field <string>("ID"), Display = myRow.Field <string>("Display") }).ToList();
qry25 = q.ToDictionary(pl => pl.ID.ToString(), pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry25.Count > 0)
{
gvCbo.DataSource = qry25.ToList();
}
break;
case 28:
var qry28 = new Dictionary <int, string>();
try
{
qry28 = DropDownTBL(intAPPID, intNAVID, tbl.APC_Desc, "", intASID);
//List<p_DropDown_Result> q = db.p_DropDown(intAPPID, intNAVID, tbl.APC_Desc, "", intASID).ToList<p_DropDown_Result>();
//qry28 = q.ToDictionary(pl => pl.ID, pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry28.Count > 0)
{
gvCbo.DataSource = qry28.ToList();
}
break;
case 31:
var qry31 = new Dictionary <int, string>();
try
{
List <p_DropDown_Result> q31 = db.p_DropDown(intAPPID, intNAVID, tbl.APC_Desc, "", intASID).ToList <p_DropDown_Result>();
try
{
q31 = clsDropDownUtil.AddDropItem(q31, "-");
}
catch (Exception ex2)
{
}
qry31 = q31.ToDictionary(pl => pl.ID, pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry31.Count > 0)
{
gvCbo.DataSource = qry31.ToList();
}
break;
case 37:
var qry37 = new Dictionary <int, string>();
try
{
List <p_DropDown_Result> q = db.p_DropDown(intAPPID, intNAVID, tbl.APC_Desc, "", intASID).ToList <p_DropDown_Result>();
qry37 = q.ToDictionary(pl => pl.ID, pl => pl.Display);
}
catch (Exception ex)
{
}
if (qry37.Count > 0)
{
gvCbo.DataSource = qry37.ToList();
}
break;
}
string strName = tbl.APC_Desc;
gvCbo.DisplayMember = "Value";
gvCbo.ValueMember = "Key";
gvCbo.FlatStyle = FlatStyle.Flat;
gvCbo.Name = tbl.APC_Desc;
gvCbo.HeaderText = tbl.APC_Name;
gvCbo.DataPropertyFilterName = tbl.APC_QueryField;
gvCbo.DataPropertyName = strName;
gvCbo.Tag = tbl.APCID.ToString();
gvCbo.ReadOnly = Convert.ToBoolean(tbl.APC_ReadOnly);
if (fShowArrow == false)
{
gvCbo.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
}
if (tbl.APC_Width == 0)
{
gvCbo.Visible = false;
}
else
{
gvCbo.Width = tbl.APC_Width;
}
gvCbo.SortMode = DataGridViewColumnSortMode.Automatic;
gvCbo.AutoComplete = true;
gv.Columns.Add(gvCbo);
}