using System;
using System.Data;
using System.Data.OracleClient;
using WX.CRM.Common;

namespace WX.CRM.DAL.Quality
{
    public class QC_COMPLAIN_NOTICE_DAL
    {
        public DataTable GetNotice(decimal userId)
        {
            DataTable table = null;
            try
            {
                OracleParameter[] p2 = {
                    new OracleParameter() { ParameterName = "p_userId", OracleType=OracleType.Number, Value = userId },
                    new OracleParameter() { ParameterName = "p_data", OracleType=OracleType.Cursor,Direction = ParameterDirection.Output }
                };
                table = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_COMPLAIN_NOTICE", p2).Tables[0];
            }
            catch (Exception ex)
            {
                LogHelper.Error(ex.ToString());
            }
            return table;
        }
    }
}