Backup/DAL/TotalInfoDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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



namespace DAL
{
    public class TotalInfoDAO
    {
        SQLHelper sqlhelper = new SQLHelper();
        private DataSet ds;
        //保存结帐信息
        public int SaveRoomMoney(TotalInfoBean total)
        {
            try
            {
                int count = sqlhelper.RunSQL("insert into totalinfo values('房费',"+total.totalMoney+",default,'"+total.totalRemark+"')");
                return count;
            }
            catch (Exception)
            {
                
                throw;
            }
        }

        //总记录数
        public int GetAllCount()
        {
            try
            {
                int count = sqlhelper.ReturnSQL("select count(*) from totalinfo");
                return count;
            }
            catch (Exception)
            {
                
                throw;
            }
        }

        //得到收入信息分页

        public DataSet GetToltalInfo(int start,int limit)
        {
            try
            {
                ds = sqlhelper.GetDataSet("select top "+limit+" * from totalinfo where totalid not in(select top "+start+" totalid from totalinfo order by totaltime desc) order by totaltime desc");
                return ds;
            }
            catch (Exception)
            {
                
                throw;
            }
        }