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();
}
}
