/// <summary>
/// M17_CYSNの新規追加
/// </summary>
/// <param name="m17cysn">M17_CYSN_Member</param>
public void Insert(M17_CYSN_Member m17cysn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
M17_CYSN m17 = new M17_CYSN();
//m17.車輌KEY = m17cysn.車両ID;
m17.年月 = m17cysn.年月;
//m17.登録日時 = m17cysn.登録日時;
//m17.更新日時 = m17cysn.更新日時;
//m17.目標燃費 = m17cysn.目標燃費;
try
{
// newのエンティティに対してはAcceptChangesで新規追加となる
context.M17_CYSN.ApplyChanges(m17);
context.SaveChanges();
}
catch (UpdateException ex)
{
// PKey違反等
Console.WriteLine(ex);
}
}
}
/// <summary>
/// M17_CYSNの物理削除
/// </summary>
/// <param name="m17cysn">M17_CYSN_Member</param>
public void Delete(M17_CYSN_Member m17cysn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//削除行を特定
var ret = from x in context.M17_CYSN
where (x.車輌KEY == m17cysn.車両KEY && x.年月 == m17cysn.年月)
orderby x.車輌KEY, x.年月
select x;
var m17 = ret.FirstOrDefault();
context.DeleteObject(m17);
context.SaveChanges();
}
}
/// <summary>
/// M17_CYSNの更新
/// </summary>
/// <param name="m17cysn">M17_CYSN_Member</param>
public void Update(M17_CYSN_Member m17cysn)
{
using (TRAC3Entities context = new TRAC3Entities(CommonData.TRAC3_GetConnectionString()))
{
context.Connection.Open();
//更新行を特定
var ret = from x in context.M17_CYSN
where (x.車輌KEY == m17cysn.車両KEY && x.年月 == m17cysn.年月)
orderby x.車輌KEY, x.年月
select x;
var m17 = ret.FirstOrDefault();
//m17.車輌KEY = m17cysn.車両ID;
m17.年月 = m17cysn.年月;
//m17.登録日時 = m17cysn.登録日時;
//m17.更新日時 = DateTime.Now;
//m17.目標燃費 = m17cysn.目標燃費;
m17.AcceptChanges();
context.SaveChanges();
}
}