/// <summary>
/// 担当者リスト取得
/// </summary>
/// <remarks>
/// 作成者 ： nakao
/// 作成日 ： 2019/09/01
/// </remarks>
private void GetEmployeeList()
{
DataSet dtSet = null;
DataBase dataBase = null;
List<SelectListItem> list = new List<SelectListItem>();
try
{
dataBase = new DataBase();
string sqlStr = QueryBuild.GetEmployee();
dataBase.ConnectDB();
dtSet = dataBase.GetDataSet(sqlStr, null);
foreach (DataRow row in dtSet.Tables[0].Rows)
{
list.Add(new SelectListItem
{
Text = row["EMPLOYEE_NM"].ToString(),
Value = row["EMPLOYEE_CD"].ToString()
});
}
dataBase.DisconnectDB();
}
catch (Exception ex)
{
}
finally
{
EmployeeList = new SelectList(list, "Value", "Text");
if (dataBase != null)
{
dataBase.DisconnectDB();
}
if (dtSet != null)
{
dtSet.Dispose();
}
}
}