public void GetTest() { Init(); var kaisha = ServiceKaisha.Get(); Assert.IsNull(kaisha); kaisha = new ModelKaisha() { Kaishamei = "株式会社IOT", Yuubin = "999-9999", Juusho1 = "東京都北区○○町○○丁目-3-1", JishaYoushasakiCd = "0001", Kinyuukikanmei1 = "○○○○銀行", Shitenmei1 = "○○○○支店", YokinShumoku1 = "普通", KouzaBangou1 = "9999999" }; var registration = ServiceKaisha.Save(kaisha); Assert.AreEqual(registration.AffectedRows, 1); Assert.AreEqual(registration.ErrorMessage, string.Empty); Assert.IsNull(registration.OccurredException); var insertedKaisha = ServiceKaisha.Get(); Assert.IsNotNull(insertedKaisha); Assert.AreEqual(insertedKaisha.Kaishamei, kaisha.Kaishamei); Assert.AreEqual(insertedKaisha.Yuubin, kaisha.Yuubin); Assert.AreEqual(insertedKaisha.Juusho1, kaisha.Juusho1); Assert.AreEqual(insertedKaisha.Juusho2, kaisha.Juusho2); Assert.AreEqual(insertedKaisha.Juusho3, kaisha.Juusho3); Assert.AreEqual(insertedKaisha.Tel, kaisha.Tel); Assert.AreEqual(insertedKaisha.Fax, kaisha.Fax); Assert.AreEqual(insertedKaisha.JishaYoushasakiCd, kaisha.JishaYoushasakiCd); Assert.AreEqual(insertedKaisha.Kinyuukikanmei1, kaisha.Kinyuukikanmei1); Assert.AreEqual(insertedKaisha.Shitenmei1, kaisha.Shitenmei1); Assert.AreEqual(insertedKaisha.YokinShumoku1, kaisha.YokinShumoku1); Assert.AreEqual(insertedKaisha.KouzaBangou1, kaisha.KouzaBangou1); }
/// <summary> /// 会社基本情報を登録します。 /// </summary> /// <param name="kaisha">会社基本情報</param> /// <returns>登録処理の結果</returns> public static RegistrationResult Save(ModelKaisha kaisha) { var registraion = new RegistrationResult(); using (var conn = Db.OpenConnection()) { var tran = conn.BeginTransaction(); try { var beforeKaisha = Get(); if (beforeKaisha == null) { registraion.AffectedRows = conn.Execute(SqlInsertKaisha, kaisha, transaction: tran); } else { registraion.AffectedRows = conn.Execute(SqlUpdateKaisha, kaisha, transaction: tran); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); registraion.SetError(ex.Message, ex); } } return registraion; }