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