/// <summary>
/// T06_KYUSの新規追加
/// </summary>
/// <param name="t06kyus">T06_KYUS_Member</param>
public void Insert(T06_KYUS_Member t06kyus)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
T06_KYUS t06 = new T06_KYUS();
t06.車輌ID = t06kyus.車輌ID;
t06.休車開始日付 = t06kyus.休車開始日付;
t06.休車終了日付 = t06kyus.休車終了日付;
t06.明細区分 = t06kyus.明細区分;
t06.車輌番号 = t06kyus.車輌番号;
t06.休車事由 = t06kyus.休車事由;
try
{
// newのエンティティに対してはAcceptChangesで新規追加となる
context.T06_KYUS.ApplyChanges(t06);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
/// <summary>
/// T06_KYUSの更新
/// </summary>
/// <param name="t06kyus">T06_KYUS_Member</param>
public void Update(T06_KYUS_Member t06kyus)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//更新行を特定
var ret = from x in context.T06_KYUS
where x.車輌ID == t06kyus.車輌ID &&
x.休車開始日付 == t06kyus.休車開始日付
orderby x.車輌ID, x.休車開始日付
select x;
var t06 = ret.FirstOrDefault();
t06.車輌ID = t06kyus.車輌ID;
t06.休車開始日付 = t06kyus.休車開始日付;
t06.休車終了日付 = t06kyus.休車終了日付;
t06.明細区分 = t06kyus.明細区分;
t06.車輌番号 = t06kyus.車輌番号;
t06.休車事由 = t06kyus.休車事由;
t06.AcceptChanges();
context.SaveChanges();
}
}
/// <summary>
/// T06_KYUSの物理削除
/// </summary>
/// <param name="t06kyus">T06_KYUS_Member</param>
public void Delete(T06_KYUS_Member t06kyus)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//削除行を特定
var ret = from x in context.T06_KYUS
where x.車輌ID == t06kyus.車輌ID &&
x.休車開始日付 == t06kyus.休車開始日付
orderby x.車輌ID, x.休車開始日付
select x;
var t06 = ret.FirstOrDefault();
context.DeleteObject(t06);
context.SaveChanges();
}
}
