unote 書けば書くほどに

20230306

//完全一致検索
string strSerch = dtN.Rows[X]["NZUBAN"].ToString();

var FindZU =
dtZ.AsEnumerable().Where(i => i["ZZUBAN"].ToString().Contains(strSerch));

if (FindZU.Any())
{
DataTable dtFindZU = FindZU.CopyToDataTable();

dtN.Rows[X]["aimai"] = dtFindZU.Rows[0]["ZZUBAN"];
int FindZUCNT = dtFindZU.Rows.Count;

//在庫に完全一致が1件だけの場合
if (FindZUCNT == 1)
{
dtN.Rows[X]["aimai"] = dtFindZU.Rows[0]["ZZUBAN"];
dtFindZU = AddZaiko(dtN,dtFindZU,X,0);
}

//複数ロットがある場合
else
{
//DataView dv = dtFindZU.(true, "ZZUBAN");
//★VIEWで重複を削除して★

dtN.Rows[X]["aimai"] = dtFindZU.Rows[0]["ZZUBAN"];
dtFindZU = AddZaiko(dtN,dtFindZU,X,0);

for (int ar = 1; ar <= - 1; ar++)
{
strAimai = dtZAIZU.Rows[ar]["ZZUBAN"].ToString(); //あいまいword

DataRow addrw = dtN.NewRow();
dtN.Rows.InsertAt(addrw, X + ar);//行追加(対象行,開始位置)
dtFindZU = AddZaiko(dtN,dtFindZU,X,0);
}

X = Y + ZZCnt;//次の行位置
}

//あいまい検索
strWord = dtN.Rows[X]["word"].ToString();

var ZAIZUrow =
dtZ.AsEnumerable().Where(i => i["ZZUBAN"].ToString().Contains(strWord));

if (ZAIZUrow.Any())
{
DataTable dtZAIZU = ZAIZUrow.CopyToDataTable();

//完全一致以外を取り出す
var A = dtZaiko.AsEnumerable().Where(i => !i["ZZUBAN"].ToString().Contains(strSerch));
DataTable dtA = A.CopyToDataTable();

int zaiCNT = dtA.Rows.Count;

if (zaiCNT >= 2)
{

}

}

}