/// <summary>
/// M82_SEIの物理削除
/// </summary>
/// <param name="m82sei">M82_SEI_Member</param>
public void Delete(M82_SEI_Member m82sei)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//削除行を特定
var ret = from x in context.M82_SEI
where (x.請求書区分ID == m82sei.請求書区分ID)
orderby x.請求書区分ID
select x;
var m82 = ret.FirstOrDefault();
context.DeleteObject(m82);
context.SaveChanges();
}
}
/// <summary>
/// M82_SEIの更新
/// </summary>
/// <param name="m82sei">M82_SEI_Member</param>
public void Update(M82_SEI_Member m82sei)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//更新行ｦ特定
var ret = from x in context.M82_SEI
where (x.請求書区分ID == m82sei.請求書区分ID)
orderby x.請求書区分ID
select x;
var m82 = ret.FirstOrDefault();
m82.請求書区分ID = m82sei.請求書区分ID;
m82.登録日時 = m82sei.登録日時;
m82.更新日時 = DateTime.Now;
m82.請求書名 = m82sei.請求書名;
m82.AcceptChanges();
context.SaveChanges();
}
}
/// <summary>
/// M82_SEIの新規追加
/// </summary>
/// <param name="m82sei">M82_SEI_Member</param>
public void Insert(M82_SEI_Member m82sei)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
M82_SEI m82 = new M82_SEI();
m82.請求書区分ID = m82sei.請求書区分ID;
m82.登録日時 = m82sei.登録日時;
m82.更新日時 = m82sei.更新日時;
m82.請求書名 = m82sei.請求書名;
try
{
// newﾉｴﾝﾃｨﾃｨﾆ対ｼﾃﾊAcceptChangesﾃﾞ新規追加ﾄﾅﾙ
context.M82_SEI.ApplyChanges(m82);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
