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