string sql = "******************************";
            DataTable dt = SqlDbHelper.ExecuteDataTable(sql);
            List<CusInfo> listA = CusInfoDal.m_CusInfoDal.GetList(dt);//list转化为datatable

 List<Cus> list = listA.Skip((Pager.CurrentPageIndex - 1) * Pager.PageSize).Take(Pager.PageSize).ToList();

 ProductDal p = new ProductDal();

  List<Product> list =p.selectResult(torf, target, getSQL1(), getSQL2()); 

        {
           
            List<Product> list = new List<Product>();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("");
            strSql.Append(" Union ");
            strSql.Append(" ");
            strSql.Append(" order by " + Order + " desc ");

          
            string sql = strSql.ToString();
            DataSet ds = SqlDbHelper.ExecuteDataTable(sql).DataSet;
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Pro nfo = new Pro();
              
                info.P_Recom = Convert.ToInt32(item["P_Recom"]);
                info.P_Spec = Convert.ToInt32(item["P_Spec"]);
                info.P_Show = Convert.ToInt32(item["P_Show"]);
                info.Rebate = Convert.ToDecimal(item["Rebate"]);

                list.Add(info);
            }
            return list;
        }