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