1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
| 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;
| }
| }
| }
| }
|
|
