/// <summary> /// 東罐興業校正リスト取得 /// </summary> /// <remarks> /// 作成者 : nakao /// 作成日 : 2019/12/06 /// </remarks> private void GetTokanKoseiList() { DataSet dtSet = null; DataBase dataBase = null; List <SelectListItem> list = new List <SelectListItem>(); try { dataBase = new DataBase(); string sqlStr = QueryBuild.GetTokanKoseiKubun(); dataBase.ConnectDB(); dtSet = dataBase.GetDataSet(sqlStr, null); foreach (DataRow row in dtSet.Tables[0].Rows) { list.Add(new SelectListItem { Text = row["KSKBN_NM"].ToString(), Value = row["KSKBN_CD"].ToString() }); } dataBase.DisconnectDB(); } catch (Exception ex) { ConditionErrorMessage = Resources.TextResource.ErrorGetCondition; } finally { TokanKoseiList = new SelectList(list, "Value", "Text"); if (dataBase != null) { dataBase.DisconnectDB(); } if (dtSet != null) { dtSet.Dispose(); } } }