C# (CSharp) DAL.Service CommodityDiscountInfoDAL.CommodityDiscountListSQL Examples

Example #1

File: AdminDiscountService.cs Project: AAlben/Mall_WeChart_Nf

        public IEnumerable<dynamic> CommodityDiscountItem(string discountID)
        {
            //Init
            SQLStringInfo _sqlInfo = new SQLStringInfo();
            _sqlInfo.ColumnSB.Append(" ,DIS.PostType,DIS.IsEndCommodity ");
            _sqlInfo.WhereSB.Append(" WHERE DiscountID = @DiscountID");
            _sqlInfo.OrderBySB.Append(",COMM.Title");

            //DAL
            CommodityDiscountInfoDAL discountDal = new CommodityDiscountInfoDAL();

            string strSql = _sqlInfo.GetSQLString(discountDal.CommodityDiscountListSQL());

            IEnumerable<dynamic> list = discountDal.Query(strSql, new { DiscountID = discountID });

            return list;
        }