示例#1
0
        public DataSet GetQueryResultForChild(DynamicReportBO reportBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(reportBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "mdr_getDynamicChildRprt";
            sqlHelper.AddParameter(command, "@Param", reportBO.paramValue, ParameterDirection.Input);
            return(sqlHelper.ExecuteDataSet(command));
        }
示例#2
0
        public DataSet GetReportName(DynamicReportBO reportBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(reportBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "uspWSGetDynamicReportName";
            sqlHelper.AddParameter(command, "@userId", reportBO.UserId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@level", reportBO.Level, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@Mode", 2, ParameterDirection.Input);
            return(sqlHelper.ExecuteDataSet(command));
        }
示例#3
0
        public DataSet GetQueryResult(DynamicReportBO reportBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(reportBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "uspWSGetDynamicReport";
            sqlHelper.AddParameter(command, "@DynamicReportId", reportBO.DynamicReportId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@UserId", reportBO.UserId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@ShopId", reportBO.ShopId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@Mode", reportBO.mode, ParameterDirection.Input);
            return(sqlHelper.ExecuteDataSet(command));
        }