蚁文尘都〖隋〗

  /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string postr,string str_date)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE  @return_value int,");
            strSql.Append("@SQNO char(10) ");
            strSql.Append("EXEC  @return_value = [SQNoPUT] ");
            strSql.Append("@bil_id = N'" + postr + "', ");
            strSql.Append("@bil_dd = N'" + str_date + "',");
            strSql.Append("@SQNO = @SQNO OUTPUT ");
            strSql.Append("SELECT  @SQNO as N'@SQNO' ");
            strSql.Append("SELECT  'Return Value' = @return_value ");
            return DbHelperSQL.Query(strSql.ToString());
        }