/// <summary>
/// 工場リスト取得
/// </summary>
/// <remarks>
/// 作成者 ： sesaki
/// 作成日 ： 2019/09/18
/// </remarks>
private void GetFactoryList()
{
DataSet dtSet = null;
DataBase dataBase = null;
List <SelectListItem> list = new List <SelectListItem>();
try
{
dataBase = new DataBase();
string sqlStr = QueryBuild.GetFactory();
dataBase.ConnectDB();
dtSet = dataBase.GetDataSet(sqlStr, null);
foreach (DataRow row in dtSet.Tables[0].Rows)
{
list.Add(new SelectListItem
{
Text = row["FACTORY_NAME"].ToString(),
Value = row["FACTORY_CD"].ToString()
});
}
dataBase.DisconnectDB();
}
catch (Exception ex)
{
ConditionErrorMessage = Resources.TextResource.ErrorGetCondition;
}
finally
{
FactoryList = new SelectList(list, "Value", "Text");
if (dataBase != null)
{
dataBase.DisconnectDB();
}
if (dtSet != null)
{
dtSet.Dispose();
}
}
}