/// <summary> /// Add properties for parent product or child product /// </summary> /// <param name="product_id"></param> /// <param name="props"></param> /// <returns></returns> public bool AddProductProperties(int product_id, List<BProductProperty> props) { Product dbProduct = this.GetProduct(product_id); if (dbProduct == null) { throw new KMJXCException("产品不存在"); } using (KuanMaiEntities db = new KuanMaiEntities()) { if (props != null && props.Count > 0) { List<Product_Specifications> specs = (from ps in db.Product_Specifications where ps.Product_ID == dbProduct.Product_ID select ps).ToList<Product_Specifications>(); foreach (BProductProperty prop in props) { Product_Specifications ps = (from sp in specs where sp.Product_Spec_ID == prop.PID && sp.Product_Spec_Value_ID == prop.PVID && sp.Product_ID==product_id select sp).FirstOrDefault<Product_Specifications>(); if (ps == null) { ps = new Product_Specifications(); ps.Product_Spec_Value_ID = prop.PVID; ps.Product_Spec_ID = prop.PID; ps.Product_ID = product_id; db.Product_Specifications.Add(ps); } } db.SaveChanges(); } } return true; }
/// <summary> /// Create new supplier /// </summary> /// <param name="supplier"></param> /// <returns></returns> public bool CreateSupplier(Supplier supplier) { bool result = false; if (this.CurrentUserPermission.ADD_SUPPLIER == 0) { throw new KMJXCException("没有权限添加新供应商"); } if (string.IsNullOrEmpty(supplier.Name)) { throw new KMJXCException("供应商名称不能为空"); } if (supplier.User_ID == 0 && this.CurrentUser!=null) { supplier.User_ID = this.CurrentUser.ID; } using (KuanMaiEntities db = new KuanMaiEntities()) { var obj = (from sp in db.Supplier where (sp.Shop_ID == this.Shop.Shop_ID || sp.Shop_ID == this.Main_Shop.Shop_ID) && supplier.Name.Contains(sp.Name) select sp); if (obj.ToList<Supplier>().Count > 0) { throw new KMJXCException("供应商名称已经存在"); } db.Supplier.Add(supplier); db.SaveChanges(); result = true; } return result; }
static BBaseManager() { using (KuanMaiEntities db = new KuanMaiEntities()) { Areas = (from area in db.Common_District select area).ToList<Common_District>(); } }
/// <summary> /// /// </summary> /// <param name="bug"></param> /// <returns></returns> public bool CreateNewBug(BBug bug) { if (bug.Created_By == null) { throw new KMJXCException("创建Bug时必须有创建人"); } bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { Bug dbBug = new Bug(); dbBug.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); if (bug.Created_By != null) { dbBug.Created_By = bug.Created_By.ID; } dbBug.Description = bug.Description; if (bug.Feature != null) { dbBug.Feature = bug.Feature.ID; } dbBug.Function = 0; dbBug.Modified = dbBug.Created; dbBug.Modified_By = dbBug.Created_By; dbBug.Resolved = 0; dbBug.Resolved_By = 0; dbBug.Status = 1; dbBug.Title = bug.Title; db.Bug.Add(dbBug); db.SaveChanges(); result = true; } return result; }
/// <summary> /// /// </summary> /// <param name="child_shop_id"></param> /// <returns></returns> public bool AddChildShop(int mall_type,string child_shop_name) { bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { Shop shop = (from sp in db.Shop where sp.Name == child_shop_name && sp.Mall_Type_ID==mall_type select sp).FirstOrDefault<Shop>(); if (shop == null) { throw new KMJXCException("您要添加的子店铺(" + child_shop_name + ")信息不存在,请先使用子店铺的主账户登录进销存,然后在执行添加子店铺操作"); } if (shop.Parent_Shop_ID > 0) { Shop mainshop = (from sp in db.Shop where sp.Shop_ID==shop.Parent_Shop_ID select sp).FirstOrDefault<Shop>(); if (mainshop != null) { throw new KMJXCException(child_shop_name+" 已经是 "+mainshop.Name+" 的子店铺,不能重复添加或者添加为别的店铺的子店铺"); } } result = this.AddChildShop(this.Shop, shop); } return result; }
public override void OnActionExecuting(ActionExecutingContext filterContext) { base.OnActionExecuting(filterContext); string user_id = filterContext.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(user_id)) { filterContext.HttpContext.Response.Redirect("/Home/Login?message=登录信息过期,请重新登录"); } //Verify if the cookie user is a valid user UserManager userMgr = new UserManager(int.Parse(user_id),null); BUser user = userMgr.CurrentUser; if (user == null) { filterContext.HttpContext.Response.Redirect("/Home/Login?message=登录信息丢失,请重新登录并授权"); } //Verify if logon user already has access token in db KuanMaiEntities db = new KuanMaiEntities(); Access_Token token = (from t in db.Access_Token where t.User_ID == user.ID && t.Mall_Type_ID == user.Type.ID select t).FirstOrDefault<Access_Token>(); if (token == null) { filterContext.HttpContext.Response.Redirect("/Home/Login?message=没有授权信息,请登录并授权"); } //Verify if the existed access token is expired long timeNow = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); if (timeNow >= token.Request_Time + token.Expirse_In) { filterContext.HttpContext.Response.Redirect("/Home/Login?message=授权信息已经过期,请重新登录并授权"); } }
/// <summary> /// /// </summary> /// <returns></returns> public Corp_Info GetCorpInfo() { Corp_Info info = null; using (KuanMaiEntities db = new KuanMaiEntities()) { info=(from ci in db.Corp_Info where ci.IsCurrent==true select ci).FirstOrDefault<Corp_Info>(); } return info; }
/// <summary> /// /// </summary> /// <returns></returns> public List<Express> GetExpresses() { List<Express> expresses = new List<Express>(); using (KuanMaiEntities db = new KuanMaiEntities()) { expresses=(from express in db.Express orderby express.Express_ID ascending select express).ToList<Express>(); } return expresses; }
public List<Mall_Type> GetMallTypes() { List<Mall_Type> types = null; using (KuanMaiEntities db = new KuanMaiEntities()) { types = (from mtype in db.Mall_Type select mtype).ToList<Mall_Type>(); } return types; }
/// <summary> /// /// </summary> /// <param name="parent_id"></param> /// <returns></returns> public List<Common_District> GetAreas(int parent_id) { List<Common_District> areas = null; using (KuanMaiEntities db = new KuanMaiEntities()) { var a=(from ass in db.Common_District where ass.upid==parent_id select ass); areas = a.ToList<Common_District>(); } return areas; }
/// <summary> /// /// </summary> /// <param name="image"></param> /// <returns></returns> public bool CreateImage(KM.JXC.DBA.Image image) { bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { db.Image.Add(image); db.SaveChanges(); result = true; } return result; }
/// <summary> /// Get mall object by mall id /// </summary> /// <param name="mall_type_id"></param> /// <returns></returns> public Mall_Type GetMallDetail(long mall_type_id) { Mall_Type mall = null; using (KuanMaiEntities db = new KuanMaiEntities()) { var mt = from malltype in db.Mall_Type where malltype.Mall_Type_ID == mall_type_id select malltype; if (mt != null) { mall = mt.ToList<Mall_Type>()[0]; } } return mall; }
/// <summary> /// Get mall object by mall name /// </summary> /// <param name="name"></param> /// <returns></returns> public Mall_Type GetMallDetail(string name) { Mall_Type mall = null; using(KuanMaiEntities db = new KuanMaiEntities()) { var mt= from malltype in db.Mall_Type where malltype.Name == name select malltype; if (mt != null) { mall = mt.ToList<Mall_Type>()[0]; } } return mall; }
protected Mall_Type GetMallType() { Mall_Type type = null; using (KuanMaiEntities db = new KuanMaiEntities()) { var t = from tp in db.Mall_Type where tp.Mall_Type_ID == this.Mall_Type_ID select tp; if (t.ToList<Mall_Type>().Count == 1) { type = t.ToList<Mall_Type>()[0]; } } return type; }
/// <summary> /// /// </summary> /// <param name="action"></param> public void CreateActionLog(BUserActionLog action) { if (action == null || action.Shop==null) { return; } KuanMaiEntities db = null; try { db = new KuanMaiEntities(); User_Action_Log log = new User_Action_Log(); log.Action = action.Action.Action_ID; log.Description = action.Description; if (action.User != null && action.User.ID > 0) { log.User_ID = action.User.ID; } else { log.User_ID = this.CurrentUser.ID; } log.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); if (string.IsNullOrEmpty(log.Description)) { log.Description = ""; } log.Shop_ID = action.Shop.ID; db.User_Action_Log.Add(log); db.SaveChanges(); } catch (DbEntityValidationException ex) { } catch (Exception ex) { } finally { if (db != null) { db.Dispose(); } } }
/// <summary> /// Create new user /// </summary> /// <param name="user"></param> /// <returns></returns> public BUser CreateNewUser(BUser user) { if (user == null) { throw new UserException("用户实体不能为空引用"); } if (string.IsNullOrEmpty(user.Name)) { throw new UserException("用户名不能为空"); } if (this.CurrentUserPermission.ADD_USER == 0) { throw new UserException("没有权限创建新用户"); } KuanMaiEntities dba = new KuanMaiEntities(); try { if (GetUser(user) != null) throw new UserException("用户名已经存在"); User dbUser = new User(); dbUser.User_ID = user.ID; dbUser.Mall_ID = user.Mall_ID; dbUser.Mall_Name = user.Mall_Name; dbUser.Name = user.Name; dbUser.Mall_Type = user.Type.ID; if (user.Parent != null) { dbUser.Parent_Mall_ID = user.Parent.Mall_ID; dbUser.Parent_Mall_Name = user.Parent.Mall_Name; dbUser.Parent_User_ID = user.Parent.ID; } dba.User.Add(dbUser); dba.SaveChanges(); return user; } catch (Exception ex) { throw ex; } finally { if (dba != null) { dba.Dispose(); } } }
public Access_Token GetLocAccessToken(long user_id) { Access_Token token = null; KuanMaiEntities db = new KuanMaiEntities(); var etoken = from p in db.Access_Token where p.Mall_Type_ID == this.Mall_Type_ID && p.User_ID == user_id select p; if (etoken != null) { token = etoken.ToList<Access_Token>()[0]; } return token; }
/// <summary> /// /// </summary> /// <param name="buyPrice"></param> /// <returns></returns> public bool CreateBuyPrice(BBuyPrice buyPrice) { bool result = false; if (this.CurrentUserPermission.CREATE_BUY_PRICE == 0) { throw new KMJXCException("没有权限创建采购询价单"); } if (buyPrice == null) { throw new KMJXCException("输入不正确"); } using (KuanMaiEntities db = new KuanMaiEntities()) { Buy_Price dbBuyPrice = new Buy_Price(); if (buyPrice.Created <= 0) { dbBuyPrice.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); } dbBuyPrice.Shop_ID = this.Shop.Shop_ID; if (buyPrice.Shop != null && buyPrice.Shop.ID > 0) { dbBuyPrice.Shop_ID = buyPrice.Shop.ID; } dbBuyPrice.User_ID = this.CurrentUser.ID; if (buyPrice.User != null && buyPrice.User.ID > 0) { dbBuyPrice.User_ID = buyPrice.User.ID; } dbBuyPrice.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); dbBuyPrice.Title = buyPrice.Title; dbBuyPrice.Description = buyPrice.Desc; db.Buy_Price.Add(dbBuyPrice); db.SaveChanges(); result = true; if (dbBuyPrice.ID > 0 && buyPrice.Details!=null && buyPrice.Details.Count>0) { result = result & this.SaveBuyPriceDetails(buyPrice.Details, dbBuyPrice.ID); } } return result; }
/// <summary> /// /// </summary> /// <param name="image_id"></param> /// <returns></returns> public bool DeleteProductImage(int product_id) { bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { List<Image> images = (from img in db.Image where img.ProductID == product_id select img).ToList<Image>(); foreach (Image img in images) { db.Image.Remove(img); } db.SaveChanges(); result = true; } return result; }
/// <summary> /// /// </summary> /// <param name="image_id"></param> /// <returns></returns> public bool DeleteImage(int image_id,out Image image) { bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { image=(from img in db.Image where img.ID==image_id select img).FirstOrDefault<Image>(); if (image == null) { throw new KMJXCException("图片不存在"); } db.Image.Remove(image); db.SaveChanges(); result = true; } return result; }
/// <summary> /// Add new mall in local db /// </summary> /// <param name="mall"></param> /// <returns></returns> public bool AddNewMall(Mall_Type mall) { bool result = false; if (mall == null) { return result; } if (string.IsNullOrEmpty(mall.Name)) { return result; } using (KuanMaiEntities db = new KuanMaiEntities()) { db.Mall_Type.Add(mall); db.SaveChanges(); result = true; } return result; }
public BUser GetUserInfo(int user_id) { BUser user = null; using (KuanMaiEntities db = new KuanMaiEntities()) { user = (from u in db.User where u.User_ID == user_id select new BUser { ID=u.User_ID, Name=u.Name, Mall_ID=u.Mall_ID, Mall_Name=u.Mall_Name, IsSystemUser=u.IsSystemUser, NickName=u.NickName }).FirstOrDefault<BUser>(); } return user; }
/// <summary> /// /// </summary> /// <param name="info"></param> public void SetCorpInfo(Corp_Info info) { using (KuanMaiEntities db = new KuanMaiEntities()) { Corp_Info first=(from ci in db.Corp_Info orderby ci.ID ascending select ci).FirstOrDefault<Corp_Info>(); List<Corp_Info> currents=(from ci in db.Corp_Info where ci.IsCurrent==true select ci).ToList<Corp_Info>(); foreach (Corp_Info ci in currents) { ci.IsCurrent = false; } info.IsCurrent = true; info.Modified = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); info.Modified_By=this.CurrentUser.ID; if(first!=null) { info.Created=first.Created; info.Created_By=first.Created_By; } db.Corp_Info.Add(info); db.SaveChanges(); } }
public static SystemAdmin Login(string name, string password) { SystemAdmin adminInstance = null; using (KuanMaiEntities db = new KuanMaiEntities()) { User user = (from u in db.User where u.IsSystemUser == true && u.Name == name select u).FirstOrDefault<User>(); if (user == null) { throw new KMJXCException("用户名不存在"); } string md5Password = Encrypt.MD5(password); if (md5Password != user.Password) { throw new KMJXCException("密码不正确"); } adminInstance = new SystemAdmin(user.User_ID); } return adminInstance; }
/// <summary> /// Update user object /// </summary> /// <param name="newUser"></param> public void UpdateUser(BUser user) { if (this.CurrentUserPermission.UPDATE_USER == 0) { throw new UserException("没有权限创建新用户"); } using (KuanMaiEntities db = new KuanMaiEntities()) { var old = from ou in db.User where ou.User_ID == user.ID select ou; User dbUser = old.FirstOrDefault<User>(); if (dbUser != null) { dbUser.User_ID = user.ID; dbUser.Mall_ID = user.Mall_ID; dbUser.Mall_Name = user.Mall_Name; dbUser.Name = user.Name; dbUser.Password = user.Password; //dbUser.Mall_Type = user.Type.Mall_Type_ID; if (user.Parent != null) { dbUser.Parent_Mall_ID = user.Parent.Mall_ID; dbUser.Parent_Mall_Name = user.Parent.Mall_Name; dbUser.Parent_User_ID = user.Parent.ID; } Employee employee = (from em in db.Employee where em.User_ID == dbUser.User_ID select em).FirstOrDefault<Employee>(); if (employee != null) { base.UpdateProperties(employee, user.EmployeeInfo); } } db.SaveChanges(); } }
/// <summary> /// /// </summary> /// <returns></returns> public bool UpdateEmployeeInfo(Employee employee) { bool result = false; if (this.CurrentUserPermission.UPDATE_EMPLOYEE == 0) { throw new KMJXCException("没有权限更新员工信息"); } KuanMaiEntities db = new KuanMaiEntities(); try { User user = (from u in db.User where u.User_ID == employee.User_ID select u).FirstOrDefault<User>(); if (user != null) { Employee existing = (from e in db.Employee where e.User_ID == employee.User_ID select e).FirstOrDefault<Employee>(); if (existing == null) { db.Employee.Add(employee); } else { this.UpdateProperties(existing, employee); } result = true; } } catch { } finally { if (db != null) { db.Dispose(); } } return result; }
/// <summary> /// /// </summary> /// <param name="shop_id"></param> /// <returns></returns> public bool SyncShopSubUsers(int shop_id) { bool result = false; using (KuanMaiEntities db = new KuanMaiEntities()) { BUser dbUser = (from us in db.User from sp in db.Shop where us.User_ID == sp.User_ID && sp.Shop_ID == shop_id select new BUser { ID = us.User_ID, //EmployeeInfo = (from e in db.Employee where e.User_ID == us.User_ID select e).FirstOrDefault<Employee>(), Mall_ID = us.Mall_ID, Mall_Name = us.Mall_Name, Type = (from type in db.Mall_Type where type.Mall_Type_ID == us.Mall_Type select new BMallType { ID=type.Mall_Type_ID,Name=type.Name,Description=type.Description }).FirstOrDefault<BMallType>(), Parent_ID = (int)us.Parent_User_ID, Parent = null, Name = us.Name, Password = us.Password }).FirstOrDefault<BUser>(); if (dbUser == null) { throw new KMJXCException("没有找到对应店铺的卖家信息"); } List<BUser> subUsers = this.MallUserManager.GetSubUsers(dbUser); List<BUser> existedUsers = (from us in db.User from sp in db.Shop_User where us.User_ID == sp.User_ID && sp.Shop_ID == shop_id select new BUser { ID = us.User_ID, //EmployeeInfo = (from e in db.Employee where e.User_ID == us.User_ID select e).FirstOrDefault<Employee>(), Mall_ID = us.Mall_ID, Mall_Name = us.Mall_Name, Type = (from type in db.Mall_Type where type.Mall_Type_ID == us.Mall_Type select new BMallType { ID=type.Mall_Type_ID,Name=type.Name,Description=type.Description }).FirstOrDefault<BMallType>(), Parent_ID = (int)us.Parent_User_ID, Parent = null, Name = us.Name, Password = us.Password }).ToList<BUser>(); foreach (BUser user in subUsers) { bool found = false; foreach (BUser eUser in existedUsers) { if (user.Mall_ID == eUser.Mall_ID && user.Mall_Name == eUser.Mall_Name) { //Update user found = true; eUser.EmployeeInfo = user.EmployeeInfo; eUser.Name = user.Name; break; } } if (!found) { //add new sub user User dbUser1 = new User(); //dbUser1.User_ID = user.ID; dbUser1.Mall_ID = user.Mall_ID; dbUser1.Mall_Name = user.Mall_Name; dbUser1.Name = user.Name; dbUser1.Mall_Type = user.Type.ID; if (user.Parent != null) { dbUser1.Parent_Mall_ID = user.Parent.Mall_ID; dbUser1.Parent_Mall_Name = user.Parent.Mall_Name; dbUser1.Parent_User_ID = user.Parent.ID; } db.User.Add(dbUser1); db.SaveChanges(); if (user.EmployeeInfo != null && dbUser1.User_ID>0) { Employee employee = new Employee(); employee.Name = user.EmployeeInfo.Name; employee.IdentityCard = user.EmployeeInfo.IdentityCard; employee.MatureDate = user.EmployeeInfo.MatureDate; employee.Phone = user.EmployeeInfo.Phone; employee.User_ID = user.EmployeeInfo.User_ID; employee.HireDate = user.EmployeeInfo.HireDate; employee.Gendar = user.EmployeeInfo.Gendar; employee.Duty = user.EmployeeInfo.Duty; employee.Email = user.EmployeeInfo.Email; employee.Department = user.EmployeeInfo.Department; employee.BirthDate = user.EmployeeInfo.BirthDate; employee.Address = user.EmployeeInfo.Address; db.Employee.Add(employee); } Shop_User sp = new Shop_User(); sp.Shop_ID = shop_id; sp.User_ID = dbUser1.User_ID; db.Shop_User.Add(sp); } } db.SaveChanges(); } return result; }
/// <summary> /// /// </summary> /// <returns></returns> public List<BUser> GetUsers(int page,int pageSize,out int total,int shop_id=0,bool paging=false) { List<BUser> users = new List<BUser>(); total = 0; int shop = this.Shop.Shop_ID; if (shop_id > 0) { shop = shop_id; } using (KuanMaiEntities db = new KuanMaiEntities()) { var usersobj = from user in db.User join type in db.Mall_Type on user.Mall_Type equals type.Mall_Type_ID into Ltype from l_type in Ltype.DefaultIfEmpty() where user.Shop_ID == shop select new BUser { ID = user.User_ID, Name = user.Name, Mall_Name = user.Mall_Name, Mall_ID = user.Mall_ID, Parent_ID = (int)user.Parent_User_ID, Password = user.Password, Type = new BMallType { Name = l_type.Name, ID = l_type.Mall_Type_ID, Description = l_type.Description } }; total = usersobj.Count(); if (paging) { usersobj = usersobj.OrderBy(a => a.ID).Skip((page - 1) * pageSize).Take(pageSize); } users = usersobj.ToList<BUser>(); } return users; }
/// <summary> /// Get user by id /// </summary> /// <param name="user_Id"></param> /// <returns></returns> public BUser GetUser(int user_Id) { BUser user = null; KuanMaiEntities db = new KuanMaiEntities(); try { var us = from u in db.User where u.User_ID == user_Id select new BUser { ID = u.User_ID, EmployeeInfo = (from e in db.Employee where e.User_ID == u.User_ID select new BEmployee { ID=e.Employee_ID, Name=e.Name }).FirstOrDefault<BEmployee>(), Mall_ID = u.Mall_ID, Mall_Name = u.Mall_Name, Name = u.Name, Password = u.Password, Parent_ID = (int)u.Parent_User_ID, Type = (from t in db.Mall_Type where t.Mall_Type_ID == u.Mall_Type select new BMallType { ID=t.Mall_Type_ID, Name=t.Name }).FirstOrDefault<BMallType>(), }; user = us.FirstOrDefault<BUser>(); if (user.Parent_ID > 0) { user.Parent = this.GetUser(user.Parent_ID); } } catch { } return user; }
/// <summary> /// /// </summary> /// <param name="user_id"></param> /// <returns></returns> public Employee GetEmployInfo(int user_id) { Employee e = null; using (KuanMaiEntities db = new KuanMaiEntities()) { e = (from em in db.Employee where em.User_ID == user_id select em).FirstOrDefault<Employee>(); } return e; }