/// <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)); }