示例#1
0
        public static DataSet GetPagerData(int intPageSize, int intCurrentPageIndex)
        {
            int num  = 0;
            int num2 = 0;

            return(GoodsSpecify.GetPagerData(intPageSize, intCurrentPageIndex, ref num, ref num2));
        }
示例#2
0
        public static GoodsSpecifyInfo Get(int guigeID)
        {
            GoodsSpecifyInfo dataById = GoodsSpecify.GetDataById(guigeID);
            GoodsSpecifyInfo result;

            if (dataById != null)
            {
                result = GoodsSpecify.Get(GoodsSpecify.GetDataById(guigeID));
            }
            else
            {
                result = null;
            }
            return(result);
        }
示例#3
0
        public static ProductInfo GetProduct(int intProductID)
        {
            ProductInfo dataById = Product.GetDataById(intProductID);

            if (dataById != null)
            {
                ProductModelInfo cacheModelById = ProductModel.GetCacheModelById(dataById.ModelID);
                dataById.CustomTable = Product.GetCustomContentInfo(intProductID, cacheModelById.TableName);
                dataById.PhotoAlbums = PhotoAlbum.GetPhotoAlbumByPID(intProductID);
                UserInfo user = User.GetLoginUser();
                if (user != null)
                {
                    dataById.MemberPriceSets = MemberPriceSet.GetList(dataById.MemberPriceSet, dataById.SellPrice);
                    MemberPriceSetInfo memberPriceSetInfo = (from p in dataById.MemberPriceSets
                                                             where p.UserLevelID.Equals(user.LevelID)
                                                             select p).FirstOrDefault <MemberPriceSetInfo>();
                    if (memberPriceSetInfo != null)
                    {
                        dataById.MemberPrice = ((memberPriceSetInfo.Price > 0m) ? memberPriceSetInfo.Price : memberPriceSetInfo.DiscoutPrice);
                        if (dataById.MemberPrice == 0m)
                        {
                            dataById.MemberPrice = dataById.SellPrice;
                        }
                    }
                }
                dataById.PriceRange = dataById.SellPrice.ToString("f2");
                dataById.RealStock  = dataById.Stock;
                if (dataById.ClassID > 0)
                {
                    List <decimal> priceRange = GoodsSpecify.GetPriceRange(dataById);
                    if (priceRange[0] == priceRange[1])
                    {
                        dataById.PriceRange = priceRange[0].ToString("f2");
                    }
                    else
                    {
                        dataById.PriceRange = priceRange[0].ToString("f2") + " - " + priceRange[1].ToString("f2");
                    }
                    dataById.GuiGe = GoodsSpecify.GetListByProID(dataById.AutoID);
                    if (dataById.GuiGe != null && dataById.GuiGe.Count > 0)
                    {
                        dataById.RealStock = dataById.GuiGe.Sum((GoodsSpecifyInfo p) => p.Stock);
                    }
                }
            }
            return(dataById);
        }
示例#4
0
 public static void ReBackStock(ProductInfo pro, GoodsSpecifyInfo goodsattr, int intQuantity)
 {
     if (pro != null)
     {
         if (goodsattr != null)
         {
             goodsattr.Stock += intQuantity;
             GoodsSpecify.Update(goodsattr);
         }
         pro.Stock += intQuantity;
         BizBase.dbo.UpdateTable(string.Concat(new object[]
         {
             " update shop_Product set Stock=Stock+",
             intQuantity,
             " where AutoID= ",
             pro.AutoID
         }));
     }
 }
示例#5
0
        public static GoodsSpecifyInfo Get(int proID, string strGuiGe)
        {
            GoodsSpecifyInfo model = BizBase.dbo.GetModel <GoodsSpecifyInfo>(string.Concat(new object[]
            {
                " select top 1 * from shop_GoodsSpecify where ProID=",
                proID,
                " and Specification='",
                StringUtils.ChkSQL(strGuiGe),
                "' "
            }));
            GoodsSpecifyInfo result;

            if (model != null)
            {
                result = GoodsSpecify.Get(model);
            }
            else
            {
                result = null;
            }
            return(result);
        }
示例#6
0
        public static IList <GoodsSpecifyInfo> GetList(int intTopCount, string strCondition)
        {
            string strSort = " Sort asc,AutoID desc ";

            return(GoodsSpecify.GetList(intTopCount, strCondition, strSort));
        }
示例#7
0
 public static IList <GoodsSpecifyInfo> GetTopNList(int intTopCount, string strSort)
 {
     return(GoodsSpecify.GetList(intTopCount, string.Empty, strSort));
 }
示例#8
0
 public static IList <GoodsSpecifyInfo> GetAllList()
 {
     return(GoodsSpecify.GetList(0, string.Empty));
 }
示例#9
0
 public static GoodsSpecifyInfo GetTopData()
 {
     return(GoodsSpecify.GetTopData(" Sort ASC,AutoID desc "));
 }
示例#10
0
 public static IList <GoodsSpecifyInfo> GetPagerList(int intCurrentPageIndex, int intPageSize, ref int intTotalCount, ref int intTotalPage)
 {
     return(GoodsSpecify.GetPagerList("", "Sort ASC,AutoID DESC", intCurrentPageIndex, intPageSize, ref intTotalCount, ref intTotalPage));
 }
示例#11
0
 public static DataSet GetPagerData(string strFilter, string strCondition, int intPageSize, int intCurrentPageIndex, ref int intTotalCount, ref int intTotalPage)
 {
     return(GoodsSpecify.GetPagerData(strFilter, strCondition, " Sort asc,AutoID desc ", intPageSize, intCurrentPageIndex, ref intTotalCount, ref intTotalPage));
 }
示例#12
0
 public static DataSet GetPagerData(string strCondition, int intPageSize, int intCurrentPageIndex, ref int intTotalCount, ref int intTotalPage)
 {
     return(GoodsSpecify.GetPagerData("*", strCondition, intPageSize, intCurrentPageIndex, ref intTotalCount, ref intTotalPage));
 }
示例#13
0
        public static void CancelExpireOrder(int intUserID)
        {
            DataTable dataTable = BizBase.dbo.GetDataTable(string.Concat(new object[]
            {
                " select ProID,GuiGePath,SUM(Quantity) as QuantityTotal from(         select * from shop_OrderItem where OrderID in         ( select AutoID from shop_orders where ",
                (intUserID > 0) ? ("UserID=" + intUserID + " and ") : "",
                " OrderStatus=",
                1,
                " and GETDATE()>DATEADD(hour,",
                ConfigProvider.Configs.BuyPayExpire,
                ",OrderAddTime))    ) as A group by ProID,GuiGePath "
            }));

            if (dataTable != null && dataTable.Rows.Count > 0)
            {
                BizBase.dbo.InsertNoReValue(string.Concat(new object[]
                {
                    " insert into shop_OrderAction(OrderID,Operator,OrderStatus,ActionNote,Remark,AutoTimeStamp) select AutoID,'系统',",
                    101,
                    ",'订单创建后超过",
                    ConfigProvider.Configs.BuyPayExpire,
                    "小时未付款,系统自动关闭订单!','',getdate() from shop_orders where ",
                    (intUserID > 0) ? (" UserID=" + intUserID + " and ") : "",
                    " OrderStatus=",
                    1,
                    " and GETDATE()>DATEADD(hour,",
                    ConfigProvider.Configs.BuyPayExpire,
                    ",OrderAddTime) "
                }));
                BizBase.dbo.UpdateTable(string.Concat(new object[]
                {
                    " update shop_orders set OrderStatus=",
                    101,
                    " where ",
                    (intUserID > 0) ? (" UserID=" + intUserID + " and ") : "",
                    " OrderStatus=",
                    1,
                    " and GETDATE()>DATEADD(hour,",
                    ConfigProvider.Configs.BuyPayExpire,
                    ",OrderAddTime) "
                }));
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    Orders.ReBackStock(Product.GetDataById(WebUtils.GetInt(dataRow["ProID"])), GoodsSpecify.Get(WebUtils.GetInt(dataRow["ProID"]), dataRow["GuiGePath"].ToString()), WebUtils.GetInt(dataRow["QuantityTotal"]));
                }
            }
        }