/// <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(); } } }