/// <summary>
/// S14_CARSBの新規追加
/// </summary>
/// <param name="s14SBdrvs">S14_CARSB_Member</param>
public void Insert(S14_CARSB_Member s14SBdrvs)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
S14_CARSB s14SB = new S14_CARSB();
s14SB.車輌KEY = s14SBdrvs.車輌KEY;
s14SB.集計年月 = s14SBdrvs.集計年月;
s14SB.経費項目ID = s14SBdrvs.経費項目ID;
s14SB.登録日時 = s14SBdrvs.登録日時;
s14SB.更新日時 = s14SBdrvs.更新日時;
s14SB.経費項目名 = s14SBdrvs.経費項目名;
s14SB.固定変動区分 = s14SBdrvs.固定変動区分;
s14SB.金額 = s14SBdrvs.金額;
try
{
// newのエンティティに対してはAcceptChangesで新規追加となる
context.S14_CARSB.ApplyChanges(s14SB);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
/// <summary>
/// S14_CARSBの更新 変動項目更新
/// </summary>
/// <param name="s14SBdrvs">S14_CARSB_Member</param>
public void Update_Hendo(S14_CAR_Member s14drv, List <S14_CARSB_Member> s14SBHen, List <S14_CARSB_Member> s14SBJin, List <S14_CARSB_Member> s14SBKotei)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
// トランザクションのインスタンス化(開始)
using (var tran = new TransactionScope())
{
context.Connection.Open();
var ret = (from x in context.S14_CARSB
where x.車輌KEY == s14drv.車輌KEY && x.集計年月 == s14drv.集計年月
select x).ToList();
foreach (var rec1 in ret)
{
context.DeleteObject(rec1);
}
foreach (S14_CARSB_Member ddt in s14SBHen)
{
var dat = new S14_CARSB()
{
車輌KEY = ddt.車輌KEY,
集計年月 = ddt.集計年月,
経費項目ID = ddt.経費項目ID,
登録日時 = ddt.登録日時,
更新日時 = DateTime.Now,
経費項目名 = ddt.経費項目名,
固定変動区分 = ddt.固定変動区分,
金額 = ddt.金額,
};
context.S14_CARSB.ApplyChanges(dat);
}
foreach (S14_CARSB_Member ddt in s14SBJin)
{
var dat = new S14_CARSB()
{
車輌KEY = ddt.車輌KEY,
集計年月 = ddt.集計年月,
経費項目ID = ddt.経費項目ID,
登録日時 = ddt.登録日時,
更新日時 = DateTime.Now,
経費項目名 = ddt.経費項目名,
固定変動区分 = ddt.固定変動区分,
金額 = ddt.金額,
};
context.S14_CARSB.ApplyChanges(dat);
}
foreach (S14_CARSB_Member ddt in s14SBKotei)
{
var dat = new S14_CARSB()
{
車輌KEY = ddt.車輌KEY,
集計年月 = ddt.集計年月,
経費項目ID = ddt.経費項目ID,
登録日時 = ddt.登録日時,
更新日時 = DateTime.Now,
経費項目名 = ddt.経費項目名,
固定変動区分 = ddt.固定変動区分,
金額 = ddt.金額,
};
context.S14_CARSB.ApplyChanges(dat);
}
context.SaveChanges();
tran.Complete();
}
}
}
