Beispiel #1
0
        /// <summary>
        /// 取DataTable
        /// </summary>
        public DataTable GetDataTable(SqlTransaction trans)
        {
            StringBuilder LeftJoin = new StringBuilder();
            StringBuilder SqlQuery = new StringBuilder();

            SqlQuery.Append(" and IsClose=@IsClose");
            List <SqlParameter> listParams = new List <SqlParameter>();

            listParams.Add(new SqlParameter("@IsClose", EnumList.CloseStatus.Open.ToInt()));
            string FieldShow  = "a.*";
            string FieldOrder = "a.AdPositionId asc";

            return(adpDAL.GetDataTable(trans, LeftJoin, SqlQuery, listParams, FieldShow, FieldOrder));
        }