/// <summary> /// M84_RIKの物理削除 /// </summary> /// <param name="m84rik">M84_RIK_Member</param> public void Delete(M84_RIK_Member m84rik) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); //削除行を特定 var ret = from x in context.M84_RIK where (x.運輸局ID == m84rik.運輸局ID) orderby x.運輸局ID select x; var m84 = ret.FirstOrDefault(); context.DeleteObject(m84); context.SaveChanges(); } }
/// <summary> /// M84_RIKの更新 /// </summary> /// <param name="m84rik">M84_RIK_Member</param> public void Update(M84_RIK_Member m84rik) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); //更新行ヲ特定 var ret = from x in context.M84_RIK where (x.運輸局ID == m84rik.運輸局ID) orderby x.運輸局ID select x; var m84 = ret.FirstOrDefault(); m84.運輸局ID = m84rik.運輸局ID; m84.登録日時 = m84rik.登録日時; m84.更新日時 = DateTime.Now; m84.運輸局名 = m84rik.運輸局名; m84.AcceptChanges(); context.SaveChanges(); } }
/// <summary> /// M84_RIKの新規追加 /// </summary> /// <param name="m84rik">M84_RIK_Member</param> public void Insert(M84_RIK_Member m84rik) { using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString())) { context.Connection.Open(); M84_RIK m84 = new M84_RIK(); m84.運輸局ID = m84rik.運輸局ID; m84.登録日時 = m84rik.登録日時; m84.更新日時 = m84rik.更新日時; m84.運輸局名 = m84rik.運輸局名; try { // newノエンティティニ対シテハAcceptChangesデ新規追加トナル context.M84_RIK.ApplyChanges(m84); context.SaveChanges(); } catch (UpdateException ex) { // PKey違反等 Console.WriteLine(ex); } } }