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