///------------------------------------------------------------ /// <summary> /// 発注書パターン一覧表示 </summary> /// <param name="g"> /// DataGridView</param> ///------------------------------------------------------------ private void showPattern(DataGridView g) { this.Cursor = Cursors.WaitCursor; cn = new SQLiteConnection("DataSource=" + db_file); context = new DataContext(cn); dbPtn = context.GetTable <Common.ClsOrderPattern>(); g.Rows.Clear(); int cnt = 0; foreach (var s in dbPtn.OrderBy(a => a.TokuisakiCode).ThenBy(a => a.SeqNum).ThenBy(a => a.SecondNum)) { // 得意先情報を取得:2020/04/09 ClsCsvData.ClsCsvTokuisaki tokuisaki = Utility.GetTokuisakiFromDataTable(s.TokuisakiCode.ToString().PadLeft(7, '0'), global.dtTokuisaki); if (tokuisaki.TOKUISAKI_CD == string.Empty) { continue; } // 検索得意先コード if (sCode.Text != string.Empty) { if (!tokuisaki.TOKUISAKI_CD.Contains(sCode.Text)) { continue; } } // 検索電話番号 if (sTel.Text != string.Empty) { if (!tokuisaki.TOKUISAKI_TEL.Contains(sTel.Text)) { continue; } } // 検索得意先名称 if (sName.Text != string.Empty) { if (!tokuisaki.TOKUISAKI_NM.Contains(sName.Text)) { continue; } } // 検索住所 if (sAddress.Text != string.Empty) { if (!tokuisaki.TOKUISAKI_ZYUSYO1.Contains(sAddress.Text) && !tokuisaki.TOKUISAKI_ZYUSYO2.Contains(sAddress.Text)) { continue; } } g.Rows.Add(); g[colChk, cnt].Value = true; g[colNouCode, cnt].Value = s.TokuisakiCode.ToString().Trim().PadLeft(7, '0'); g[colNouName, cnt].Value = tokuisaki.TOKUISAKI_NM; g[colPtnID, cnt].Value = s.SeqNum.ToString().PadLeft(3, '0'); g[colSecoundNum, cnt].Value = s.SecondNum.ToString(); //g[colMemo, cnt].Value = t.備考; g[colTel, cnt].Value = tokuisaki.TOKUISAKI_TEL; g[colAddress, cnt].Value = tokuisaki.TOKUISAKI_ZYUSYO1 + " " + tokuisaki.TOKUISAKI_ZYUSYO2; g[colDate, cnt].Value = s.YyMmDd; g[colID, cnt].Value = s.ID.ToString(); cnt++; g.CurrentCell = null; } this.Cursor = Cursors.Default; if (cnt == 0) { MessageBox.Show("該当する得意先はありませんでした", "確認", MessageBoxButtons.OK, MessageBoxIcon.Information); button3.Enabled = false; button4.Enabled = false; button5.Enabled = false; } else { button3.Enabled = true; button4.Enabled = true; button5.Enabled = true; } }
///----------------------------------------------------------------- /// <summary> /// 得意先クラス配列作成 : 2020/04/08</summary> /// <returns> /// ClsCsvTokuisakiクラス配列</returns> ///----------------------------------------------------------------- private ClsCsvData.ClsCsvTokuisaki[] GetTokuisakis() { button1.Text = "得意先マスターを読み込み中です・・・"; System.Threading.Thread.Sleep(10); Application.DoEvents(); Cursor = Cursors.WaitCursor; ClsCsvData.ClsCsvTokuisaki[] tokuisakis = null; try { // 得意先CSVデータ配列読み込み string[] Tk_Array = System.IO.File.ReadAllLines(Properties.Settings.Default.得意先マスター, Encoding.Default); int x = 0; int cnt = 0; int totalCnt = Tk_Array.Length; // プログレスバー初期化 progressBar2.Minimum = 0; progressBar2.Maximum = totalCnt; progressBar2.Value = 0; foreach (var item in Tk_Array) { cnt++; progressBar2.Value = cnt; string[] t = item.Split(','); // 削除フラグ string DelFlg = t[10].Replace("\"", ""); // 1行目見出し行は読み飛ばす if (DelFlg == "DELFLG") { continue; } if (DelFlg == global.FLGON) { continue; } // 有効開始日、有効終了日を検証する string cYuko_Start_Date = t[1].Replace("\"", ""); // 有効開始日付 string cYuko_End_Date = t[2].Replace("\"", ""); // 有効終了日付 int toDate = Utility.StrtoInt(DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString("D2") + DateTime.Today.Day.ToString("D2")); if (Utility.StrtoInt(cYuko_Start_Date) > toDate) { continue; } if (toDate > Utility.StrtoInt(cYuko_End_Date)) { continue; } Array.Resize(ref tokuisakis, x + 1); tokuisakis[x] = new ClsCsvData.ClsCsvTokuisaki { TOKUISAKI_CD = t[0].Replace("\"", ""), // 得意先コード YUKO_START_YMD = t[1].Replace("\"", ""), // 有効開始日付 YUKO_END_YMD = t[2].Replace("\"", ""), // 有効終了日付 TOKUISAKI_NM = t[3].Replace("\"", ""), // 得意先名称 TOKUISAKI_KANA_NM = t[4].Replace("\"", ""), // 得意先名称 TOKUISAKI_YUBIN_NO = t[5].Replace("\"", ""), // 得意先郵便番号 TOKUISAKI_ZYUSYO1 = t[6].Replace("\"", ""), // 得意先住所 TOKUISAKI_ZYUSYO2 = t[7].Replace("\"", ""), // 得意先住所 TOKUISAKI_TEL = t[8].Replace("\"", ""), // 得意先TEL TOKUISAKI_FAX = t[9].Replace("\"", ""), // 得意先FAX DELFLG = t[10].Replace("\"", "") // 削除フラグ }; x++; } System.Threading.Thread.Sleep(1000); Application.DoEvents(); } catch (Exception ex) { MessageBox.Show(ex.Message); } Cursor = Cursors.Default; return(tokuisakis); }