1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.SqlClient;
 6
 7namespace HotelDAL
 8...{
 9    public class MoneyInfoDAO
10    ...{
11
12        SqlHelper sh = new SqlHelper();
13        DataSet ds;
14        private SqlParameter para; //参数
15
16
17        /**//// <summary>
18        /// 查账(全查,根据时间查询都可以)
19        /// </summary>
20        /// <returns></returns>
21        public DataSet SerachMoney(string BeginTime,string EndTime)
22        ...{
23            try
24            ...{
25                SqlParameter[] sp =...{
26                    para = new SqlParameter("@BeginTime",BeginTime),
27                    para = new SqlParameter("@EndTime",EndTime)
28                };
29                ds = sh.GetDataSet("SerachMoney", sp);
30            }
31            catch (Exception ex)
32            ...{
33                throw ex;
34            }
35            return ds;
36        }
37    }
38}
39