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