public void Insert_Test() { using (var db = new EFDbContext()) { //if (!db.MedicalPackages.Any()) { db.MedicalPackages.Add(new MedicalPackage { Name = "常规体检(女)", CategoryId = 1, Type = 0, MarketPrice = 2600, Price = 2200, Feature = "实用性", ForTheCrowd = "屌丝们", Recommends = "体重,身高", Details = "具体的描述", CreateOn = DateTime.Now, CreatorId = 0, Creator = "system", Popularity = 0, Sort = 0, State = 1, Sex = 2 }); db.SaveChanges(); } Assert.AreEqual(2, db.MedicalPackages.Count()); } }
public void TestMethod1() { using (var db = new EFDbContext()) { int count; var list = db.Paging<Diseases>(new DataPage { Table = "Diseases", PrimaryKey = "DiseasesId", Sort = "DiseasesId desc", Fields = "*", PageIndex = 5, PageSize = 5, Filter = "DiseasesDepartmentId=1012", Group = "" }, out count).ToList(); Console.WriteLine(list.Select(t => new { t.DiseasesId, t.DiseasesName, t.DiseasesDepartmentId }).ToJson()); Console.WriteLine(count); } }
public void QueryTest() { using (var db = new EFDbContext()) { var item = db.MedicalPackages.FirstOrDefault(); Assert.AreNotEqual(null, item); Assert.AreEqual("常规体检", item.Category.Name); } }
public void InsertTest() { using (var db = new EFDbContext()) { if (!db.PackageCategories.Any()) { db.PackageCategories.Add(new PackageCategory { Name = "常规体检", Sort = 0, State = 1 }); db.SaveChanges(); } Assert.AreEqual(1, db.PackageCategories.Count()); } }
public void InitModel() { using (var db = new EFDbContext()) { var manager = new Manager { UserName = "******", PassWord = "******".Md5().ToLower(), RealName = "罗勇", State = (byte)StateType.Display, CreateOn = DateTime.Now, Mobile = "18782246531", Role = (ManagerRole.News | ManagerRole.Package | ManagerRole.Reservation | ManagerRole.Users | ManagerRole.Health) .GetValue() }; db.Managers.Add(manager); //var item = db.Managers.FirstOrDefault(); //item.Role = ManagerRole.News.GetValue(); db.SaveChanges(); Assert.IsNotNull(db.Managers.FirstOrDefault()); } }
private static int MemberLogin(string userName, string userPwd) { using (var db = new EFDbContext()) { var uItem = db.Members.SingleOrDefault(t => t.UserName == userName); if (uItem == null) return -1; if (!uItem.PassWord.Equals(userPwd.Md5(), StringComparison.CurrentCultureIgnoreCase)) return -2; var tick = Const.CreateGuid().Substring(5, 15); var user = new User { UserId = uItem.MemberId, UserName = uItem.UserName, Ticket = tick, Type = UserType.Manager.GetValue() }; var ticket = new FormsAuthenticationTicket(1, user.UserName, DateTime.Now, DateTime.Now.AddHours(2), false, user.ToJson()); var encryptedTicket = FormsAuthentication.Encrypt(ticket); uItem.Ticket = tick; uItem.LastLoginIp = Utils.GetRealIp(); uItem.LastLoginTime = DateTime.Now; db.SaveChanges(); CookieCls.Set(FormsAuthentication.FormsCookieName, encryptedTicket, CookieCls.GetHour(2)); return 1; } }