reckoningaccess.cs

来自「酒店管理系统,您酒店物业管理的好帮手」· CS 代码 · 共 41 行

using System;
using System.Collections.Generic;
using System.Text;
using Hotel.DAO;
using System.Data.SqlClient;

namespace Hotel.Operation
{
    public class ReckoningAccess
    {
        GetDatabase objGetDatabase = null;
        public ReckoningAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获取最后一个帐单号
        public int GetMaxReckoning()
        {
            int ma = 0;
            string sql = "select max(ReckoningID) from Reckoning";
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                ma =int.Parse( dr[0].ToString());
            }
            objGetDatabase.DrClose(dr);
            objGetDatabase.DataClose();
            return ma;
        }
        //调用储存过程插入帐单
        public int AddReckoningInfo(SqlParameter [] para)
        {
            int k = objGetDatabase.ExecuteProc("proc_Reckoning", para);
            //objGetDatabase.DataClose();
            return k;

        }
    }
}