Esempio n. 1
0
        public ActionResult BindProduct(MachineProductModel machine, int? page, int? pageSize)
        {
            var pageNumber = page ?? 1;
            var size = pageSize ?? PageSize;

            using (LoveBankDBContext db = new LoveBankDBContext())
            {
                var t_d = db.T_Department;
                var t_p = db.T_Product;
                var t_m = db.T_MachineProduct;

                var list = from p in t_p
                           join d in t_d on p.DeptId equals d.Id
                           join m in t_m on p.ID equals m.ProductId into pm
                           let mlist = pm.Where(x => x.MachineId == machine.MachineId)
                           from m1 in mlist.DefaultIfEmpty()
                           select new ProductModel
                           {
                               BarCode = p.BarCode,
                               CostScore = p.CostScore,
                               Count = p.Count,
                               DeptId = p.DeptId,
                               Id = p.ID,
                               EndTime = p.EndTime,
                               MachineId = m1.MachineId,
                               Name = p.Name,
                               Price = p.Price,
                               StartTime = p.StartTime,
                               State = p.State,
                               Type = p.Type,
                               AddUserId=p.AddUserId,
                               DeptIdName=d.Name

                           };

                list = list.Where(x => x.State != RowState.删除 && x.DeptId.IndexOf(AdminUser.DeptId) > -1);
                if (!string.IsNullOrEmpty(machine.BarCode)) list = list.Where(x => x.BarCode == machine.BarCode);
                if (!string.IsNullOrEmpty(machine.ProductName)) list = list.Where(x => x.Name.Contains(machine.ProductName));
                //list = list.Where(x => x.AddUserId==AdminUser.ID);//限制只能绑定自己新增的产品

                ViewBag.MachineId = machine.MachineId;

                //return PartialView(list.OrderByDescending(x => x.Id).ToPagedList(pageNumber - 1, size));

                return View(list.OrderByDescending(x => x.Id).ToPagedList(pageNumber - 1, size));
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="machineId">
        /// 必须参数:MachineCode(机器的Id)
        /// ProductName:产品名称,可以模糊搜索
        /// BarCode:条形码
        /// </param>
        /// <param name="page"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public ActionResult App_GetProduct(MachineProductModel machine, int page = 1, int pageSize = 80)
        {
            JsonMessage retJson = new JsonMessage();
            using (LoveBankDBContext db = new LoveBankDBContext())
            {

                var t_p = db.T_Product;
                var t_mp = db.T_MachineProduct;
                var t_m = db.T_Machine;
                var t_s = db.T_SourceFile;

                string nulllogo = "http://www.24hmart.cn:8082/TeamProjectImg/20151103/661488175855828992.jpg";
                var list = from p in t_p
                           join m1 in t_mp on p.ID equals m1.ProductId
                           join m2 in t_m on m1.MachineId equals m2.ID
                           where m2.MachineCode == machine.MachineCode&&p.DeptId==m2.DeptId
                           //&&p.StartTime>=DateTime.Now
                           //&&DateTime.Now<=p.EndTime
                           && p.Count > 0
                           select new ProductModel
                           {
                               BarCode = p.BarCode,
                               CostScore = p.CostScore,
                               Count = p.Count,
                               DeptId = p.DeptId,
                               Id = p.ID,
                               EndTime = p.EndTime,
                               MachineId = m1.MachineId,
                               Name = p.Name,
                               Price = p.Price,
                               StartTime = p.StartTime,
                               State = p.State,
                               Type = p.Type,
                               Desc=p.Desc,
                                Sponsors=p.Sponsors,
                               //SourceFileList = t_s.Where(x => x.Guid == p.Guid).ToList()
                               AppSourceFileList = (from s in t_s where s.Guid == p.Guid select new AppImgUrlModel { ImgHttpUrl = s.Domain + s.Path }).ToList(),
                               AppSourceFileListLogo = (from s in t_s where s.Guid == p.LogoGuid select new AppImgUrlModel { ImgHttpUrl = s.Domain + s.Path }).ToList(),
                               //AppSourceFileListAd = (from s in t_s where s.Guid == p.AdGuid select new AppImgUrlModel { ImgHttpUrl = string.IsNullOrEmpty((s.Domain + s.Path)) ? nulllogo : (s.Domain + s.Path) }).ToList()
                               AppSourceFileListAd = (from s in t_s where s.Guid == p.AdGuid select new AppImgUrlModel { ImgHttpUrl = nulllogo }).ToList()
                           };

                list = list.Where(x => x.State != RowState.删除);
                if (!string.IsNullOrEmpty(machine.BarCode)) list = list.Where(x => x.BarCode == machine.BarCode);
                if (!string.IsNullOrEmpty(machine.ProductName)) list = list.Where(x => x.Name.Contains(machine.ProductName));

                List<ProductModel> resList = list.OrderBy(x => x.Id).ToPagedList(page - 1, pageSize).ToList();

                retJson.Status = true;
                retJson.Data = resList;
                return Json(retJson);
            }
        }