public void SingleTableDoEdit(string code, string name, SchoolTypeEnum schooltype, string remark) { SchoolTop s = new SchoolTop(); s.SchoolCode = "000"; s.SchoolName = "default"; s.SchoolType = null; s.Remark = "default"; _schoolvm.Entity = s; _schoolvm.DoAdd(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { SchoolTop s2 = new SchoolTop(); s2.SchoolCode = code; s2.SchoolName = name; s2.SchoolType = schooltype; s2.Remark = remark; s2.ID = s.ID; _schoolvm.DC = context; _schoolvm.Entity = s2; _schoolvm.DoEdit(true); } using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var rv = context.Set <SchoolTop>().ToList(); Assert.AreEqual(1, rv.Count()); Assert.AreEqual(code, rv[0].SchoolCode); Assert.AreEqual(name, rv[0].SchoolName); Assert.AreEqual(schooltype, rv[0].SchoolType); Assert.AreEqual(remark, rv[0].Remark); } }
/// <summary> /// 取得指定條件下的學校資訊. /// </summary> /// <param name="countyId">縣市ID.</param> /// <param name="districtId">鄉鎮市區ID.</param> /// <param name="schoolType">學校類別.</param> /// <returns>List<SchoolInfoDto>.</returns> /// <exception cref="System.NotImplementedException"></exception> public List <SchoolInfoDto> GetSchoolInfosByCondition(string countyId, string districtId, SchoolTypeEnum schoolType) { if (string.IsNullOrWhiteSpace(countyId)) { throw new ArgumentNullException(nameof(countyId), "please input value"); } if (string.IsNullOrWhiteSpace(districtId)) { throw new ArgumentNullException(nameof(districtId), "please input value"); } var allSchoolInfos = this.GetAllSchoolInfos(); var schools = allSchoolInfos.Where ( x => x.CountyID == countyId && x.DistrictID.HasValue && x.DistrictID.Value == Convert.ToInt32(districtId) && x.SchoolTypeID == Convert.ToInt32(schoolType) ); return(schools.ToList()); }
public void SingleTableDoAdd(string code, string name, SchoolTypeEnum schooltype, string remark) { SchoolTop s = new SchoolTop(); s.SchoolCode = code; s.SchoolName = name; s.SchoolType = schooltype; s.Remark = remark; _schoolvm.Entity = s; _schoolvm.DoAdd(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var rv = context.Set <SchoolTop>().ToList(); Assert.AreEqual(1, rv.Count()); Assert.AreEqual(code, rv[0].SchoolCode); Assert.AreEqual(name, rv[0].SchoolName); Assert.AreEqual(schooltype, rv[0].SchoolType); Assert.AreEqual(remark, rv[0].Remark); } Assert.IsTrue(_schoolvm.MSD.Count == 0); }
public void SingleTableDoEditFields(string code, string name, SchoolTypeEnum schooltype, string remark) { School s = new School(); s.SchoolCode = "000"; s.SchoolName = "default"; s.SchoolType = null; s.Remark = "default"; _schoolvm.Entity = s; _schoolvm.DoAdd(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { School s2 = new School(); s2.SchoolCode = code; s2.SchoolName = name; s2.SchoolType = schooltype; s2.Remark = remark; s2.ID = s.ID; _schoolvm.DC = context; _schoolvm.Entity = s2; _schoolvm.FC.Add("Entity.SchoolName", name); _schoolvm.DoEdit(); } using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var rv = context.Set <School>().ToList(); Assert.AreEqual(1, rv.Count()); Assert.AreEqual("000", rv[0].SchoolCode); Assert.AreEqual(name, rv[0].SchoolName); Assert.AreEqual(null, rv[0].SchoolType); Assert.AreEqual("default", rv[0].Remark); Assert.AreEqual("schooluser", rv[0].UpdateBy); Assert.IsTrue(DateTime.Now.Subtract(rv[0].UpdateTime.Value).Seconds < 10); } }
public void SingleTableDoAdd(string code, string name, SchoolTypeEnum schooltype, string remark) { School s = new School(); s.SchoolCode = code; s.SchoolName = name; s.SchoolType = schooltype; s.Remark = remark; _schoolvm.Entity = s; _schoolvm.DoAdd(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var rv = context.Set <School>().ToList(); Assert.AreEqual(1, rv.Count()); Assert.AreEqual(code, rv[0].SchoolCode); Assert.AreEqual(name, rv[0].SchoolName); Assert.AreEqual(schooltype, rv[0].SchoolType); Assert.AreEqual(remark, rv[0].Remark); Assert.AreEqual("schooluser", rv[0].CreateBy); Assert.IsTrue(DateTime.Now.Subtract(rv[0].CreateTime.Value).Seconds < 10); } Assert.IsTrue(_schoolvm.MSD.Count == 0); }