/// <summary> /// T06_KYUSの新規追加 /// </summary> /// <param name="t06kyus">T06_KYUS_Member</param> public void Insert(T06_KYUS_Member t06kyus) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); T06_KYUS t06 = new T06_KYUS(); t06.車輌ID = t06kyus.車輌ID; t06.休車開始日付 = t06kyus.休車開始日付; t06.休車終了日付 = t06kyus.休車終了日付; t06.明細区分 = t06kyus.明細区分; t06.車輌番号 = t06kyus.車輌番号; t06.休車事由 = t06kyus.休車事由; try { // newのエンティティに対してはAcceptChangesで新規追加となる context.T06_KYUS.ApplyChanges(t06); context.SaveChanges(); } catch (UpdateException ex) { // PKey違反等 Console.WriteLine(ex); } } }
/// <summary> /// T06_KYUSの更新 /// </summary> /// <param name="t06kyus">T06_KYUS_Member</param> public void Update(T06_KYUS_Member t06kyus) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); //更新行を特定 var ret = from x in context.T06_KYUS where x.車輌ID == t06kyus.車輌ID && x.休車開始日付 == t06kyus.休車開始日付 orderby x.車輌ID, x.休車開始日付 select x; var t06 = ret.FirstOrDefault(); t06.車輌ID = t06kyus.車輌ID; t06.休車開始日付 = t06kyus.休車開始日付; t06.休車終了日付 = t06kyus.休車終了日付; t06.明細区分 = t06kyus.明細区分; t06.車輌番号 = t06kyus.車輌番号; t06.休車事由 = t06kyus.休車事由; t06.AcceptChanges(); context.SaveChanges(); } }
/// <summary> /// T06_KYUSの物理削除 /// </summary> /// <param name="t06kyus">T06_KYUS_Member</param> public void Delete(T06_KYUS_Member t06kyus) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); //削除行を特定 var ret = from x in context.T06_KYUS where x.車輌ID == t06kyus.車輌ID && x.休車開始日付 == t06kyus.休車開始日付 orderby x.車輌ID, x.休車開始日付 select x; var t06 = ret.FirstOrDefault(); context.DeleteObject(t06); context.SaveChanges(); } }