/// <summary>
/// T03_KTRNの新規追加
/// </summary>
/// <param name="t03ktrn">T03_KTRN_Member</param>
public void Insert(T03_KTRN_Member t03ktrn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
T03_KTRN t03 = new T03_KTRN();
t03.明細番号 = t03ktrn.明細番号;
t03.明細行 = t03ktrn.明細行;
t03.登録日時 = DateTime.Now;
t03.更新日時 = DateTime.Now;
t03.明細区分 = t03ktrn.明細区分;
t03.入力区分 = t03ktrn.入力区分;
t03.経費発生日 = t03ktrn.経費発生日;
t03.車輌ID = t03ktrn.車輌ID;
t03.車輌番号 = t03ktrn.車輌番号;
t03.乗務員KEY = t03ktrn.乗務員ID;
t03.支払先KEY = t03ktrn.支払先ID;
t03.自社部門ID = t03ktrn.自社部門ID;
t03.経費項目ID = t03ktrn.経費項目ID;
t03.経費補助名称 = t03ktrn.経費補助名称;
t03.単価 = t03ktrn.単価;
t03.内軽油税分 = t03ktrn.内軽油税分;
t03.数量 = t03ktrn.数量;
t03.金額 = t03ktrn.金額;
t03.収支区分 = t03ktrn.収支区分;
t03.摘要ID = t03ktrn.摘要ID;
t03.摘要名 = t03ktrn.摘要名;
//未更新フィールド
//入力者ID = t03ktrn.入力者ID;
try
{
// newのエンティティに対してはAcceptChangesで新規追加となる
context.T03_KTRN.ApplyChanges(t03);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
/// <summary>
/// T03_KTRNの物理削除
/// </summary>
/// <param name="t03ktrn">T03_KTRN_Member</param>
public void Delete(T03_KTRN_Member t03ktrn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//削除行を特定
var ret = from x in context.T03_KTRN
where x.明細番号 == t03ktrn.明細番号 &&
x.明細行 == t03ktrn.明細行
orderby x.明細番号, x.明細行
select x;
var t03 = ret.FirstOrDefault();
context.DeleteObject(t03);
context.SaveChanges();
}
}
/// <summary>
/// T03_KTRNの更新
/// </summary>
/// <param name="t03ktrn">T03_KTRN_Member</param>
public void Update(T03_KTRN_Member t03ktrn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//更新行を特定
var ret = from x in context.T03_KTRN
where x.明細番号 == t03ktrn.明細番号 &&
x.明細行 == t03ktrn.明細行
orderby x.明細番号, x.明細行
select x;
var t03 = ret.FirstOrDefault();
t03.更新日時 = DateTime.Now;
t03.明細区分 = t03ktrn.明細区分;
t03.入力区分 = t03ktrn.入力区分;
t03.経費発生日 = t03ktrn.経費発生日;
t03.車輌ID = t03ktrn.車輌ID;
t03.車輌番号 = t03ktrn.車輌番号;
t03.乗務員KEY = t03ktrn.乗務員ID;
t03.支払先KEY = t03ktrn.支払先ID;
t03.自社部門ID = t03ktrn.自社部門ID;
t03.経費項目ID = t03ktrn.経費項目ID;
t03.経費補助名称 = t03ktrn.経費補助名称;
t03.単価 = t03ktrn.単価;
t03.内軽油税分 = t03ktrn.内軽油税分;
t03.数量 = t03ktrn.数量;
t03.金額 = t03ktrn.金額;
t03.収支区分 = t03ktrn.収支区分;
t03.摘要ID = t03ktrn.摘要ID;
t03.摘要名 = t03ktrn.摘要名;
//未更新フィールド
//入力者ID = t03ktrn.入力者ID;
t03.AcceptChanges();
context.SaveChanges();
}
}