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