public MemberModel GetUserDetail(Guid UserId)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.MemberInfo.Where(k => k.Id == UserId)
select new MemberModel
{
Id = p.Id,
Name = p.userName,
RealName = p.RealName,
Sex = p.Sex,
Email = p.Email,
Telphone = p.Telphone,
Age = p.Age,
Stock = p.Stock,
AddStock = p.AddStock,
Gold = p.Gold,
MemberNumber = p.MemberNumber,
ZStock = p.ZStock,
Commission = p.Commission,
}).FirstOrDefault();
tables.OneRequestUserCount = RequestUserCount(tables.MemberNumber, 1);
tables.TowRequestUserCount = RequestUserCount(tables.MemberNumber, 2);
tables.MessageCount = GetReMessageFalseConut(UserId) ?? 0;
return(tables);
}
}
//用户登录
public LoginModel IsLogin(LoginModel models)
{
using (var db = new HTJKEntities())
{
var Tables = (from p in db.A_User.Where(k => k.Password == models.PassWord && k.State == true)
where !string.IsNullOrEmpty(models.UserName) ? p.Name == models.UserName : true
where !string.IsNullOrEmpty(models.Telephone) ? p.Telphone == models.Telephone : true
select p
).FirstOrDefault();
LoginModel ReturnModel = new LoginModel();
if (Tables != null)
{
ReturnModel.UserName = Tables.Name;
ReturnModel.IsLogin = true;
ReturnModel.UserId = Tables.Id;
Tables.LoginTimes = Tables.LoginTimes + 1;
Tables.LastTimes = DateTime.Now;
db.SaveChanges();
}
else
{
ReturnModel.IsLogin = false;
}
return(ReturnModel);
}
}
//新增和修改仓库设置
public void AddOrUpdate(MenuModel Models)
{
using (var db = new HTJKEntities())
{
if (Models.Id > 0)
{
var table = db.A_Menu.Where(k => k.Id == Models.Id).SingleOrDefault();
table.ParentId = Models.ParentId;
table.Name = Models.Name;
table.Rank = Models.Rank;
table.ParentId = Models.ParentId;
table.Action = Models.Action;
table.Controller = Models.Controller;
table.Remark = Models.Remark;
table.Icon = Models.Icon;
}
else
{
A_Menu table = new A_Menu();
table.Name = Models.Name;
table.Rank = Models.Rank;
table.ParentId = Models.ParentId;
table.CreateTime = DateTime.Now;
table.DeleteFlag = true;
table.Action = Models.Action;
table.Controller = Models.Controller;
table.Remark = Models.Remark;
table.Icon = Models.Icon;
db.A_Menu.Add(table);
}
db.SaveChanges();
}
}
public int?GetMessagelistConut(Guid?UserId)
{
using (var db = new HTJKEntities())
{
return(db.MemberMessage.Where(k => k.State == true && k.MemberId == UserId).Count());
}
}
public void AddOrUpdate(UsersModel Models)
{
using (var db = new HTJKEntities())
{
if (Models.Id > 0)
{
var table = db.A_User.Where(k => k.Id == Models.Id).SingleOrDefault();
table.Telphone = Models.Telphone;
table.Name = Models.Name;
table.Password = Models.Password;
}
else
{
A_User table = new A_User();
table.Telphone = Models.Telphone;
table.Name = Models.Name;
table.Password = Models.Password;
table.LastTimes = DateTime.Now;
table.LoginTimes = 1;
table.CreateTime = DateTime.Now;
db.A_User.Add(table);
}
db.SaveChanges();
}
}
//获取订单默认地址或者第一个地址
public AddressModel GetTop1Address(Guid MemberId)
{
AddressModel models = new AddressModel();
using (var db = new HTJKEntities())
{
var list = (from p in db.Address_Info.Where(k => k.MemberId == MemberId && k.State == true)
orderby p.CreateTime descending
select new AddressModel
{
Id = p.Id,
Name = p.Name,
Telphone = p.Telphone,
Province = p.Province,
City = p.City,
Region = p.Region,
IsTop = p.IsTop,
addressNo = p.addressNo,
}).ToList();
models = list.FirstOrDefault();
foreach (var item in list)
{
if (item.IsTop == true)
{
models = item;
}
}
return(models);
}
}
public int?GetReMessageFalseConut(Guid?UserId)
{
using (var db = new HTJKEntities())
{
return(db.ReplyMemMSG.Where(k => k.State == true && k.ReplyMemberId == UserId && k.IsRead == false).Count());
}
}
public List <SelectListItem> GetParentType(int?pId)
{
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem()
{
Text = "请选择父类别", Value = ""
});
using (var db = new HTJKEntities())
{
List <A_NewsType> model = db.A_NewsType.Where(b => b.State == true).OrderBy(k => k.Id).ToList();
foreach (var item in model)
{
items.Add(new SelectListItem()
{
Text = "╋" + item.Name, Value = item.Id.ToString(), Selected = pId.HasValue && item.Id.Equals(pId)
});
List <A_NewsType> childrenmodel = db.A_NewsType.Where(b => b.State == true && b.ParentId == item.Id).OrderBy(k => k.Id).ToList();
if (childrenmodel != null && childrenmodel.Any())
{
foreach (var Citem in childrenmodel)
{
items.Add(new SelectListItem()
{
Text = "----└" + Citem.Name, Value = Citem.Id.ToString(), Selected = pId.HasValue && Citem.Id.Equals(pId)
});
}
}
}
}
return(items);
}
public List <OrderModel> GetReturnOrderList(Guid MemberId, int PageSize, int PageIndex)
{
using (var db = new HTJKEntities())
{
var orderlist = (from p in db.OrderInfo.Where(k => k.MemberId == MemberId && k.State == true && k.PayState == true)
orderby p.CreateTime descending
select new OrderModel
{
Id = p.Id,
Ordernum = p.Ordernum,
CreateTime = p.CreateTime,
TotalPrice = p.TotalPrice,
YunFei = p.YunFei,
DKPrce = p.DKPrce,
PayState = p.PayState,
AddressId = p.AddressId,
YunDan = p.YunDan,
YState = p.YState,
YSCompany = p.YSCompany,
OrderProductList = (from m in db.OrderProductsInfo.Where(k => k.Ordernum == p.Ordernum)
select new OrderProductsModels
{
ProductsId = m.ProductsId,
ProductsName = m.ProductsName,
ProductsConvertImg = m.ProductsConvertImg,
Saleprice = m.SalePrice,
Amount = m.Amount
})
}).ToList();
return(orderlist.Skip(PageIndex * PageSize).Take(PageSize).ToList());
}
}
//新增和修改仓库设置
public void AddOrUpdate(CategoryModel Models)
{
using (var db = new HTJKEntities())
{
if (Models.Id > 0)
{
var table = db.A_NewsType.Where(k => k.Id == Models.Id).SingleOrDefault();
table.ParentId = Models.ParentId;
table.Name = Models.Name;
table.Rank = Models.Rank;
table.ParentId = Models.ParentId;
}
else
{
A_NewsType table = new A_NewsType();
table.Name = Models.Name;
table.Rank = Models.Rank;
table.ParentId = Models.ParentId;
table.CreateTime = DateTime.Now;
table.State = true;
db.A_NewsType.Add(table);
}
db.SaveChanges();
}
}
public List <NewsModel> GetWebPageList(SNewsModel SModel, int Type)
{
using (var db = new HTJKEntities())
{
var List = (from p in db.A_News.Where(k => k.State == true && k.CheckedStatus == 1 && k.A_NewsType.Type == Type)
where !string.IsNullOrEmpty(SModel.Name) ? p.Name.Contains(SModel.Name) : true
where SModel.TypeId > 0 ? p.TypeId == SModel.TypeId : true
orderby p.CreateTime descending
select new NewsModel
{
Id = p.Id,
Name = p.Name,
TypeId = p.TypeId,
TypeName = p.A_NewsType.Name,
Remarks = p.Remarks,
CreateTime = p.CreateTime,
HitTimes = p.HitTimes,
ConvertImg = p.ConvertPic,
EidtAuthorName = p.EidtName,
CheckedStatus = p.CheckedStatus,
UpTime = p.UpTime,
SalePrice = p.SalePrices
}).Skip(SModel.PageSize * SModel.PageIndex).Take(SModel.PageSize).ToList();
return(List);
}
}
//根据文章Id获取内容
public NewsModel GetDetailById(int Id)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.A_News.Where(k => k.Id == Id)
select new NewsModel
{
Id = p.Id,
Name = p.Name,
TypeId = p.TypeId,
TypeName = p.A_NewsType.Name,
Remarks = p.Remarks,
ConvertImg = p.ConvertPic,
CreateTime = p.CreateTime,
KeyWord = p.KeyWord,
StrContent = p.StrContent,
HitTimes = p.HitTimes,
UpTime = p.UpTime,
SalePrice = p.SalePrices
}).SingleOrDefault();
tables.GalleryItems = GetNewsImgs(Id);
UpdateNewsHittimes(Id);
return(tables);
}
}
public void BackPassword(string Telphone, string NewPassword)
{
using (var db = new HTJKEntities())
{
var tablse = db.MemberInfo.Where(k => k.Telphone == Telphone && k.State == true).FirstOrDefault();
tablse.Password = NewPassword;
db.SaveChanges();
}
}
public void ChangPassword(Guid MemberId, string NewPassword)
{
using (var db = new HTJKEntities())
{
var tablse = db.MemberInfo.Where(k => k.Id == MemberId).SingleOrDefault();
tablse.Password = NewPassword;
db.SaveChanges();
}
}
public void DelOrderById(int Id)
{
using (var db = new HTJKEntities())
{
var tables = db.OrderInfo.Where(k => k.Id == Id).SingleOrDefault();
tables.State = false;
db.SaveChanges();
}
}
public void UpdateNewsHittimes(int Id)
{
using (var db = new HTJKEntities())
{
var tables = db.A_News.Where(k => k.Id == Id).SingleOrDefault();
tables.HitTimes = tables.HitTimes + 1;
db.SaveChanges();
}
}
//更新会员信息阅读状态
public void UpdateMemberMessageState(Guid UserId)
{
using (var db = new HTJKEntities())
{
var list = db.MemberMessage.Where(k => k.State == true && k.MemberId == UserId).ToList();
foreach (var item in list)
{
item.IsRead = true;
}
db.SaveChanges();
}
}
//获取随机的几条新闻
public List <NewsModel> GetRandomNewsList(int GenresId, int PageCount)
{
using (var db = new HTJKEntities())
{
string StrSql = string.Format(@"select top({0}) n.Id,n.Name,n.ConvertPic as ConvertImg,n.CreateTime,Remarks,HitTimes,m.Name as TypeName
from A_News n left join A_NewsType m on n.TypeId=m.Id where m.ParentId='{1}' and n.State='1' order by newid()", PageCount, GenresId);
var list = db.Database.SqlQuery <NewsModel>(StrSql).ToList();
return(list);
}
}
public string GetUserMenuByUserId(int UserId)
{
using (var db = new HTJKEntities())
{
string Return = "";
var StrMenu = db.A_Role.Where(k => k.UserId == UserId).FirstOrDefault();
if (StrMenu != null)
{
Return = StrMenu.MenuList;
}
return(Return);
}
}
public void UpdateOrder(string OrderNumber)
{
using (var db = new HTJKEntities())
{
var tables = db.OrderInfo.Where(k => k.Ordernum == OrderNumber).SingleOrDefault();
tables.PayState = true;
var Usertables = db.MemberInfo.Where(k => k.Id == tables.MemberId).SingleOrDefault();
Usertables.Gold = Usertables.Gold - tables.DKGold;
Usertables.ZStock = Usertables.ZStock - tables.DKStock;
db.SaveChanges();
}
}
public void AddOrderProducts(HTJKEntities db, OrderProductsModels OPModels)
{
var PrTables = new OrderProductsInfo();
PrTables.Id = Guid.NewGuid();
PrTables.Ordernum = OPModels.Ordernum;
PrTables.ProductsId = OPModels.ProductsId;
PrTables.Amount = OPModels.Amount;
PrTables.SalePrice = OPModels.Saleprice;
PrTables.ProductsName = OPModels.ProductsName;
PrTables.ProductsConvertImg = OPModels.ProductsConvertImg;
db.OrderProductsInfo.Add(PrTables);
}
//操作日志
public void AddWorkLogs(WorkLogsModel tables)
{
using (var db = new HTJKEntities())
{
var WorkLogs = new WorkLogs();
WorkLogs.UserId = tables.UserId;
WorkLogs.UserName = tables.UserName;
WorkLogs.MSG = tables.MSG;
WorkLogs.MSGStatus = tables.MSGStatus;
WorkLogs.CreateTime = DateTime.Now;
db.WorkLogs.Add(WorkLogs);
db.SaveChanges();
}
}
//
public OrderModel GetOrderDetail(string OrderId)
{
using (var db = new HTJKEntities())
{
var tabel = (from p in db.OrderInfo.Where(k => k.Ordernum == OrderId)
select new OrderModel
{
Ordernum = p.Ordernum,
TotalPrice = p.TotalPrice,
SubtractPrice = p.SubtractPrice
}).FirstOrDefault();
return(tabel);
}
}
//获取一级客户、二级客户个数
public int RequestUserCount(string MemberNumber, int Request)
{
using (var db = new HTJKEntities())
{
if (Request == 1)
{
return(db.MemberInfo.Where(k => k.RequestNumber_1 == MemberNumber && k.State == true).Count());
}
else
{
return(db.MemberInfo.Where(k => k.RequestNumber_2 == MemberNumber && k.State == true).Count());
}
}
}
public bool IsSamePhone(string Phone)
{
using (var db = new HTJKEntities())
{
var table = db.MemberInfo.Where(k => k.State == true && k.Telphone == Phone).FirstOrDefault();
if (table != null)
{
return(true);
}
else
{
return(false);
}
}
}
public NewsItmeModel GetNewsType(int TypeId)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.A_NewsType.Where(k => k.State == true)
where TypeId != null && TypeId > 0 ? p.Id == TypeId : true
orderby p.CreateTime descending
select new NewsItmeModel
{
Id = p.Id,
Name = p.Name,
}).FirstOrDefault();
return(tables);
}
}
public UsersModel GetDetailById(int Id)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.A_User.Where(k => k.Id == Id)
select new UsersModel
{
Id = p.Id,
Name = p.Name,
Telphone = p.Telphone,
Password = p.Password,
Password2 = p.Password,
}).SingleOrDefault();
return(tables);
}
}
//根据文章Id获取内容
public RoleModel GetDetailById(int Id)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.A_Role.Where(k => k.Id == Id)
select new RoleModel
{
Id = p.Id,
UserId = p.UserId,
UserName = p.UserName,
CreateTime = p.CreateTime,
MenuList = p.MenuList,
}).SingleOrDefault();
return(tables);
}
}
//设置默认地址
public void SetIsTop(int Id, Guid MemberId)
{
using (var db = new HTJKEntities())
{
var table = db.Address_Info.Where(k => k.MemberId == MemberId && k.State == true).ToList();
foreach (var item in table)
{
item.IsTop = false;
if (item.Id == Id)
{
item.IsTop = true;
}
}
db.SaveChanges();
}
}
//根据文章Id获取内容
public CategoryModel GetDetailById(int Id)
{
using (var db = new HTJKEntities())
{
var tables = (from p in db.A_NewsType.Where(k => k.Id == Id)
select new CategoryModel
{
Id = p.Id,
Name = p.Name,
Rank = p.Rank,
CreateTime = p.CreateTime,
ParentId = p.ParentId,
}).SingleOrDefault();
return(tables);
}
}
