internal System.Collections.IEnumerable setQuery(String selectedTable)
{
tacpmsEntities ent = new tacpmsEntities();
Type myType = typeof(tacpmsEntities);
PropertyInfo myPropertyInfo = myType.GetProperty(selectedTable);
Console.WriteLine("~~~~~~~~~~~~~~~~~~~~~~~~~~~");
Console.WriteLine(myPropertyInfo.GetValue(ent, null));
Console.WriteLine("~~~~~~~~~~~~~~~~~~~~~~~~~~~");
Console.WriteLine(ent.mst_cd);
Console.WriteLine("~~~~~~~~~~~~~~~~~~~~~~~~~~~");
//DataSet dataSet = new DataSet();
//DataTable dataTable = dataSet.Tables[selectedTable];
//Console.WriteLine(selectedTable);
//Console.WriteLine("~~~~~~~~~~~~~~~~~~~~~~~~~~~");
var query =
from dt in ent.mst_department
select dt;
return(query.ToList());
}
public ViewModel()
{
Console.WriteLine("--------------------");
Console.WriteLine("checkPoint");
Console.WriteLine("--------------------");
try
{
// エンティティをインスタンス化
tacpmsEntities ent = new tacpmsEntities();
// エンティティインスタンスからプロパティを取得
PropertyInfo[] infoArray = ent.GetType().GetProperties();
this.ComboList = new List <TableComboItem>();
// テーブルプロパティのみを抽出
foreach (PropertyInfo info in infoArray)
{
if (info.PropertyType.Name.Equals("ObjectSet`1"))
{
TableComboItem tci = new TableComboItem();
tci.Id = info.GetHashCode().ToString();
tci.Name = info.Name;
this.ComboList.Add(tci);
}
}
Console.WriteLine("--------------------");
Console.WriteLine("checkPoint2");
Console.WriteLine("--------------------");
}
catch (Exception ex)
{
Console.WriteLine("--------------------");
Console.WriteLine(ex.ToString());
Console.WriteLine("--------------------");
}
}
