public static Item GetItemInfo(int id) { using (var entity = new BidingSystemDBEntities()) { return(entity.Item.Where(x => x.ItemId == id).FirstOrDefault()); } }
public static User GetUserInfo(int id) { using (var entity = new BidingSystemDBEntities()) { return(entity.User.Where(x => x.CompanyId == id).FirstOrDefault()); } }
// 获取公司信息列表 public static List <Item> GetPageEntityList(int pageIndex, int pageSize) { using (var entity = new BidingSystemDBEntities()) { return(entity.Item.OrderBy(x => x.Status).ThenBy(x => x.StartTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
// 获取公司信息列表 public static List <User> GetPageEntityList(int pageIndex, int pageSize) { using (var entity = new BidingSystemDBEntities()) { return(entity.User.OrderBy(x => x.CompanyId).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
public static int Validate(string userName, string passwrod) { using (var entity = new BidingSystemDBEntities()) { var user = entity.User.Where(x => x.CompanyName == userName && x.Password == passwrod).FirstOrDefault(); if (user == null) { return(-1); } else if (user != null) { if (user.Type == 1) { return(1); } else if (user.Type == 0) { return(0); } else { return(-1); } } else { return(-1); } } }
public static int RemoveItem(int id) { using (var entity = new BidingSystemDBEntities()) { var item = entity.Item.Where(x => x.ItemId == id).FirstOrDefault(); entity.Item.Remove(item); return(entity.SaveChanges()); } }
public static int RemoveUser(int id) { using (var entity = new BidingSystemDBEntities()) { var user = entity.User.Where(x => x.CompanyId == id).FirstOrDefault(); entity.User.Remove(user); return(entity.SaveChanges()); } }
public static User GetUserInfoInLogin(string userName, string passwrod) { using (var entity = new BidingSystemDBEntities()) { var user = entity.User.Where(x => x.CompanyName == userName && x.Password == passwrod).FirstOrDefault(); if (user == null) { return(null); } return(user); } }
private static int GetRecordCount() { try { using (var entity = new BidingSystemDBEntities()) { var item = entity.Item.ToList(); if (item != null) { return(item.Count()); } else { return(-1); } } } catch (Exception ex) { Console.WriteLine(ex); return(-1); } }