/// <summary> /// 検索結果取得 /// </summary> /// <remarks> /// 作成者 : sesaki /// 作成日 : 2019/11/13 /// </remarks> public void GetSearchResults() { // 検索条件が正しければ検索実施 if (Condition.ValidateSearch() == false) { return; } DataSet dtSet = null; DataBase dataBase = null; try { long totalCount = 0; SearchResults = new List <SearchResult>(); List <object> paraList = new List <object>(); // 得意先:東罐興業 if (GurabiaCustomer.IsTokan(Condition.Customer)) { string queryStr = QueryBuild.GetGurabiaSearchTokan(Condition, ref paraList); dataBase = new DataBase(); dataBase.ConnectDB(); dtSet = dataBase.GetDataSet(queryStr, paraList.ToArray()); // クエリ実行 totalCount = dtSet.Tables[0].Rows.Count; // 全体件数 foreach (DataRow row in dtSet.Tables[0].Rows) { SearchResult sr = new SearchResult(row); if (Condition.OutPut_Chk || sr.CheckOutPut(Condition.Process)) { SearchResults.Add(sr); } } ResultCount = SearchResults.Count.ToString() + "/" + totalCount.ToString(); dataBase.DisconnectDB(); } // 得意先:東洋製罐 else { string queryStr = QueryBuild.GetGurabiaSearchToyo(Condition, ref paraList); dataBase = new DataBase(); dataBase.ConnectDB(); dtSet = dataBase.GetDataSet(queryStr, paraList.ToArray()); // クエリ実行 totalCount = dtSet.Tables[0].Rows.Count; // 全体件数 foreach (DataRow row in dtSet.Tables[0].Rows) { SearchResult sr = new SearchResult(row); if (Condition.OutPut_Chk || sr.CheckOutPut(Condition.Process)) { SearchResults.Add(sr); } } ResultCount = SearchResults.Count.ToString() + "/" + totalCount.ToString(); dataBase.DisconnectDB(); } } catch (Exception ex) { SearchErrorMessage = Resources.TextResource.ErrorGetSearchResult; } finally { if (dataBase != null) { dataBase.DisconnectDB(); } if (dtSet != null) { dtSet.Dispose(); } } }