예제 #1
0
        public List <ProductStock> GetProductsByKeywords(string wareid, string keywords, string agentid, string clientid)
        {
            DataSet ds = StockDAL.BaseProvider.GetProductsByKeywords(wareid, keywords, clientid);

            List <ProductStock> list = new List <ProductStock>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                ProductStock model = new ProductStock();
                model.FillData(dr);
                model.SaleAttrValueString = "";
                if (!string.IsNullOrEmpty(model.SaleAttrValue))
                {
                    string[] attrs = model.SaleAttrValue.Split(',');
                    foreach (string attrid in attrs)
                    {
                        if (!string.IsNullOrEmpty(attrid))
                        {
                            var attr  = new ProductsBusiness().GetProductAttrByID(attrid.Split(':')[0], clientid);
                            var value = attr.AttrValues.Where(m => m.ValueID == attrid.Split(':')[1]).FirstOrDefault();
                            if (attr != null && value != null)
                            {
                                model.SaleAttrValueString += attr.AttrName + ":" + value.ValueName + ",";
                            }
                        }
                    }
                    if (model.SaleAttrValueString.Length > 0)
                    {
                        model.SaleAttrValueString = model.SaleAttrValueString.Substring(0, model.SaleAttrValueString.Length - 1);
                    }
                }
                list.Add(model);
            }
            return(list);
        }
예제 #2
0
 public ActionResult ProductDetail(string id)
 {
     var model = new ProductsBusiness().GetProductByID(id);
     ViewBag.Model = model;
     ViewBag.BrandList = new ProductsBusiness().GetBrandList(CurrentUser.ClientID);
     ViewBag.UnitList = new ProductsBusiness().GetClientUnits(CurrentUser.ClientID);
     return View();
 }
예제 #3
0
 /// <summary>
 /// 添加分类通用属性
 /// </summary>
 /// <param name="categoryid"></param>
 /// <param name="attrid"></param>
 /// <param name="type"></param>
 /// <returns></returns>
 public JsonResult AddCategoryAttr(string categoryid, string attrid, int type)
 {
     bool bl = new ProductsBusiness().AddCategoryAttr(categoryid, attrid, type, OperateIP, CurrentUser.UserID);
     JsonDictionary.Add("Status", bl);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #4
0
        /// <summary>
        /// 品牌详情
        /// </summary>
        /// <returns></returns>
        public ActionResult BrandDetail(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                return View("Brand");
            }
            Brand model = new ProductsBusiness().GetBrandByBrandID(id);
            ViewBag.Item = model;
            ViewBag.ID = id;

            return View();
        }
예제 #5
0
 /// <summary>
 /// 加入购物车详情页
 /// </summary>
 /// <param name="pid"></param>
 /// <param name="did"></param>
 /// <param name="type"></param>
 /// <returns></returns>
 public ActionResult ChooseDetail(string pid, string did, int type = 0, string guid = "")
 {
     if (string.IsNullOrEmpty(pid))
     {
         return Redirect("ProductList");
     }
     var model = new ProductsBusiness().GetProductByIDForDetails(pid);
     if (model == null || string.IsNullOrEmpty(model.ProductID))
     {
         return Redirect("ProductList");
     }
     ViewBag.Model = model;
     ViewBag.DetailID = did;
     ViewBag.OrderType = type;
     ViewBag.GUID = guid;
     return View();
 }
예제 #6
0
        /// <summary>
        /// 过滤产品
        /// </summary>
        /// <param name="filter"></param>
        /// <returns></returns>
        public JsonResult GetProductListForShopping(string filter)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            FilterProduct model = serializer.Deserialize<FilterProduct>(filter);
            int totalCount = 0;
            int pageCount = 0;

            List<Products> list = new ProductsBusiness().GetFilterProducts(model.CategoryID, model.Attrs, model.BeginPrice, model.EndPrice, model.Keywords, model.OrderBy, model.IsAsc, 20, model.PageIndex, ref totalCount, ref pageCount, CurrentUser.ClientID);
            JsonDictionary.Add("Items", list);
            JsonDictionary.Add("TotalCount", totalCount);
            JsonDictionary.Add("PageCount", pageCount);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #7
0
 /// <summary>
 /// 保存分类
 /// </summary>
 /// <param name="category"></param>
 /// <param name="attrlist"></param>
 /// <returns></returns>
 public JsonResult SavaCategory(string category, string attrlist, string saleattr)
 {
     JavaScriptSerializer serializer = new JavaScriptSerializer();
     Category model = serializer.Deserialize<Category>(category);
     //参数
     if (!string.IsNullOrEmpty(attrlist))
     {
         attrlist = attrlist.Substring(0, attrlist.Length - 1);
     }
     //规格
     if (!string.IsNullOrEmpty(saleattr))
     {
         saleattr = saleattr.Substring(0, saleattr.Length - 1);
     }
     string caregoryid = "";
     if (string.IsNullOrEmpty(model.CategoryID))
     {
         caregoryid = new ProductsBusiness().AddCategory(model.CategoryCode, model.CategoryName, model.PID, model.Status.Value, attrlist.Split(',').ToList(), saleattr.Split(',').ToList(), model.Description, CurrentUser.UserID, CurrentUser.ClientID);
     }
     else
     {
         bool bl = new ProductsBusiness().UpdateCategory(model.CategoryID, model.CategoryName, model.Status.Value, attrlist.Split(',').ToList(), saleattr.Split(',').ToList(), model.Description, CurrentUser.UserID);
         if (bl)
         {
             caregoryid = model.CategoryID;
         }
     }
     JsonDictionary.Add("ID", caregoryid);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #8
0
        /// <summary>
        /// 保存产品
        /// </summary>
        /// <param name="product"></param>
        /// <returns></returns>
        public JsonResult SavaProduct(string product)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            Products model = serializer.Deserialize<Products>(product);

            if (!string.IsNullOrEmpty(model.AttrList))
            {
                model.AttrList = model.AttrList.Substring(0, model.AttrList.Length - 1);
            }
            if (!string.IsNullOrEmpty(model.ValueList))
            {
                model.ValueList = model.ValueList.Substring(0, model.ValueList.Length - 1);
            }
            if (!string.IsNullOrEmpty(model.AttrValueList))
            {
                model.AttrValueList = model.AttrValueList.Substring(0, model.AttrValueList.Length - 1);
            }

            string id = "";
            if (string.IsNullOrEmpty(model.ProductID))
            {
                id = new ProductsBusiness().AddProduct(model.ProductCode, model.ProductName, model.GeneralName, model.IsCombineProduct.Value == 1, model.BrandID, model.BigUnitID, model.SmallUnitID,
                                                        model.BigSmallMultiple.Value, model.CategoryID, model.Status.Value, model.AttrList, model.ValueList, model.AttrValueList,
                                                        model.CommonPrice.Value, model.Price, model.Weight.Value, model.IsNew.Value == 1, model.IsRecommend.Value == 1, model.IsAllow, model.IsAutoSend, model.EffectiveDays.Value,
                                                        model.DiscountValue.Value, model.ProductImage, model.ShapeCode, model.Description, model.ProductDetails, CurrentUser.UserID, CurrentUser.ClientID);
            }
            else
            {
                bool bl = new ProductsBusiness().UpdateProduct(model.ProductID,model.ProductCode, model.ProductName, model.GeneralName, model.IsCombineProduct.Value == 1, model.BrandID, model.BigUnitID, model.SmallUnitID,
                                                        model.BigSmallMultiple.Value, model.Status.Value, model.CategoryID, model.AttrList, model.ValueList, model.AttrValueList,
                                                        model.CommonPrice.Value, model.Price, model.Weight.Value, model.IsNew.Value == 1, model.IsRecommend.Value == 1, model.IsAllow, model.IsAutoSend, model.EffectiveDays.Value,
                                                        model.DiscountValue.Value, model.ProductImage, model.ShapeCode, model.Description, CurrentUser.UserID, CurrentUser.ClientID);
                if (bl)
                {
                    id = model.ProductID;
                }
            }
            JsonDictionary.Add("ID", id);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #9
0
 /// <summary>
 /// 设置子产品
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public ActionResult ProductDetails(string id)
 {
     var model = new ProductsBusiness().GetProductByID(id);
     ViewBag.Model = model;
     return View();
 }
예제 #10
0
        public JsonResult SavaBrand(string brand)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            Brand model = serializer.Deserialize<Brand>(brand);

            string brandID = "";
            if (string.IsNullOrEmpty(model.BrandID))
            {
                brandID = new ProductsBusiness().AddBrand(model.Name, model.AnotherName, model.IcoPath, model.CountryCode, model.CityCode, model.Status.Value, model.Remark, model.BrandStyle, OperateIP, CurrentUser.UserID, CurrentUser.ClientID);
            }
            else
            {
                bool bl = new ProductsBusiness().UpdateBrand(model.BrandID, model.Name, model.AnotherName, model.CountryCode, model.CityCode, model.IcoPath, model.Status.Value, model.Remark, model.BrandStyle, OperateIP, CurrentUser.UserID);
                if (bl)
                {
                    brandID = model.BrandID;
                }
            }
            JsonDictionary.Add("ID", brandID);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #11
0
        /// <summary>
        /// 保存单位
        /// </summary>
        /// <param name="unit"></param>
        /// <returns></returns>
        public JsonResult SaveUnit(string unit)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            ProductUnit model = serializer.Deserialize<ProductUnit>(unit);

            string UnitID = "";
            if (string.IsNullOrEmpty(model.UnitID))
            {
                UnitID = new ProductsBusiness().AddUnit(model.UnitName, model.Description, CurrentUser.UserID, CurrentUser.ClientID);
            }
            else
            {
                bool bl = new ProductsBusiness().UpdateUnit(model.UnitID, model.UnitName, model.Description, CurrentUser.UserID);
                if (bl)
                {
                    UnitID = model.UnitID;
                }
            }
            JsonDictionary.Add("ID", UnitID);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #12
0
        /// <summary>
        /// 获取属性列表
        /// </summary>
        /// <param name="index"></param>
        /// <param name="keyWorks"></param>
        /// <returns></returns>
        public JsonResult GetAttrList(int index, string keyWorks)
        {
            List<ProductAttr> list = new List<ProductAttr>();

            int totalCount = 0, pageCount = 0;
            list = new ProductsBusiness().GetAttrList("", keyWorks, PageSize, index, ref totalCount, ref pageCount, CurrentUser.AgentID, CurrentUser.ClientID);

            JsonDictionary.Add("Items", list);
            JsonDictionary.Add("TotalCount", totalCount);
            JsonDictionary.Add("PageCount", pageCount);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #13
0
 /// <summary>
 /// 获取下级分类
 /// </summary>
 /// <param name="categoryid"></param>
 /// <returns></returns>
 public JsonResult GetChildCategorysByID(string categoryid)
 {
     var list = new ProductsBusiness().GetChildCategorysByID(categoryid, CurrentUser.ClientID);
     JsonDictionary.Add("Items", list);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #14
0
 /// <summary>
 /// 产品分类列表
 /// </summary>
 /// <returns></returns>
 public ActionResult Category()
 {
     var list = new ProductsBusiness().GetChildCategorysByID("", CurrentUser.ClientID);
     ViewBag.Items = list;
     return View();
 }
예제 #15
0
 public JsonResult DeleteCategory(string id)
 {
     int result = 0;
     bool bl = new ProductsBusiness().DeleteCategory(id,CurrentUser.UserID,OperateIP,CurrentUser.AgentID,CurrentUser.ClientID,out result);
     JsonDictionary.Add("status", result);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #16
0
 /// <summary>
 /// 获取分类详情(带属性)
 /// </summary>
 /// <param name="categoryid"></param>
 /// <returns></returns>
 public JsonResult GetCategoryDetailsByID(string categoryid)
 {
     var model = new ProductsBusiness().GetCategoryDetailByID(categoryid);
     JsonDictionary.Add("Model", model);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #17
0
 public JsonResult GetBrandList(string keyWords, int pageSize, int pageIndex, int totalCount)
 {
     int pageCount = 0;
     List<Brand> list = new ProductsBusiness().GetBrandList(keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, CurrentUser.ClientID);
     JsonDictionary.Add("Items", list);
     JsonDictionary.Add("TotalCount", totalCount);
     JsonDictionary.Add("PageCount", pageCount);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #18
0
 public JsonResult GetBrandDetail(string id)
 {
     Brand model = new ProductsBusiness().GetBrandByBrandID(id);
     JsonDictionary.Add("model", model);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #19
0
        /// <summary>
        /// 获取所有属性
        /// </summary>
        /// <returns></returns>
        public JsonResult GetAttrsByCategoryID(string categoryid)
        {
            List<ProductAttr> list = new List<ProductAttr>();
            list = new ProductsBusiness().GetAttrList(categoryid, CurrentUser.ClientID);

            JsonDictionary.Add("Items", list);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #20
0
        /// <summary>
        /// 保存子产品
        /// </summary>
        /// <param name="product"></param>
        /// <returns></returns>
        public JsonResult SavaProductDetail(string product)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            ProductDetail model = serializer.Deserialize<ProductDetail>(product);

            if (!string.IsNullOrEmpty(model.SaleAttr))
            {
                model.SaleAttr = model.SaleAttr.Substring(0, model.SaleAttr.Length - 1);
            }
            if (!string.IsNullOrEmpty(model.AttrValue))
            {
                model.AttrValue = model.AttrValue.Substring(0, model.AttrValue.Length - 1);
            }
            if (!string.IsNullOrEmpty(model.SaleAttrValue))
            {
                model.SaleAttrValue = model.SaleAttrValue.Substring(0, model.SaleAttrValue.Length - 1);
            }

            string id = "";
            if (string.IsNullOrEmpty(model.ProductDetailID))
            {
                id = new ProductsBusiness().AddProductDetails(model.ProductID, model.DetailsCode, model.ShapeCode, model.SaleAttr, model.AttrValue, model.SaleAttrValue,
                                                              model.Price, model.Weight, model.BigPrice, model.ImgS, model.Description, CurrentUser.UserID, CurrentUser.ClientID);
            }
            else
            {
                bool bl = new ProductsBusiness().UpdateProductDetails(model.ProductDetailID, model.ProductID, model.DetailsCode, model.ShapeCode, model.BigPrice, model.SaleAttr, model.AttrValue, model.SaleAttrValue,
                                                              model.Price, model.Weight, model.Description, model.ImgS, CurrentUser.UserID, CurrentUser.ClientID);
                if (bl)
                {
                    id = model.ProductDetailID;
                }
            }
            JsonDictionary.Add("ID", id);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #21
0
 /// <summary>
 /// 编辑产品是否推荐
 /// </summary>
 /// <param name="productid"></param>
 /// <param name="isRecommend"></param>
 /// <returns></returns>
 public JsonResult UpdateProductIsRecommend(string productid, bool isRecommend)
 {
     bool bl = new ProductsBusiness().UpdateProductIsRecommend(productid, isRecommend, OperateIP, CurrentUser.UserID);
     JsonDictionary.Add("Status", bl);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #22
0
        /// <summary>
        /// 保存属性
        /// </summary>
        /// <param name="attr"></param>
        /// <returns></returns>
        public JsonResult SaveAttr(string attr)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            ProductAttr model = serializer.Deserialize<ProductAttr>(attr);

            string attrID = string.Empty;
            if (string.IsNullOrEmpty(model.AttrID))
            {
                attrID = new ProductsBusiness().AddProductAttr(model.AttrName, model.Description, model.CategoryID, model.Type, CurrentUser.UserID, CurrentUser.ClientID);
            }
            else if (new ProductsBusiness().UpdateProductAttr(model.AttrID, model.AttrName, model.Description, OperateIP, CurrentUser.UserID, CurrentUser.ClientID))
            {
                attrID = model.AttrID.ToString();
            }

            JsonDictionary.Add("ID", attrID);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #23
0
 /// <summary>
 /// 删除属性值
 /// </summary>
 /// <param name="valueid"></param>
 /// <returns></returns>
 public JsonResult DeleteAttrValue(string valueid)
 {
     bool bl = new ProductsBusiness().UpdateAttrValueStatus(valueid, EnumStatus.Delete, OperateIP, CurrentUser.UserID);
     JsonDictionary.Add("Status", bl);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #24
0
        /// <summary>
        /// 保存属性值
        /// </summary>
        /// <param name="attr"></param>
        /// <returns></returns>
        public JsonResult SaveAttrValue(string value)
        {
            JavaScriptSerializer serializer = new JavaScriptSerializer();
            AttrValue model = serializer.Deserialize<AttrValue>(value);

            string valueID = string.Empty;
            if (!string.IsNullOrEmpty(model.AttrID))
            {
                if (string.IsNullOrEmpty(model.ValueID))
                {
                    valueID = new ProductsBusiness().AddAttrValue(model.ValueName, model.AttrID, CurrentUser.UserID, CurrentUser.ClientID);
                }
                else if (new ProductsBusiness().UpdateAttrValue(model.ValueID, model.AttrID, model.ValueName, OperateIP, CurrentUser.UserID, CurrentUser.ClientID))
                {
                    valueID = model.ValueID.ToString();
                }
            }

            JsonDictionary.Add("ID", valueID);
            return new JsonResult
            {
                Data = JsonDictionary,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }
예제 #25
0
 /// <summary>
 /// 加入购物车详情页
 /// </summary>
 /// <param name="pid"></param>
 /// <param name="did"></param>
 /// <param name="type"></param>
 /// <returns></returns>
 public ActionResult ChooseDetail(string pid, string did, int type = 0)
 {
     var model = new ProductsBusiness().GetProductByIDForDetails(pid);
     ViewBag.Model = model;
     ViewBag.DetailID = did;
     ViewBag.OrderType = type;
     return View();
 }
예제 #26
0
 /// <summary>
 /// 获取产品信息(加入购物车)
 /// </summary>
 /// <param name="productid"></param>
 /// <returns></returns>
 public JsonResult GetProductByIDForDetails(string productid)
 {
     var model = new ProductsBusiness().GetProductByIDForDetails(productid);
     JsonDictionary.Add("Item", model);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #27
0
 /// <summary>
 /// 获取属性详情
 /// </summary>
 /// <param name="attr"></param>
 /// <returns></returns>
 public JsonResult GetAttrByID(string attrID = "")
 {
     if (string.IsNullOrEmpty(attrID))
     {
         JsonDictionary.Add("Item", null);
     }
     else
     {
         var model = new ProductsBusiness().GetProductAttrByID(attrID, CurrentUser.ClientID);
         JsonDictionary.Add("Item", model);
     }
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #28
0
 /// <summary>
 /// 编辑产品状态
 /// </summary>
 /// <param name="productid"></param>
 /// <param name="status"></param>
 /// <returns></returns>
 public JsonResult UpdateProductStatus(string productid, int status)
 {
     bool bl = new ProductsBusiness().UpdateProductStatus(productid, (EnumStatus)status, OperateIP, CurrentUser.UserID);
     JsonDictionary.Add("Status", bl);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #29
0
        public ActionResult ExportFromProduct(bool test = false, string model = "", string filleName = "产品", string filter = "")
        {
            JavaScriptSerializer serializer=new JavaScriptSerializer();
            Dictionary<string, ExcelFormatter> dic = new Dictionary<string, ExcelFormatter>();
            FilterProduct qicProduct =  serializer.Deserialize<FilterProduct>(filter);
            Dictionary<string, ExcelModel> listColumn = new Dictionary<string, ExcelModel>();
            if (string.IsNullOrEmpty(filter))
            {
                listColumn = GetColumnForJson("product", ref dic, model, test ? "testexport" : "export", CurrentUser.ClientID);
            }
            else
            {  
                qicProduct = serializer.Deserialize<FilterProduct>(filter);
                listColumn = GetColumnForJson("product", ref dic, !string.IsNullOrEmpty(model) ? model : "Item", test ? "testexport" : "export", CurrentUser.ClientID);
            }
            string ipPath = "";
            var excelWriter = new ExcelWriter();
            foreach (var key in listColumn)
            {
                excelWriter.Map(key.Key, key.Value.Title);
            }
            byte[] buffer;
            DataTable dt = new DataTable();
            //模版导出
            if (test)
            {
                DataRow dr = dt.NewRow();
                foreach (var key in listColumn)
                {
                    DataColumn dc1 = new DataColumn(key.Key, Type.GetType("System.String"));
                    dt.Columns.Add(dc1); 
                    dr[key.Key] = key.Value.DefaultText; 
                }
                dt.Rows.Add(dr);
            }
            else
            {
                int totalCount = 0;
                int pageCount = 0; 
                ipPath= Server.MapPath("~");
                dt = new ProductsBusiness().GetProductListDataTable(qicProduct.CategoryID, qicProduct.BeginPrice, qicProduct.EndPrice, qicProduct.Keywords, qicProduct.OrderBy, qicProduct.IsAsc, PageSize, qicProduct.PageIndex, ref totalCount, ref pageCount, CurrentUser.ClientID);

            }
            buffer = excelWriter.Write(dt, dic, ipPath);
            var fileName = filleName + (test ? "导入模版" : "")+DateTime.Now.ToString("yyyyMMdd");
            if (!Request.ServerVariables["http_user_agent"].ToLower().Contains("firefox"))
                fileName = HttpUtility.UrlEncode(fileName);
            this.Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xlsx");
            return File(buffer, "application/ms-excel");

        }
예제 #30
0
 /// <summary>
 /// 产品编码是否存在
 /// </summary>
 /// <param name="code"></param>
 /// <returns></returns>
 public JsonResult IsExistsProductCode(string code)
 {
     bool bl = new ProductsBusiness().IsExistProductCode(code, CurrentUser.ClientID);
     JsonDictionary.Add("Status", bl);
     return new JsonResult
     {
         Data = JsonDictionary,
         JsonRequestBehavior = JsonRequestBehavior.AllowGet
     };
 }
예제 #31
0
 /// <summary>
 /// 添加产品
 /// </summary>
 /// <returns></returns>
 public ActionResult ProductAdd(string id)
 {
     if (string.IsNullOrEmpty(id))
     {
         var list = new ProductsBusiness().GetChildCategorysByID("", CurrentUser.ClientID);
         ViewBag.Items = list;
         return View("ChooseCategory");
     }
     ViewBag.Model = new ProductsBusiness().GetCategoryDetailByID(id);
     ViewBag.BrandList = new ProductsBusiness().GetBrandList(CurrentUser.ClientID);
     ViewBag.UnitList = new ProductsBusiness().GetClientUnits(CurrentUser.ClientID);
     return View();
 }