using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Configuration;
using?System.Data.SqlClient;
using?BinModel;
//Download?by?http://www.codefans.net
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;

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

?????文件????3342336??2009-05-18?23:41??酒店管理系統\DB\GinShop.mdf

?????文件????1376256??2009-04-07?16:56??酒店管理系統\DB\GinShop_log.LDF

?????文件??????40960??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\bin\Debug\BinBal.dll

?????文件?????169472??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\bin\Debug\BinBal.pdb

?????文件??????16896??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\bin\Debug\BinModel.dll

?????文件?????132608??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\bin\Debug\BinModel.pdb

?????文件???????3317??2008-11-24?22:33??酒店管理系統\酒店管理系統\BinBal\BinDal.csproj

?????文件???????4979??2009-05-18?23:47??酒店管理系統\酒店管理系統\BinBal\CustomBookServices.cs

?????文件??????15908??2008-06-14?18:05??酒店管理系統\酒店管理系統\BinBal\CustomersServices.cs

?????文件???????1877??2009-05-18?23:47??酒店管理系統\酒店管理系統\BinBal\Dals.cs

?????文件???????1308??2008-06-10?16:19??酒店管理系統\酒店管理系統\BinBal\DeleteEmloyeeSalary.cs

?????文件???????1803??2008-06-10?16:19??酒店管理系統\酒店管理系統\BinBal\EmployeeSalaryBinDal.cs

?????文件???????1540??2008-06-13?15:35??酒店管理系統\酒店管理系統\BinBal\EmployeeSalaryServer.cs

?????文件??????12159??2009-05-18?23:47??酒店管理系統\酒店管理系統\BinBal\EmployeeServices.cs

?????文件???????1533??2008-06-07?10:39??酒店管理系統\酒店管理系統\BinBal\EmpStateServices.cs

?????文件???????2189??2008-06-05?13:17??酒店管理系統\酒店管理系統\BinBal\Everyserver.cs

?????文件???????1489??2009-05-18?23:48??酒店管理系統\酒店管理系統\BinBal\GoodsServices.cs

?????文件??????10493??2009-05-18?23:47??酒店管理系統\酒店管理系統\BinBal\GroupRegisServices.cs

?????文件???????1461??2008-06-07?10:09??酒店管理系統\酒店管理系統\BinBal\JobServices.cs

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

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

?????文件??????40960??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\obj\Debug\BinBal.dll

?????文件?????169472??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\obj\Debug\BinBal.pdb

?????文件???????1623??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\obj\Debug\BinDal.csproj.FileListAbsolute.txt

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

?????文件???????3843??2010-03-04?18:22??酒店管理系統\酒店管理系統\BinBal\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1410??2008-05-30?15:02??酒店管理系統\酒店管理系統\BinBal\PopedomsServices.cs

?????文件???????1313??2001-08-19?17:08??酒店管理系統\酒店管理系統\BinBal\Properties\AssemblyInfo.cs

?????文件???????9049??2009-05-04?07:06??酒店管理系統\酒店管理系統\BinBal\Properties\from-download.gif

?????文件???????1465??2009-05-18?23:47??酒店管理系統\酒店管理系統\BinBal\ProvincesServices.cs

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