/// ---------------------------------------------------------------
/// <summary>
/// 未照合連番テーブル更新 </summary>
/// <param name="dt">
/// 日付</param>
/// <returns>
/// 該当日付の連番</returns>
/// ---------------------------------------------------------------
public void setUnNumber(DateTime dt, int sNum)
{
DSLGDataSet dts = new DSLGDataSet();
DSLGDataSetTableAdapters.未照合連番TableAdapter adp = new DSLGDataSetTableAdapters.未照合連番TableAdapter();
adp.Fill(dts.未照合連番);
if (dts.未照合連番.Any(a => a.日付 == dt))
{
// 更新
DSLGDataSet.未照合連番Row r = dts.未照合連番.Single(a => a.日付 == dt);
r.連番 = sNum;
r.更新年月日 = DateTime.Now;
}
else
{
// 新規登録
DSLGDataSet.未照合連番Row r = dts.未照合連番.New未照合連番Row();
r.日付 = dt;
r.連番 = sNum;
r.更新年月日 = DateTime.Now;
dts.未照合連番.Add未照合連番Row(r);
}
adp.Update(dts.未照合連番);
}
/// ---------------------------------------------------------------
/// <summary>
/// 未照合画像日別連番取得 </summary>
/// <param name="dt">
/// 日付</param>
/// <returns>
/// 該当日付の連番</returns>
/// ---------------------------------------------------------------
public int getUnNumber(DateTime dt)
{
DSLGDataSet dts = new DSLGDataSet();
DSLGDataSetTableAdapters.未照合連番TableAdapter adp = new DSLGDataSetTableAdapters.未照合連番TableAdapter();
adp.Fill(dts.未照合連番);
int result = 0;
foreach (var t in dts.未照合連番.Where(a => a.日付 == dt))
{
result = t.連番;
}
;
return(result);
}
