//用户登录
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(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 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 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 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 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 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 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 AddOrUpdateAddress(AddressModel models, out int AId)
{
using (var db = new HTJKEntities())
{
if (models.Id > 0)
{
var tables = db.Address_Info.Where(k => k.Id == models.Id).FirstOrDefault();
tables.Name = models.Name;
tables.Telphone = models.Telphone;
tables.Province = models.Province;
tables.City = models.City;
tables.Region = models.Region;
tables.MemberId = models.MemberId;
tables.addressNo = models.addressNo;
AId = models.Id;
db.SaveChanges();
}
else
{
var table = db.Address_Info.Where(k => k.MemberId == models.MemberId && k.State == true).ToList();
foreach (var item in table)
{
item.IsTop = false;
}
db.SaveChanges();
var tables = new Address_Info();
tables.Name = models.Name;
tables.Telphone = models.Telphone;
tables.Province = models.Province;
tables.City = models.City;
tables.Region = models.Region;
tables.MemberId = models.MemberId;
tables.addressNo = models.addressNo;
tables.IsTop = true;
tables.CreateTime = DateTime.Now;
tables.State = true;
db.Address_Info.Add(tables);
db.SaveChanges();
AId = tables.Id;
}
}
}
//更新会员信息阅读状态
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 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 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 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();
}
}
public void AddMessage(MessageModel Models)
{
using (var db = new HTJKEntities())
{
var Tabels = new MemberMessage();
Tabels.Id = Guid.NewGuid();
Tabels.StrContent = Models.StrContent;
Tabels.CreateTime = DateTime.Now;
Tabels.IsRead = false;
Tabels.UserName = Models.UserName;
Tabels.State = true;
Tabels.MemberId = Models.UserId;
db.MemberMessage.Add(Tabels);
db.SaveChanges();
}
}
public void DeleteMore(string ListId)
{
using (var db = new HTJKEntities())
{
string[] ArrId = ListId.Split('$');
foreach (var item in ArrId)
{
if (!string.IsNullOrEmpty(item))
{
int Id = Convert.ToInt32(item);
var tables = db.A_Role.Where(k => k.Id == Id).SingleOrDefault();
tables.DeleteFlag = false;
}
}
db.SaveChanges();
}
}
public void AddOrder(OrderModel models)
{
using (var db = new HTJKEntities())
{
if (models.Carts != null)
{
var tables = new OrderInfo();
tables.Ordernum = models.Ordernum;
tables.AddressId = models.AddressId;
tables.MemberId = models.MemberId;
tables.DKGold = models.DKGold;
tables.DKStock = models.DKStock;
tables.DKPrce = models.DKPrce;
tables.YunFei = models.YunFei;
tables.CreateTime = DateTime.Now;
tables.PayState = false;
tables.State = true;
tables.TotalPrice = models.TotalPrice;
tables.SubtractPrice = 0;
tables.Remarks = models.Remarks;
db.OrderInfo.Add(tables);
OrderProductsModels OPModels = new OrderProductsModels();
foreach (var item in models.Carts)
{
OPModels.Ordernum = models.Ordernum;
OPModels.ProductsId = item.Product.Id;
OPModels.Amount = item.Amount;
OPModels.Saleprice = Convert.ToDecimal(item.Product.SalePrice);
OPModels.ProductsName = item.Product.Name;
OPModels.ProductsConvertImg = item.Product.ConvertImg;
AddOrderProducts(db, OPModels);
using (var prdb = new HTJKEntities())
{
var proTab = prdb.A_News.Where(k => k.Id == item.Product.Id).SingleOrDefault();
if (proTab != null)
{
proTab.SaleCount = proTab.SaleCount ?? 0 + item.Amount;
}
prdb.SaveChanges();
}
}
db.SaveChanges();
}
}
}
public bool UpdatePhone(string Phone, string password, Guid UserId)
{
using (var db = new HTJKEntities())
{
var table = db.MemberInfo.Where(k => k.Id == UserId).FirstOrDefault();
if (table != null)
{
table.Telphone = Phone;
table.Password = password;
table.State = true;
db.SaveChanges(); return(true);
}
else
{
return(false);
}
}
}
public LoginModel IsLogin(string UserCode, string PassWord, string openId)
{
LoginModel UserModels = new LoginModel();
string TuserName = "";
string telphone = "";
if (IsCount(UserCode) == true)
{
telphone = UserCode;
}
else
{
TuserName = UserCode;
}
using (var db = new HTJKEntities())
{
var Tables = (from p in db.MemberInfo.Where(k => k.State == true && k.Password == PassWord)
where !string.IsNullOrEmpty(TuserName) ? p.userName == TuserName : true
where !string.IsNullOrEmpty(telphone) ? p.Telphone == telphone : true
select p).FirstOrDefault();
if (Tables != null)
{
UserModels.UserName = Tables.userName;
UserModels.MemberId = Tables.Id;
UserModels.MemberNumber = Tables.MemberNumber;
UserModels.IsLogin = true;
Tables.LoginTimes = Tables.LoginTimes + 1;
Tables.LastLoginTime = DateTime.Now;
if (string.IsNullOrEmpty(Tables.OpenId))
{
if (string.IsNullOrEmpty(openId))
{
Tables.OpenId = openId;
}
}
db.SaveChanges();
}
}
return(UserModels);
}
public void CheckedMore(string ListId, int CheckedId, int UserId)
{
using (var db = new HTJKEntities())
{
string[] ArrId = ListId.Split('$');
foreach (var item in ArrId)
{
if (!string.IsNullOrEmpty(item))
{
int Id = Convert.ToInt32(item);
var tables = db.A_News.Where(k => k.Id == Id).SingleOrDefault();
if (tables.CheckedStatus == 0)
{
tables.CheckedStatus = CheckedId;
tables.CheckedUserId = UserId;
}
}
}
db.SaveChanges();
}
}
public LoginModel IsWXLogin(string openId)
{
LoginModel UserModels = new LoginModel();
using (var db = new HTJKEntities())
{
var Tables = (from p in db.MemberInfo.Where(k => k.State == true && k.OpenId == openId)
select p).FirstOrDefault();
if (Tables != null)
{
UserModels.UserName = Tables.userName;
UserModels.MemberId = Tables.Id;
UserModels.MemberNumber = Tables.MemberNumber;
UserModels.IsLogin = true;
Tables.LoginTimes = Tables.LoginTimes + 1;
Tables.LastLoginTime = DateTime.Now;
db.SaveChanges();
}
}
return(UserModels);
}
//新增和修改仓库设置
public void AddOrUpdate(RoleModel Models)
{
using (var db = new HTJKEntities())
{
if (Models.Id > 0)
{
var table = db.A_Role.Where(k => k.Id == Models.Id).SingleOrDefault();
table.UserId = Models.UserId;
table.UserName = Models.UserName;
table.MenuList = Models.MenuList;
}
else
{
A_Role table = new A_Role();
table.UserId = Models.UserId;
table.UserName = Models.UserName;
table.MenuList = Models.MenuList;
table.CreateTime = DateTime.Now;
table.DeleteFlag = true;
db.A_Role.Add(table);
}
db.SaveChanges();
}
}
//添加和修改用户信息
public void AddUser(MemberModel Models, out Guid UserId, out string MemberNumber)
{
string Mn = "";
Guid UId = Guid.Empty;
using (var db = new HTJKEntities())
{
int Stoct = 0;
if (Models.Id != null && Models.Id != Guid.Empty)
{
var Tabels = db.MemberInfo.Where(k => k.Id == Models.Id).FirstOrDefault();
Tabels.userName = Models.Name;
Tabels.RealName = Models.RealName;
Tabels.Telphone = Models.Telphone;
Tabels.Age = Models.Age;
Tabels.Email = Models.Email;
Tabels.Sex = Models.Sex;
Tabels.Stock = Tabels.Stock > 0 ? Tabels.Stock + Stoct : Stoct;
Tabels.ZStock = Tabels.ZStock > 0 ? Tabels.ZStock + Stoct : Stoct;
}
else
{
var Tabels = new MemberInfo();
Tabels.Id = Guid.NewGuid();
Tabels.userName = Models.Name;
Tabels.RealName = Models.RealName;
Tabels.Password = Models.Password;
Tabels.Telphone = Models.Telphone;
Tabels.Email = Models.Email;
Tabels.CreateTime = DateTime.Now;
Tabels.LoginTimes = 1;
Tabels.LastLoginTime = DateTime.Now;
Tabels.Sex = Models.Sex;
Tabels.Stock = !string.IsNullOrEmpty(Models.RequestNumber) ? 100 : 20;
Tabels.ZStock = !string.IsNullOrEmpty(Models.RequestNumber) ? 100 : 20;
Tabels.AddStock = 0;
Tabels.Gold = 0;
Tabels.State = Models.RealName != null && Models.RealName == "微信注册用户" ? false : true;
Tabels.MemberNumber = "HT" + WxPayApi.GenerateTimeStamp();
Mn = Tabels.MemberNumber;
UId = Tabels.Id;
Tabels.OpenId = Models.OpenId;
if (!string.IsNullOrEmpty(Models.RequestNumber))
{
Tabels.RequestNumber_1 = Models.RequestNumber;
var Membertabel = db.MemberInfo.Where(k => k.MemberNumber == Models.RequestNumber).FirstOrDefault();
if (Membertabel != null)
{
if (Membertabel.RequestNumber_1 != null)
{
Tabels.RequestNumber_2 = Membertabel.RequestNumber_1;
}
}
}
db.MemberInfo.Add(Tabels);
}
UserId = UId;
MemberNumber = Mn;
db.SaveChanges();
}
}
public void AddWXReturnInfo(WXReturnResultModel models)
{
using (var db = new HTJKEntities())
{
var tables = new WXReturnInfo();
tables.Id = Guid.NewGuid();
tables.out_trade_no = models.out_trade_no;
tables.transaction_id = models.transaction_id;
tables.openid = models.openid;
tables.trade_type = models.trade_type;
tables.bank_type = models.bank_type;
tables.total_fee = models.total_fee;
tables.fee_type = models.fee_type;
tables.time_end = models.time_end;
tables.CreateTime = DateTime.Now;
db.WXReturnInfo.Add(tables);
var OrderNum = models.out_trade_no;
if (models.out_trade_no.Contains("abc") == true)
{
OrderNum = models.out_trade_no.Split('a')[0];
}
if (OrderNum.Contains("HT"))
{
var OrderTable = db.OrderInfo.Where(k => k.Ordernum == OrderNum).SingleOrDefault();
var Total = OrderTable.TotalPrice;
var MemberId = OrderTable.MemberId;
if (OrderTable != null)
{
OrderTable.PayState = true;
OrderTable.PayTime = DateTime.Now;
var IsRus = db.WX_Order_Commission_Logs.Where(k => k.OrderId == OrderTable.Id).SingleOrDefault();
if (IsRus == null)//判断是否结佣过
{
var Memtable = db.MemberInfo.Where(k => k.Id == MemberId).SingleOrDefault();
var MemberUser = Memtable.userName;//购买人的昵称
if (Memtable != null)
{
var RequRequestNumber_1 = Memtable.RequestNumber_1;
var RequRequestNumber_2 = Memtable.RequestNumber_2;
if (string.IsNullOrEmpty(RequRequestNumber_2) == false)
{
var RMemtable = db.MemberInfo.Where(k => k.MemberNumber == RequRequestNumber_1).FirstOrDefault();
var NewRPrice = Total * Convert.ToDecimal(0.04);
var ORprice = RMemtable.Commission ?? 0;
RMemtable.Commission = ORprice + NewRPrice;
WX_Order_Commission_Logs ComTab = new WX_Order_Commission_Logs();
ComTab.Id = Guid.NewGuid();
ComTab.MemberId = RMemtable.Id;
ComTab.MemberName = MemberUser;
ComTab.OrderNum = OrderNum;
ComTab.RequstPay = Total * Convert.ToDecimal(0.04);
ComTab.OrderPrice = Total;
ComTab.OrderId = OrderTable.Id;
ComTab.CreateTime = DateTime.Now;
db.WX_Order_Commission_Logs.Add(ComTab);
var R1Memtable = db.MemberInfo.Where(k => k.MemberNumber == RequRequestNumber_2).FirstOrDefault();
var NewR1Price = Total * Convert.ToDecimal(0.01);
var OR1price = RMemtable.Commission ?? 0;
R1Memtable.Commission = OR1price + NewR1Price;
WX_Order_Commission_Logs ComTab1 = new WX_Order_Commission_Logs();
ComTab1.Id = Guid.NewGuid();
ComTab1.MemberId = R1Memtable.Id;
ComTab1.MemberName = MemberUser;
ComTab1.OrderNum = OrderNum;
ComTab1.RequstPay = Total * Convert.ToDecimal(0.01);
ComTab1.OrderPrice = Total;
ComTab1.OrderId = OrderTable.Id;
ComTab1.CreateTime = DateTime.Now;
db.WX_Order_Commission_Logs.Add(ComTab1);
}
if (string.IsNullOrEmpty(RequRequestNumber_1) == false && string.IsNullOrEmpty(RequRequestNumber_2) == true)
{
var RMemtable = db.MemberInfo.Where(k => k.MemberNumber == RequRequestNumber_1).FirstOrDefault();
var NewRPrice = Total * Convert.ToDecimal(0.05);
var ORprice = RMemtable.Commission ?? 0;
RMemtable.Commission = ORprice + NewRPrice;
WX_Order_Commission_Logs ComTab = new WX_Order_Commission_Logs();
ComTab.Id = Guid.NewGuid();
ComTab.MemberId = RMemtable.Id;
ComTab.MemberName = MemberUser;
ComTab.OrderNum = OrderNum;
ComTab.RequstPay = Total * Convert.ToDecimal(0.05);
ComTab.OrderPrice = Total;
ComTab.OrderId = OrderTable.Id;
ComTab.CreateTime = DateTime.Now;
db.WX_Order_Commission_Logs.Add(ComTab);
}
}
}
}
}
db.SaveChanges();
}
}
public void AddOrUpdate(NewsModel Models)
{
using (var db = new HTJKEntities())
{
if (Models.Id != null && Models.Id > 0)
{
string StrSqlImg = string.Format(@"delete A_News_File where NewsId='{0}'", Models.Id);
db.Database.ExecuteSqlCommand(StrSqlImg);//先删除图片后面在添加
var table = db.A_News.Where(k => k.Id == Models.Id).SingleOrDefault();
table.Name = Models.Name;
table.TypeId = Models.TypeId;
table.Remarks = Models.Remarks;
table.KeyWord = Models.KeyWord;
table.StrContent = Models.StrContent;
table.ConvertPic = Models.ConvertImg;
table.EidtAuthorId = Models.EidtAuthorId;
table.EidtName = Models.EidtAuthorName;
table.CheckedStatus = 0;
table.UpTime = DateTime.Now;
table.SalePrices = Models.SalePrice;
db.SaveChanges();
}
else
{
A_News table = new A_News();
table.Name = Models.Name;
table.TypeId = Models.TypeId;
table.Remarks = Models.Remarks;
table.KeyWord = Models.KeyWord;
table.StrContent = Models.StrContent;
table.ConvertPic = Models.ConvertImg;
table.IsShow = false;
table.IsTop = false;
table.UpTime = DateTime.Now;
table.CreateTime = DateTime.Now;
table.HitTimes = 10;
table.State = true;
table.CheckedStatus = 0;
table.UploadAuthorId = Models.UploadAuthorId;
table.EidtAuthorId = Models.EidtAuthorId;
table.UploadName = Models.UploadName;
table.EidtName = Models.EidtAuthorName;
table.SalePrices = Models.SalePrice;
db.A_News.Add(table);
db.SaveChanges();
Models.Id = table.Id;
}
if (Models.GalleryItems != null && !string.IsNullOrEmpty(Models.GalleryItems))
{
Models.GalleryItems = Models.GalleryItems.Remove(Models.GalleryItems.Length - 1);
string[] galleryList = Models.GalleryItems.Split(';');
int i = 1;
foreach (var item in galleryList)
{
A_News_File table = new A_News_File();
table.Id = Guid.NewGuid();
table.Name = "新闻图片";
table.NewsId = Models.Id;
table.CreateTime = DateTime.Now;
table.Sequence = i;
table.PublishUrl = item.Replace("Thumbnails", "Published");
table.ThumbnailsUrl = item;
table.State = true;
db.A_News_File.Add(table);
i++;
}
db.SaveChanges();
}
}
}
