public int UpdUserRoder(Dictionary <string, object> dic)
{
using (CommercedataContext context = new CommercedataContext())
{
UserRoderInfo info = JsonConvert.DeserializeObject <UserRoderInfo>(dic["obj"].ToString());
string token = dic["token"].ToString();
if (token == "undefined")
{
return(0);
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return(0);
}
string SupplierId = ue.SuppLierId;
var list = (from s in context.UserRoderInfo where s.SuppLierId == SupplierId select s).FirstOrDefault();
list.ShopName = info.ShopName;
list.ShopAddress = info.ShopAddress;
list.ContactName = info.ContactName;
list.CortactPhone = info.CortactPhone;
list.Mail = info.Mail;
list.TrueName = info.TrueName;
context.UserRoderInfo.Update(list);
//context.Set<UserRoderInfo>().Where(n=>n.SuppLierId.Equals(SupplierId)).Update(info);
//context.Entry<UserRoderInfo>(info).State = EntityState.Modified;
return(context.SaveChanges());
}
}
public string Show(string type, string actor, string bookname)
{
CommercedataContext context = new CommercedataContext();
var list = (from f in context.SupplierBookInfo
join
s in context.BookInfo on f.Isbn equals s.Isbn
join
t in context.NextClassType on s.NclassId equals t.NclassId
join
fs in context.AuthorInfo on s.AuthorId equals fs.AuthorId
select new { bookName = s.Title, actoreName = fs.Aname, chuBan = s.Publish, time = Convert.ToDateTime(s.PublishTime), price = s.Price, zhe = f.Discount, shangJia = f.SupplierId, bookBian = f.Isbn, bookType = t.NclassName }).ToList();
if (type != null)
{
list = list.Where(s => s.bookType.Equals(type)).ToList();
}
if (actor != null)
{
list = list.Where(s => s.actoreName.Equals(actor)).ToList();
}
if (bookname != null)
{
list = list.Where(s => s.bookName.Equals(bookname)).ToList();
}
string str = "";
Dictionary <string, object> obje = new Dictionary <string, object>();
obje.Add("data", list);
obje.Add("count", list.Count);
str = JsonConvert.SerializeObject(obje);
return(str);
}
public string GetGoodSH(string token = "", int pageName = 1, int limitName = 10)
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return("");
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return("");
}
string SupplierId = ue.SuppLierId;
var list = (from da in context.OrderItems
join du in context.UserorderRecound
on da.OrderId equals du.OrderId
join dd in context.SupplierBookInfo
on da.SupplierId equals dd.SupplierId
where da.SupplierId == SupplierId && du.DelivaeryStatue == "待确认收货"
select new { da.Isbn, da.SupplierId, da.BookName, da.BookPrice, da.Quantity, da.Statue, du.OrderId, du.BuyNum, du.ConsigName, du.ClinchTime, du.PayStatues, du.OrderStatue, du.DelivaeryStatue }).Distinct().ToList();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("data", list);
dic.Add("count", list.Count);
return(JsonConvert.SerializeObject(dic));
}
}
public int UpdBook(Dictionary <string, object> dic)
{
using (CommercedataContext context = new CommercedataContext())
{
SupplierBookInfo info = JsonConvert.DeserializeObject <SupplierBookInfo>(dic["obj"].ToString());
string token = dic["token"].ToString();
if (token == "undefined")
{
return(0);
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return(0);
}
string SupplierId = ue.SuppLierId;
var list = (from s in context.SupplierBookInfo where s.Isbn == info.Isbn select s).FirstOrDefault();
list.Price = info.Price;
list.Discount = info.Discount;
list.TotalQuantity = info.TotalQuantity;
list.BookType = info.BookType;
context.SupplierBookInfo.Update(list);
return(context.SaveChanges());
}
}
public int AddOrder(OrderItems addOrder)
{
int count = 0;
CommercedataContext context = new CommercedataContext();
OrderItems item = new OrderItems();
item.BookName = addOrder.BookName;
item.BookPrice = addOrder.BookPrice;
item.Isbn = addOrder.Isbn;
item.OrderId = addOrder.OrderId;
item.OrderitemId = addOrder.OrderitemId;
item.Quantity = 1;
item.Statue = "未支付";
item.SupplierId = addOrder.SupplierId;
List <OrderItems> list = context.OrderItems.ToList();
list = list.Where(s => s.OrderitemId.Equals(addOrder.OrderitemId) && s.OrderId.Equals(addOrder.OrderId)).ToList();
if (list.Count != 0)
{
return(0);
}
context.OrderItems.Add(item);
count = context.SaveChanges();
return(count);
}
public string GetBookInfo(string typeId, string authorName = "", string title = "", string pubish = "", int pageName = 1, int limitName = 10)
{
using (CommercedataContext context = new CommercedataContext())
{
var list = (from da in context.BookInfo
join du in context.AuthorInfo
on da.AuthorId equals du.AuthorId
join dd in context.NextClassType
on da.NclassId equals dd.NclassId
where dd.NclassId == typeId
select new { da.Isbn, da.Title, da.Publish, da.PublishTime, da.Price, du.AuthorId, du.Aname, dd.NclassId, dd.NclassName }).ToList();
if (!string.IsNullOrEmpty(authorName))
{
list = list.Where(n => n.Aname.Contains(authorName)).ToList();
}
if (!string.IsNullOrEmpty(title))
{
list = list.Where(n => n.Title.Contains(title)).ToList();
}
if (!string.IsNullOrEmpty(pubish))
{
list = list.Where(n => n.Publish.Contains(pubish)).ToList();
}
var slist = list.Skip((pageName - 1) * limitName).Take(limitName).ToList();
Dictionary <string, object> obj = new Dictionary <string, object>();
//前台通过key值获得对应的value值
obj.Add("code", 0);
obj.Add("msg", "");
obj.Add("count", list.Count);
obj.Add("data", slist);
return(JsonConvert.SerializeObject(obj));
}
}
public int InsertBook(Dictionary <string, object> dic)
{
using (CommercedataContext context = new CommercedataContext())
{
SupplierBookInfo info = JsonConvert.DeserializeObject <SupplierBookInfo>(dic["obj"].ToString());
string token = dic["token"].ToString();
if (token == "undefined")
{
return(0);
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return(0);
}
string SupplierId = ue.SuppLierId;
var list = (from s in context.SupplierBookInfo where s.Isbn == info.Isbn select s).FirstOrDefault();
if (list == null)
{
info.Score = 0;
info.SaledQuantity = 0;
info.BookStues = "未出售";
info.SupplierId = SupplierId;
context.SupplierBookInfo.Add(info);
return(context.SaveChanges());
}
else
{
return(0);
}
}
}
public List <NextClassType> GetTypeData()
{
using (CommercedataContext context = new CommercedataContext())
{
List <NextClassType> list = context.NextClassType.ToList();
return(list);
}
}
public int DelBookData(string Isbn)
{
using (CommercedataContext context = new CommercedataContext())
{
var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault();
context.SupplierBookInfo.Remove(list);
return(context.SaveChanges());
}
}
public int UpdaBookSate(string Isbn)
{
using (CommercedataContext context = new CommercedataContext())
{
var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault();
list.BookStues = "出售中";
context.SupplierBookInfo.Update(list);
return(context.SaveChanges());
}
}
public string GetBookData(string Isbn)
{
using (CommercedataContext context = new CommercedataContext())
{
var list = (from da in context.BookInfo
join du in context.AuthorInfo
on da.AuthorId equals du.AuthorId
join dd in context.NextClassType
on da.NclassId equals dd.NclassId
where da.Isbn == Isbn
select new { da.Isbn, da.Title, da.Publish, da.PublishTime, da.Price, da.Revision, da.Page, du.AuthorId, du.Aname, dd.NclassId, dd.NclassName }).FirstOrDefault();
return(JsonConvert.SerializeObject(list));
}
}
public string GetGoodPJ(string token = "", int pageName = 1, int limitName = 10)
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return("");
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return("");
}
string SupplierId = ue.SuppLierId;
var list = (from da in context.ReplyInfo
join dd in context.SupplierBookInfo
on da.SupplierId equals dd.SupplierId
where da.SupplierId == SupplierId
select new { da.Isbn, da.Replay }).ToList().GroupBy(a => a.Isbn).Select(a =>
new ReplyModel
{
Isbn = a.Key,
ReplyA = (from s in a select s.Replay).ToList()
}
);
//var listResult = from s in list
// select new ReplyModel
// {
// Isbn = s.Key,
// ReplyA = (from a in s select a.Replay).ToList()
// };
// select new ReplyModel { ReplyA = new List<ReplyInfo> { new ReplyInfo { Replay = g.v } }, Isbn = g.Key.Isbn }).ToList();
//var query = list.GroupBy(s => s.Isbn).Select(x => x.First()).ToList();
//var linq=from s in context.ReplyInfo where
//string ss= JsonConvert.SerializeObject(list);
//ReplyInfo reply = JsonConvert.DeserializeObject<ReplyInfo>(ss);
//var query = reply.DistinctBy(p=>p.Isbn);
//Dictionary<string, object> dic = new Dictionary<string, object>();
//dic.Add("data", list);
//dic.Add("count", list.Count);
return(JsonConvert.SerializeObject(list));
}
}
public string GetCkBookData(string Isbn)
{
using (CommercedataContext context = new CommercedataContext())
{
var list = (from da in context.BookInfo
join du in context.AuthorInfo
on da.AuthorId equals du.AuthorId
join dc in context.NextClassType
on da.NclassId equals dc.NclassId
join dd in context.SupplierBookInfo
on da.Isbn equals dd.Isbn
select new { da.Isbn, da.Title, da.Publish, da.PublishTime, dd.Price, dd.TotalQuantity, dd.Discount, dd.BookType, dd.SaledQuantity, dd.BookStues, du.AuthorId, du.Aname, dc.NclassName }).FirstOrDefault();
return(JsonConvert.SerializeObject(list));
}
}
public string GetCkZBookInfo(string token = "", string authorName = "", string title = "", string pubish = "", int pageName = 1, int limitName = 10)
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return("");
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return("");
}
string SupplierId = ue.SuppLierId;
var list = (from da in context.BookInfo
join du in context.AuthorInfo
on da.AuthorId equals du.AuthorId
join dd in context.SupplierBookInfo
on da.Isbn equals dd.Isbn
where dd.BookStues == "出售中" && dd.SupplierId == SupplierId
select new { da.Isbn, da.Title, da.Publish, da.PublishTime, dd.Price, dd.TotalQuantity, dd.Discount, dd.BookType, dd.SaledQuantity, dd.BookStues, du.AuthorId, du.Aname }).ToList();
if (!string.IsNullOrEmpty(authorName))
{
list = list.Where(n => n.Aname.Contains(authorName)).ToList();
}
if (!string.IsNullOrEmpty(title))
{
list = list.Where(n => n.Title.Contains(title)).ToList();
}
if (!string.IsNullOrEmpty(pubish))
{
list = list.Where(n => n.Publish.Contains(pubish)).ToList();
}
var slist = list.Skip((pageName - 1) * limitName).Take(limitName).ToList();
Dictionary <string, object> obj = new Dictionary <string, object>();
//前台通过key值获得对应的value值
obj.Add("code", 0);
obj.Add("msg", "");
obj.Add("count", list.Count);
obj.Add("data", slist);
return(JsonConvert.SerializeObject(obj));
}
}
public int AddGuan(ManageInfo manageInfo)
{
int count = 0;
CommercedataContext context = new CommercedataContext();
List <ManageInfo> list = context.ManageInfo.ToList();
list = list.Where(s => s.ManageId.Equals(manageInfo.ManageId)).ToList();
if (list.Count != 0)
{
return(0);
}
context.ManageInfo.Add(manageInfo);
count = context.SaveChanges();
return(count);
}
public int AddGong(UserRoderInfo userRoder)
{
int count = 0;
CommercedataContext context = new CommercedataContext();
userRoder.RegDate = DateTime.Now;
List <UserRoderInfo> list = context.UserRoderInfo.ToList();
list = list.Where(s => s.SuppLierId.Equals(userRoder.SuppLierId)).ToList();
if (list.Count != 0)
{
return(0);
}
context.UserRoderInfo.Add(userRoder);
count = context.SaveChanges();
return(count);
}
public int AddGu(Customer customer)
{
int count = 0;
CommercedataContext context = new CommercedataContext();
customer.UserReddate = DateTime.Now;
List <Customer> list = context.Customer.ToList();
list = list.Where(s => s.AccountId.Equals(customer.AccountId)).ToList();
if (list.Count != 0)
{
return(0);
}
context.Customer.Add(customer);
count = context.SaveChanges();
return(count);
}
public string GetUserRoder(string token = "")
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return("");
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return("");
}
string SupplierId = ue.SuppLierId;
var list = (from s in context.UserRoderInfo where s.SuppLierId == SupplierId select s).FirstOrDefault();
return(JsonConvert.SerializeObject(list));
}
}
public int UpdGoodFH(string token = "", string orderId = "")
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return(0);
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return(0);
}
var list = context.UserorderRecound.Where(n => n.OrderId.Equals(orderId)).FirstOrDefault();
list.OrderStatue = "已发货";
context.UserorderRecound.Update(list);
return(context.SaveChanges());
}
}
public int UpdxBookSate(string token, string Isbn)
{
using (CommercedataContext context = new CommercedataContext())
{
if (token == "undefined")
{
return(0);
}
JWTHelper jWT = new JWTHelper();
UserRoderInfo user = JsonConvert.DeserializeObject <UserRoderInfo>(jWT.GetPayload(token));
var ue = context.UserRoderInfo.Where(n => n.ContactName.Equals(user.ContactName) && n.SupplierPwd.Equals(user.SupplierPwd)).FirstOrDefault();
if (ue == null)
{
return(0);
}
string SupplierId = ue.SuppLierId;
var list = (from s in context.SupplierBookInfo where s.Isbn == Isbn select s).FirstOrDefault();
list.BookStues = "未出售";
context.SupplierBookInfo.Update(list);
return(context.SaveChanges());
}
}
public LoginClass Login(LoginClass login)
{
CommercedataContext context = new CommercedataContext();
LoginClass ret = new LoginClass();
JWTHelper jwtHeader = new JWTHelper();
string jiami = "";
List <Customer> client = new List <Customer>();
List <UserRoderInfo> supplier = new List <UserRoderInfo>();
List <ManageInfo> Administrator = new List <ManageInfo>();
if (login.Table == "Customer")
{
client = context.Customer.ToList();
if (!string.IsNullOrEmpty(login.AccountName))
{
client = client.Where(s => s.AccountName.Equals(login.AccountName.Trim())).ToList();
}
if (!string.IsNullOrEmpty(login.AccountPwd))
{
client = client.Where(s => s.AccountPwd.Equals(login.AccountPwd.Trim())).ToList();
}
if (client.Count == 1)
{
Dictionary <string, object> keys = new Dictionary <string, object>();
keys.Add("AccountName", client[0].AccountName);
keys.Add("TouMoney", client[0].AccountPwd);
keys.Add("AccountId", client[0].AccountId);
jiami = jwtHeader.GetToken(keys, 600000);
ret.AccountName = login.AccountName;
ret.AccountPwd = login.AccountPwd;
ret.Quan = "顾客";
ret.Encipherment = jiami;
ret.Name = client[0].UserName;
}
return(ret);
}
if (login.Table == "UserRoderInfo")
{
supplier = context.UserRoderInfo.ToList();
if (!string.IsNullOrEmpty(login.AccountName))
{
supplier = supplier.Where(s => s.ContactName.Equals(login.AccountName.Trim())).ToList();
}
if (!string.IsNullOrEmpty(login.AccountPwd))
{
supplier = supplier.Where(s => s.SupplierPwd.Equals(login.AccountPwd.Trim())).ToList();
}
if (supplier.Count == 1)
{
Dictionary <string, object> keys = new Dictionary <string, object>();
keys.Add("ContactName", supplier[0].ContactName);
keys.Add("SupplierPwd", supplier[0].SupplierPwd);
keys.Add("SuppLierID", supplier[0].SuppLierId);
jiami = jwtHeader.GetToken(keys, 600000);
ret.AccountName = login.AccountName;
ret.AccountPwd = login.AccountPwd;
ret.Quan = "供应商";
ret.Encipherment = jiami;
ret.Name = supplier[0].TrueName;
}
return(ret);
}
if (login.Table == "ManageInfo")
{
Administrator = context.ManageInfo.ToList();
if (!string.IsNullOrEmpty(login.AccountName))
{
Administrator = Administrator.Where(s => s.ManagerUserName.Equals(login.AccountName.Trim())).ToList();
}
if (!string.IsNullOrEmpty(login.AccountPwd))
{
Administrator = Administrator.Where(s => s.ManagerPwd.Equals(login.AccountPwd.Trim())).ToList();
}
if (Administrator.Count == 1)
{
Dictionary <string, object> keys = new Dictionary <string, object>();
keys.Add("ManagerUserName", Administrator[0].ManagerUserName);
keys.Add("ManagerPwd", Administrator[0].ManagerPwd);
keys.Add("ManageId", Administrator[0].ManageId);
jiami = jwtHeader.GetToken(keys, 600000);
ret.AccountName = login.AccountName;
ret.AccountPwd = login.AccountPwd;
ret.Quan = "管理员";
ret.Encipherment = jiami;
ret.Name = Administrator[0].ManagerUserName;
}
return(ret);
}
else
{
return(ret);
}
}
