/// <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; } } }