예제 #1
0
        /// <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);
        }
예제 #2
0
        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());
            }
        }
예제 #3
0
        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);
                }
            }
        }
예제 #4
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));
            }
        }
예제 #5
0
        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());
            }
        }
예제 #6
0
        public int ModifyInfo(string mode)
        {
            UserRoderInfo mods = JsonConvert.DeserializeObject <UserRoderInfo>(mode);



            return(dal.ModifyRoderInfo(mods));
        }
예제 #7
0
        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));
            }
        }
예제 #8
0
        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));
            }
        }
예제 #9
0
        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);
        }
예제 #10
0
        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));
            }
        }
예제 #11
0
        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());
            }
        }
예제 #12
0
        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());
            }
        }
예제 #13
0
 /// <summary>
 /// 修改商家信息
 /// </summary>
 /// <param name="mode"></param>
 /// <returns></returns>
 public int ModifyRoderInfo(UserRoderInfo mode)
 {
     return(Roder.Modify(mode));
 }
예제 #14
0
 /// <summary>
 /// 注册商家信息
 /// </summary>
 /// <param name="mode"></param>
 /// <returns></returns>
 public int AddRoderInfo(UserRoderInfo mode)
 {
     return(Roder.Add(mode));
 }