using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DAL
{
    public class ClsSc_LEDInfoBoard
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        //ÏÔʾµ¥¾Ý
        public DataSet ShowBill(ref string sReturn)
        {
            try
            {
                //²éѯÖ÷±í
                DataSet Ds;
                Ds = oCn.RunProcReturn("Select * from h_v_Sc_LEDBoardDisplay order by ²úÏß,ÈÕÆÚ,ÓÅÏȼ¶", "h_v_Sc_LEDBoardDisplay");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    sReturn = "¼Ç¼δÕÒµ½£¡";
                    return null;
                }
                //¸³Öµ
                sReturn = "ÏÔʾ³É¹¦£¡";
                return Ds;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return null;
            }
        }
    }
}