コード例 #1
0
 public Tuple<model.Product, List<model.ImageList>> Details(string id)
 {
     var sqlProduct = "select * from Product where Id='" + id + "'";
     var sqlImgList = "select * from ImageList where ProductId='" + id + "'";
     var product = new model.Product();
     using (var sReader = SqlDBHelper.ExecuteReader(sqlProduct))
     {
         while (sReader.Read())
         {
             product.Id = sReader["Id"].ToString();
             product.CategoryId = sReader["CategoryId"].ToString();
             product.Name = sReader["Name"].ToString();
             product.Description = sReader["Description"].ToString();
             product.ImgSrc = sReader["ImgSrc"].ToString();
             product.CreateTime = Convert.ToDateTime(sReader["CreateTime"]);
         }
     }
     List<model.ImageList> list = new List<model.ImageList>();
     using (var sReader = SqlDBHelper.ExecuteReader(sqlImgList))
     {
         while (sReader.Read())
         {
             var img = new model.ImageList
             {
                 Id = sReader["Id"].ToString(),
                 ProductId = sReader["ProductId"].ToString(),
                 ImgSrc = sReader["ImgSrc"].ToString()
             };
             list.Add(img);
         }
     }
     return Tuple.Create<model.Product, List<model.ImageList>>(product, list);
 }
コード例 #2
0
 public JsonResult Edit(Product product)
 {
     var total = 0;
     var pro = pService.GetList(1, int.MaxValue, out total).FirstOrDefault(x => x.Id == product.Id);
     product.CreateTime = pro.CreateTime;
     if (product.CategoryId.Length < 36)
         product.CategoryId = pro.CategoryId; //Request.Form["CategoryId"];
     if (new BaseService().Update<Product>(product))
         return Json(new { flag = true, msg = "修改成功!" });
     return Json(new { flag = false, msg = "修改失败" });
 }
コード例 #3
0
        public JsonResult AddNew(Product product)
        {
            try
            {
                if (product != null)
                {
                    product.Id = Guid.NewGuid().ToSafeTrim();
                    product.CreateTime = DateTime.Now;
                    if (new BaseService().Insert<Product>(product))
                        return Json(new { flag = true, msg = "添加成功" });
                }
                return Json(new { flag = false, msg = "添加失败" });
            }
            catch (Exception e)
            {
                return Json(new { flag = false, msg = "发生异常" });

            }
        }
コード例 #4
0
 public List<model.Product> GetList(int page, int size, out int total)
 {
     var sql = "select * from Product order by CreateTime DESC";
     List<model.Product> list = new List<model.Product>();
     using (var sReader = SqlDBHelper.ExecuteReader(sql))
     {
         while (sReader.Read())
         {
             var product = new model.Product
             {
                 Id = sReader["Id"].ToString(),
                 CategoryId = sReader["CategoryId"].ToString(),
                 Description = sReader["Description"].ToString(),
                 CreateTime = Convert.ToDateTime(sReader["CreateTime"]),
                 ImgSrc = sReader["ImgSrc"].ToString(),
                 Name = sReader["Name"].ToString()
             };
             list.Add(product);
         }
     }
     total = list.Count;
     return list.Skip(size * (page - 1)).Take(size).ToList();
 }
コード例 #5
0
 public List<model.Product> GetListByCategory(string categoryId)
 {
     var sql = "select * from Product where CategoryId='" + categoryId + "' order by CreateTime DESC";
     List<model.Product> list = new List<model.Product>();
     using (var sReader = SqlDBHelper.ExecuteReader(sql))
     {
         while (sReader.Read())
         {
             var product = new model.Product
             {
                 Id = sReader["Id"].ToString(),
                 CategoryId = sReader["CategoryId"].ToString(),
                 Description = sReader["Description"].ToString(),
                 CreateTime = Convert.ToDateTime(sReader["CreateTime"]),
                 ImgSrc = sReader["ImgSrc"].ToString(),
                 Name = sReader["Name"].ToString()
             };
             list.Add(product);
         }
     }
     return list;
 }