/// <summary>
/// 反填商家信息
/// </summary>
/// <returns></returns>
public UserRoderInfo ModifySupplier(string suppliserid)
{
var listsupplier = dal.AllRoderInfo().ToList();
UserRoderInfo mode = listsupplier.Where(m => m.SuppLierId.Contains(suppliserid)).FirstOrDefault();
//if (mode.AllSaledAccount >= 1000 && mode.AllSaledAccount <= 2000)
//{
// mode.QuanTity = 40;
// mode.SuoolierType = "会员商家";
//}
//else if (mode.AllSaledAccount < 1000)
//{
// mode.QuanTity = 20;
// mode.SuoolierType = "普通商家";
//}
//else
//{
// mode.QuanTity = 60;
// mode.SuoolierType = "超级商家";
//}
return(mode);
}
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 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 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 ModifyInfo(string mode)
{
UserRoderInfo mods = JsonConvert.DeserializeObject <UserRoderInfo>(mode);
return(dal.ModifyRoderInfo(mods));
}
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 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 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 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());
}
}
/// <summary>
/// 修改商家信息
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public int ModifyRoderInfo(UserRoderInfo mode)
{
return(Roder.Modify(mode));
}
/// <summary>
/// 注册商家信息
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public int AddRoderInfo(UserRoderInfo mode)
{
return(Roder.Add(mode));
}
