using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Configuration;
using?System.Data.SqlClient;
using?BinModel;

namespace?BinDal
{
????public?class?CustomBookServices
????{

????????private?Dals?dal;
????????private?SqlConnection?connection;
????????private?SqlCommand?command;

????????public?CustomBookServices（）
????????{?}
????????///?

????????///?添加顧客基本信息
????????///?

????????///?
????????///?受影響的記錄
????????public?int?addCustomBooksServices（CustomBooks?customBook）
????????{
????????????int?i?=?0;
????????????this.dal?=?new?Dals（）;

????????????using?（this.connection?=?dal.connection）
????????????{
????????????????this.connection.Open（）;

????????????????DateTime?bc_time?=?customBook.Cb_time;
????????????????string?bc_name?=?customBook.Cb_cusName;
????????????????int?bc_room?=?1;


????????????????DateTime?bc_entertime?=?customBook.Cb_enterTime;
????????????????string?bc_CusType?=?customBook.Cb_type;
????????????????string?bc_connection?=?customBook.Gb_connection;

????????????????int?bc_Group?=?customBook.Cb_Group;
????????????????string?bc_note?=?customBook.Cb_note;

????????????????string?sql?=?string.Format（“insert?into?CustomBook?values（‘{0}‘‘{1}‘‘{2}‘‘{3}‘‘{4}‘‘{5}‘‘{6}‘‘{7}‘）“?bc_name?bc_room?bc_Group?bc_connection?bc_time?bc_entertime?bc_CusType?bc_note）;
????????????????this.command?=?new?SqlCommand（）;
????????????????this.command.Connection?=?this.connection;
????????????????this.command.CommandText?=?sql;
????????????????i?=?this.command.ExecuteNonQuery（）;
????????????}
????????????return?i;
????????}
????????///?

????????///?獲得最新客戶預定信息的主鍵　Ｉｄ號
????????///?

????????///?
????????public?int?getLastCustomBooks（）
????????{
????????????int?i?=?0;
????????????this.dal?=?new?Dals（）;
????????????using?（this.connection?=?dal.connection）
????????????{
????????????????this.command?=?new?SqlCommand（）;
????????????????this.command.Connection?=?this.connection;
????????????????this.connection.Open（）;
????????????????this.command.CommandText?=?“select?max（cb_id）?from?CustomBook?“;
????????????????i?=?（int）this.command.ExecuteScalar（）;
????????????}
????????????return?i;
????????}

????????///?

????????///?獲得所有的預定?客戶的信息
????????///?

????????///?
????????public?IList?getAllCustomBooks（）
????????{
????????????IList?cusBookss?=?new?List（）;
????????????this.dal?=?new?Dals（）;

????????????using?（this.connection?=?dal.connection）
????????????{
????????????????this.command?=?new?SqlCommand（）;
????????????????this.command.Connection?=?this.connection;


????????????????this.command.CommandText?=?“getAllCustomerBooks“;
????????????????this.command.CommandType?=?CommandType.StoredProcedure;

????????????????this.connection.Open

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????176??2001-08-19?17:55??酒店管理系統\酒店管理系統\BinBal\obj\BinBal.csproj.FileList.txt

?????文件????????222??2008-07-03?13:41??酒店管理系統\酒店管理系統\BinBll\obj\BinBll.csproj.FileList.txt

?????文件???????1005??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBll\obj\Debug\BinBll.csproj.FileListAbsolute.txt

?????文件????????178??2008-07-03?13:41??酒店管理系統\酒店管理系統\BinBal\obj\BinDal.csproj.FileList.txt

?????文件????????787??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBal\obj\Debug\BinDal.csproj.FileListAbsolute.txt

?????文件????????138??2008-07-03?13:41??酒店管理系統\酒店管理系統\BinModel\obj\BinModel.csproj.FileList.txt

?????文件????????583??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinModel\obj\Debug\BinModel.csproj.FileListAbsolute.txt

?????文件????????138??2008-07-03?13:41??酒店管理系統\酒店管理系統\BinTools\obj\BinTools.csproj.FileList.txt

?????文件????????583??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinTools\obj\Debug\BinTools.csproj.FileListAbsolute.txt

?????文件???????1468??2009-05-04?21:37??酒店管理系統\CodePub.Com說明.txt

?????文件???????1689??2009-05-16?22:13??酒店管理系統\酒店管理系統\CodePub.Com說明.txt

?????文件???????3355??2008-07-03?13:43??酒店管理系統\酒店管理系統\FiveStarGinShopManager\obj\FiveStarGinShopManager.csproj.FileList.txt

?????文件???????9638??2009-01-19?23:22??酒店管理系統\酒店管理系統\FiveStarGinShopManager\obj\Debug\FiveStarGinShopManager.csproj.FileListAbsolute.txt

?????文件????????269??2008-05-28?13:24??酒店管理系統\酒店管理系統\GinShopModels\obj\GinShopModels.csproj.FileList.txt

?????文件???????1689??2009-05-16?22:13??酒店管理系統\酒店管理系統\readme.txt

?????文件?????851968??2008-11-24?22:37??酒店管理系統\酒店管理系統\FiveStarGinShopManager\bin\Debug\FiveStarGinShopManager.exe

?????文件?????851968??2008-11-24?22:37??酒店管理系統\酒店管理系統\FiveStarGinShopManager\obj\Debug\FiveStarGinShopManager.exe

?????文件??????14328??2009-01-19?23:22??酒店管理系統\酒店管理系統\FiveStarGinShopManager\bin\Debug\FiveStarGinShopManager.vshost.exe

?????文件??????16384??2008-05-28?13:07??酒店管理系統\酒店管理系統\GinShopModels\bin\Debug\GinShopModels.exe

?????文件??????16384??2008-05-28?13:07??酒店管理系統\酒店管理系統\GinShopModels\obj\Debug\GinShopModels.exe

?????文件???????5632??2005-12-08?14:51??酒店管理系統\酒店管理系統\GinShopModels\bin\Debug\GinShopModels.vshost.exe

?????文件?????337408??2008-06-16?09:28??酒店管理系統\酒店管理系統\GinShopSetUp\GinShopSetUp\Debug\setup.exe

?????文件??????20480??2008-06-12?14:47??酒店管理系統\酒店管理系統\BinBal\obj\Debug\Refactor\BinBal.dll

?????文件??????40960??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBal\bin\Debug\BinBal.dll

?????文件??????40960??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBal\obj\Debug\BinBal.dll

?????文件??????40960??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBll\bin\Debug\BinBal.dll

?????文件??????40960??2008-11-24?22:37??酒店管理系統\酒店管理系統\FiveStarGinShopManager\bin\Debug\BinBal.dll

?????文件??????12800??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBll\bin\Debug\BinBll.dll

?????文件??????12800??2008-11-24?22:37??酒店管理系統\酒店管理系統\BinBll\obj\Debug\BinBll.dll

?????文件??????12800??2008-11-24?22:37??酒店管理系統\酒店管理系統\FiveStarGinShopManager\bin\Debug\BinBll.dll

............此處省略440個文件信息