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