public static Alading.Web.Entity.News GetNews(int id) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.News.FirstOrDefault(c => c.Id == id)); } }
public static List <Alading.Web.Entity.News> GetNewsList(int cid) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.News.Where(c => c.Cat == cid).ToList()); } }
public static Shop GetShop(string shopCode) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.Shop.FirstOrDefault(c => c.ShopCode == shopCode)); } }
public static HelpCat GetHelpCat(int id) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.HelpCat.FirstOrDefault(c => c.Id == id)); } }
public static List <NewsCat> GetNewsCat() { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.NewsCat.ToList()); } }
public static List <Shop> GetShopList(string userCode) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { return(context.Shop.Where(c => c.UserCode == userCode).ToList()); } }
public static List <User> GetUser(Func <User, bool> func) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { List <User> list = context.User.Where(func).ToList(); return(list); } }
public static List <Alading.Web.Entity.FileUpdate> GetFileUpdateList(string versionCode) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var result = context.FileUpdate.Where(c => c.VersionCode == versionCode).ToList(); return(result); } }
public static void UpdateUser(User user) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var old = context.User.FirstOrDefault(p => p.UserCode == user.UserCode); if (old != null) { context.Attach(old); context.ApplyPropertyChanges("User", user); context.SaveChanges(); } } }
public static void UpdateShop(Shop shop) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var old = context.Shop.FirstOrDefault(c => c.ShopCode == shop.ShopCode); if (old != null) { context.Attach(old); context.ApplyPropertyChanges("Shop", shop); context.SaveChanges(); } } }
public static void AddUser(Alading.Web.Entity.User user) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { if (user.Account.Contains(":")) { string mainAccount = user.Account.Substring(0, user.Account.IndexOf(":")); var x = context.User.Where(p => p.Account == mainAccount).FirstOrDefault(); x.HasUser++; } context.AddToUser(user); context.SaveChanges(); } }
public static List <Area> GetArea(Func <Area, bool> func) { try { using (AladingWebEntities alading = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { List <Area> list = alading.Area.Where(func).ToList(); return(list); } } catch (System.Exception ex) { throw ex; } }
public static User GetUserByAccount(string account) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var user = context.User.Where(p => p.Account == account).FirstOrDefault(); if (user != null) { return(user); } else { return(null); } } }
public static List <User> GetUsers(string account) //根据主号找子号 { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var result = context.User.Where(p => p.Account.StartsWith(account + ":")); if (result.Count() > 0) { return(result.ToList()); } else { return(null); } } }
public static Alading.Web.Entity.Version GetNewVersion(string versionType) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var result = context.Version.Where(c => c.VersionType == versionType).OrderBy(c => c.VersionID).ToList(); if (result.Count() > 0) { return(result[result.Count() - 1]); } else { return(null); } } }
public static void RemoveUser(string userCode) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var user = context.User.FirstOrDefault(p => p.UserCode == userCode); if (user != null) { if (user.Account.Contains(":")) { string mainAccount = user.Account.Substring(0, user.Account.IndexOf(":")); var x = context.User.Where(p => p.Account == mainAccount).FirstOrDefault(); x.HasUser--; } context.DeleteObject(user); context.SaveChanges(); } } }
public static void AddShop(Shop shop) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var user = context.User.FirstOrDefault(c => c.UserCode == shop.UserCode); if (user == null) { throw new ServiceException("用户不存在!"); } if (user.HasShop > user.MaxShop) { throw new ServiceException("已有店铺数量不大于允许的最大店铺数量!"); } user.HasShop++; context.AddToShop(shop); context.SaveChanges(); } }
public static void RemoveShop(string shopCode) { using (AladingWebEntities context = ContextProvider.DataContext(ConnectionHelper.ConnectionString)) { var old = context.Shop.FirstOrDefault(c => c.ShopCode == shopCode); if (old == null) { throw new ServiceException("店铺不存在!"); } var user = context.User.FirstOrDefault(c => c.UserCode == old.UserCode); if (user == null) { throw new ServiceException("用户不存在!"); } user.HasShop--; context.DeleteObject(old); context.SaveChanges(); } }