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