Example #1
0
        public static SaleProduct GetSaleProduct(string weiXinID, int saleProductId)
        {
            var         dt          = DAL.SaleProduct.GetSaleProduct(weiXinID, saleProductId);
            SaleProduct saleProduct = new SaleProduct();

            foreach (System.Data.DataRow dr in dt.Rows)
            {
                saleProduct.Id       = Convert.ToInt32(dr["id"].ToString());
                saleProduct.WeiXinId = dr["WeiXinId"].ToString();

                saleProduct.HotelId     = Convert.ToInt32(dr["HotelId"].ToString());
                saleProduct.ProductType = Convert.ToInt32(dr["ProductType"].ToString());

                saleProduct.ProductName = dr["ProductName"].ToString();
                saleProduct.ProductNum  = Convert.ToInt32(dr["ProductNum"].ToString());
                saleProduct.BeginTime   = Convert.ToDateTime(dr["BeginTime"].ToString());
                saleProduct.EndTime     = Convert.ToDateTime(dr["EndTime"].ToString());

                saleProduct.EffectiveBeginTime = Convert.ToDateTime(dr["EffectiveBeginTime"].ToString());
                saleProduct.EffectiveEndTime   = Convert.ToDateTime(dr["EffectiveEndTime"].ToString());


                saleProduct.ProductPrice = Convert.ToDecimal(dr["ProductPrice"].ToString());
                saleProduct.DetailDes    = dr["DetailDes"].ToString();
                saleProduct.SaleChannel  = dr["SaleChannel"].ToString();

                saleProduct.Status         = Convert.ToInt32(dr["Status"].ToString());
                saleProduct.LastUpdatetime = Convert.ToDateTime(dr["LastUpdateTime"].ToString());

                saleProduct.FeeInclude = dr["FeeInclude"].ToString();
                saleProduct.FeeExclude = dr["FeeExclude"].ToString();

                saleProduct.OrderInfo  = dr["OrderInfo"].ToString();
                saleProduct.RefundInfo = dr["RefundInfo"].ToString();
                saleProduct.ImageList  = dr["ImageList"].ToString();

                saleProduct.SmallImageList = dr["SmallImageList"].ToString();
                saleProduct.BigImageList   = dr["BigImageList"].ToString();

                saleProduct.IsOnlineTaobao = Convert.ToInt32(dr["IsOnlineTaobao"].ToString());
                saleProduct.IsOnlineQunar  = Convert.ToInt32(dr["IsOnlineQunar"].ToString());
                saleProduct.SysStatus      = Convert.ToInt32(dr["SysStatus"].ToString());

                saleProduct.MenPrice     = Convert.ToDecimal(dr["MenPrice"].ToString());
                saleProduct.MainPic      = dr["MainPic"].ToString();
                saleProduct.Tab          = dr["Tab"].ToString();
                saleProduct.BigMainPic   = dr["BigMainPic"].ToString();
                saleProduct.SmallMainPic = dr["SmallMainPic"].ToString();

                saleProduct.IsUsehongbao = Convert.ToInt32(dr["IsUsehongbao"].ToString());
            }

            return(saleProduct);
        }
Example #2
0
        public static List <SaleProduct> GetSaleProducts(string weiXinID, out int count, int page, int pagesize, string select, string query)
        {
            var dt = DAL.SaleProduct.GetSaleProducts(weiXinID, out count, page, pagesize, select, query);
            List <SaleProduct> saleProductList = new List <SaleProduct>();

            foreach (System.Data.DataRow dr in dt.Rows)
            {
                SaleProduct saleProduct = new SaleProduct();
                saleProduct.Id       = Convert.ToInt32(dr["id"].ToString());
                saleProduct.WeiXinId = dr["WeiXinId"].ToString();

                saleProduct.HotelId     = Convert.ToInt32(dr["HotelId"].ToString());
                saleProduct.ProductType = Convert.ToInt32(dr["ProductType"].ToString());

                saleProduct.ProductName = dr["ProductName"].ToString();
                saleProduct.ProductNum  = Convert.ToInt32(dr["ProductNum"].ToString());
                saleProduct.BeginTime   = Convert.ToDateTime(dr["BeginTime"].ToString());
                saleProduct.EndTime     = Convert.ToDateTime(dr["EndTime"].ToString());

                saleProduct.EffectiveBeginTime = Convert.ToDateTime(dr["EffectiveBeginTime"].ToString());
                saleProduct.EffectiveEndTime   = Convert.ToDateTime(dr["EffectiveEndTime"].ToString());


                saleProduct.ProductPrice = Convert.ToDecimal(dr["ProductPrice"].ToString());
                saleProduct.DetailDes    = dr["DetailDes"].ToString();
                saleProduct.SaleChannel  = dr["SaleChannel"].ToString();

                saleProduct.Status         = Convert.ToInt32(dr["Status"].ToString());
                saleProduct.LastUpdatetime = Convert.ToDateTime(dr["LastUpdateTime"].ToString());

                saleProduct.FeeInclude = dr["FeeInclude"].ToString();
                saleProduct.FeeExclude = dr["FeeExclude"].ToString();

                saleProduct.OrderInfo      = dr["OrderInfo"].ToString();
                saleProduct.RefundInfo     = dr["RefundInfo"].ToString();
                saleProduct.ImageList      = dr["ImageList"].ToString();
                saleProduct.SmallImageList = dr["SmallImageList"].ToString();
                saleProduct.BigImageList   = dr["BigImageList"].ToString();

                saleProduct.IsOnlineTaobao = Convert.ToInt32(dr["IsOnlineTaobao"].ToString());
                saleProduct.IsOnlineQunar  = Convert.ToInt32(dr["IsOnlineQunar"].ToString());
                saleProduct.SysStatus      = Convert.ToInt32(dr["SysStatus"].ToString());

                saleProductList.Add(saleProduct);
            }

            return(saleProductList);
        }
Example #3
0
        public static int UpdateSaleProduct(SaleProduct model)
        {
            int row = DAL.SaleProduct.UpdateSaleProductSale(model);

            return(row);
        }
Example #4
0
        public static int AddSaleProduct(SaleProduct model)
        {
            int Id = DAL.SaleProduct.AddSaleProductSale(model);

            return(Id);
        }
Example #5
0
        public ActionResult ProductDetail()
        {
            int Id = HotelCloud.Common.HCRequest.getInt("ProductId");

            WeiXin.Models.Home.SaleProduct products = new WeiXin.Models.Home.SaleProduct();


            Newtonsoft.Json.Converters.IsoDateTimeConverter timeFormat = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
            timeFormat.DateTimeFormat = "yyyy-MM-dd";



            string key           = HotelCloud.Common.HCRequest.GetString("key");
            string hotelweixinId = key.Split('@')[0];
            string userweixinId  = key.Split('@')[1];


            products = WeiXin.Models.Home.SaleProduct.GetSaleProduct(hotelweixinId, Id);

            if (products == null || products.Id == 0)
            {
                //return RedirectToAction("ProductErrMsg", "Product", new { id = RouteData.Values["id"], errmsg = "没找到对应的产品", key = HotelCloud.Common.HCRequest.GetString("key") });

                return(RedirectToAction("productList", "Product", new { id = RouteData.Values["id"], key = HotelCloud.Common.HCRequest.GetString("key") }));
            }

            if (products.EndTime < DateTime.Now)
            {
                //return RedirectToAction("ProductErrMsg", "Product", new { id = RouteData.Values["id"], errmsg = "产品已过期", key = HotelCloud.Common.HCRequest.GetString("key") });
            }

            if (products.Status != 0)
            {
                //return RedirectToAction("ProductErrMsg", "Product", new { id = RouteData.Values["id"], errmsg = "产品已下架", key = HotelCloud.Common.HCRequest.GetString("key") });
                return(RedirectToAction("productList", "Product", new { id = RouteData.Values["id"], key = HotelCloud.Common.HCRequest.GetString("key") }));
            }

            double minPrice = 0;
            double maxPrice = 0;


            products.List_SaleProducts_TC = WeiXin.Models.Home.SaleProducts_TC.GetSaleProducts_TC(products.Id);

            DataTable db = WeiXin.Models.Home.SaleProduct.GetHotelInfo(products.WeiXinId);

            if (db.Rows.Count > 0)
            {
                ViewData["hotelname"]  = db.Rows[0]["SubName"].ToString();
                ViewData["tel"]        = db.Rows[0]["tel"].ToString();
                ViewData["address"]    = db.Rows[0]["address"].ToString();
                ViewData["WeiXin2Img"] = db.Rows[0]["WeiXin2Img"].ToString();
            }

            //团购
            if (products.ProductType == 0)
            {
                products.List_SaleProducts_TC = products.List_SaleProducts_TC.Where(c => c.ProductPrice > 0 && c.ProductNum > 0).OrderBy(c => c.ProductPrice).ToList();

                if (products.List_SaleProducts_TC != null && products.List_SaleProducts_TC.Count > 0)
                {
                    minPrice = Convert.ToDouble(products.List_SaleProducts_TC.Min(c => c.ProductPrice));
                    maxPrice = Convert.ToDouble(products.List_SaleProducts_TC.Max(c => c.ProductPrice));
                }
            }

            //预售
            else if (products.ProductType == 1)
            {
                foreach (var item in products.List_SaleProducts_TC)
                {
                    item.List_SaleProducts_TC_Price = WeiXin.Models.Home.SaleProducts_TC_Price.GetSaleProducts_TC_Price(item.Id);
                }


                products.List_SaleProducts_TC = products.List_SaleProducts_TC.Where(c => c.List_SaleProducts_TC_Price.Count > 0).ToList();


                if (products.List_SaleProducts_TC != null && products.List_SaleProducts_TC.Count > 0)
                {
                    var t_price = new List <WeiXin.Models.Home.SaleProducts_TC_Price>();
                    products.List_SaleProducts_TC.ForEach(r => { t_price.AddRange(r.List_SaleProducts_TC_Price); });
                    minPrice = Convert.ToDouble(t_price.Min(c => c.Price));
                    maxPrice = Convert.ToDouble(t_price.Max(c => c.Price));
                }
            }


            products.Json_SaleProducts_TC = Newtonsoft.Json.JsonConvert.SerializeObject(products.List_SaleProducts_TC, timeFormat);
            ViewData["products"]          = products;

            if (minPrice == 0)
            {
                return(RedirectToAction("productList", "Product", new { id = RouteData.Values["id"], key = HotelCloud.Common.HCRequest.GetString("key") }));
                //return RedirectToAction("ProductErrMsg", "Product", new { id = RouteData.Values["id"], errmsg = "产品已售完", key = HotelCloud.Common.HCRequest.GetString("key") });
            }

            ViewData["minPrice"] = minPrice;
            ViewData["maxPrice"] = maxPrice;


            return(View());
        }