/// <summary>
/// 新規登録
/// </summary>
/// <param name="data">運送データ</param>
/// <returns>自動採番されたID</returns>
public static int Create(ModelUnsou data)
{
var id = 0;
using (var conn = Db.OpenConnection())
{
var tran = conn.BeginTransaction();
try
{
var sql = @"INSERT INTO TranUnsou (
HaishaKubun,Haishabi,NinushiCd,Ninushimei,TsumichiCd,Tsumichimei
,OroshichiCd,Oroshichimei,Oroshibi,ShouhinCd,Hinmei,Suuryou,YoushasakiCd,Youshasakimei
,SharyouCd,Shaban,JoumuinCd,Joumuinmei,Keitai
,Bikou,UnchinTanka,UnchinKingaku,ShitabaraiTanka,ShitabaraiKingaku,Seikyuubi,Shitabaraibi
) VALUES (
@HaishaKubun,@Haishabi,@NinushiCd,@Ninushimei,@TsumichiCd,@Tsumichimei
,@OroshichiCd,@Oroshichimei,@Oroshibi,@ShouhinCd,@Hinmei,@Suuryou,@YoushasakiCd,@Youshasakimei
,@SharyouCd,@Shaban,@JoumuinCd,@Joumuinmei,@Keitai
,@Bikou,@UnchinTanka,@UnchinKingaku,@ShitabaraiTanka,@ShitabaraiKingaku,@Seikyuubi,@Shitabaraibi);
SELECT SCOPE_IDENTITY();";
id = conn.Query<int>(sql, data, tran).FirstOrDefault();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
return id;
}
private void SetMeisaiData(ModelUnsou data, string propertyName)
{
switch (propertyName)
{
case nameof(data.NinushiCd):
if (!string.IsNullOrEmpty(data.NinushiCd))
{
var ninushi = ListNinushi.Where(_ => _.NinushiCd == data.NinushiCd).FirstOrDefault();
if (ninushi != null)
{
data.Ninushimei = ninushi.Ninushimei;
}
}
break;
case nameof(data.TsumichiCd):
if (!string.IsNullOrEmpty(data.TsumichiCd))
{
var tsumichi = ListTsumichi.Where(_ => _.TsumioroshichiCd == data.TsumichiCd).FirstOrDefault();
if (tsumichi != null)
{
data.Tsumichimei = tsumichi.Tsumioroshichimei;
}
}
break;
case nameof(data.OroshichiCd):
if (!string.IsNullOrEmpty(data.OroshichiCd))
{
var oroshichi = ListOroshichi.Where(_ => _.TsumioroshichiCd == data.OroshichiCd).FirstOrDefault();
if (oroshichi != null)
{
data.Oroshichimei = oroshichi.Tsumioroshichimei;
}
}
break;
case nameof(data.ShouhinCd):
if (!string.IsNullOrEmpty(data.ShouhinCd))
{
var shouhin = ListShouhin.Where(_ => _.ShouhinCd == data.ShouhinCd).FirstOrDefault();
if (shouhin != null)
{
data.Hinmei = shouhin.Hinmei;
}
}
break;
case nameof(data.Suuryou):
if (data.UnchinTanka.HasValue && data.Suuryou.HasValue)
{
data.UnchinKingaku = (int)(data.UnchinTanka.Value * data.Suuryou.Value);
}
if (data.ShitabaraiTanka.HasValue && data.Suuryou.HasValue)
{
data.ShitabaraiKingaku = (int)(data.ShitabaraiTanka.Value * data.Suuryou.Value);
}
CalcTotalSashihikiKingaku();
break;
case nameof(data.YoushasakiCd):
if (!string.IsNullOrEmpty(data.YoushasakiCd))
{
var youshasaki = ListYoushasaki.Where(_ => _.YoushasakiCd == data.YoushasakiCd).FirstOrDefault();
if (youshasaki != null)
{
data.Youshasakimei = youshasaki.Youshasakimei;
}
}
break;
case nameof(data.UnchinTanka):
if (data.UnchinTanka.HasValue && data.Suuryou.HasValue)
{
data.UnchinKingaku = (int)(data.UnchinTanka.Value * data.Suuryou.Value);
}
break;
case nameof(data.UnchinKingaku):
CalcTotalUnchinKingaku();
CalcTotalSashihikiKingaku();
break;
case nameof(data.ShitabaraiTanka):
if (data.ShitabaraiTanka.HasValue && data.Suuryou.HasValue)
{
data.ShitabaraiKingaku = (int)(data.ShitabaraiTanka.Value * data.Suuryou.Value);
}
break;
case nameof(data.ShitabaraiKingaku):
CalcTotalShitabaraiKingaku();
CalcTotalSashihikiKingaku();
break;
default:
break;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="data">運送データ</param>
public static void Update(ModelUnsou data)
{
using (var conn = Db.OpenConnection())
{
var tran = conn.BeginTransaction();
try
{
var sql = @"UPDATE TranUnsou SET
HaishaKubun = @HaishaKubun
,Haishabi = @Haishabi
,NinushiCd = @NinushiCd
,Ninushimei = @Ninushimei
,TsumichiCd = @TsumichiCd
,Tsumichimei = @Tsumichimei
,OroshichiCd = @OroshichiCd
,Oroshichimei = @Oroshichimei
,Oroshibi = @Oroshibi
,ShouhinCd = @ShouhinCd
,Hinmei = @Hinmei
,Suuryou = @Suuryou
,YoushasakiCd = @YoushasakiCd
,Youshasakimei = @Youshasakimei
,SharyouCd = @SharyouCd
,Shaban = @Shaban
,JoumuinCd = @JoumuinCd
,Joumuinmei = @Joumuinmei
,Keitai = @Keitai
,Bikou = @Bikou
,UnchinTanka = @UnchinTanka
,UnchinKingaku = @UnchinKingaku
,ShitabaraiTanka = @ShitabaraiTanka
,ShitabaraiKingaku = @ShitabaraiKingaku
,Seikyuubi = @Seikyuubi
,Shitabaraibi = @Shitabaraibi
WHERE ID = @ID";
conn.Execute(sql, data, tran);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
}
