/// <summary>
/// 工程リスト取得
/// </summary>
/// <remarks>
/// 作成者 ： kawana
/// 作成日 ： 2019/10/24
/// </remarks>
private void GetProcessList()
{
DataSet dtSet = null;
DataBase dataBase = null;
List <SelectListItem> list = new List <SelectListItem>();
try
{
dataBase = new DataBase();
string sqlStr = QueryBuild.GetProcess(Constants.PRODUCT_JUSHIHAN);
dataBase.ConnectDB();
dtSet = dataBase.GetDataSet(sqlStr, null);
foreach (DataRow row in dtSet.Tables[0].Rows)
{
list.Add(new SelectListItem
{
Text = row["PROCESS_NM"].ToString(),
Value = row["PROCESS_CD"].ToString()
});
}
dataBase.DisconnectDB();
}
catch (Exception ex)
{
ConditionErrorMessage = Resources.TextResource.ErrorGetCondition;
}
finally
{
ProcessList = new SelectList(list, "Value", "Text");
if (dataBase != null)
{
dataBase.DisconnectDB();
}
if (dtSet != null)
{
dtSet.Dispose();
}
}
}