using?DBUtility;
using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Data.SQLite;
using?System.Linq;
using?System.Text;
using?System.Web;

namespace?DAL
{
????public?class?Hotel
????{

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

????????///?增加一條數據酒店信息
????????///?

????????public?int?Add（Model.Hotel?model）
????????{
????????????StringBuilder?strSql?=?new?StringBuilder（）;
????????????strSql.Append（“insert?into?Hotel（“）;
????????????strSql.Append（“HotelNameAddressAddTimeRemarkFlagProvinceNameCityNameZoneName）“）;
????????????strSql.Append（“?values?（“）;
????????????strSql.Append（“@HotelName@Address@AddTime@Remark@Flag@ProvinceName@CityName@ZoneName）“）;
????????????strSql.Append（“;select?LAST_INSERT_ROWID（）“）;
????????????SQLiteParameter[]?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-23?20:15??hotel\
?????目錄???????????0??2017-07-23?20:15??hotel\App_Data\
?????文件??????622592??2017-07-23?20:14??hotel\App_Data\XeederHoltel.sqlite
?????目錄???????????0??2017-07-23?00:03??hotel\DAL\
?????目錄???????????0??2017-07-23?15:18??hotel\DAL\bin\
?????文件???????12800??2017-07-23?15:18??hotel\DAL\bin\DAL.dll
?????文件???????30208??2017-07-23?15:18??hotel\DAL\bin\DAL.pdb
?????文件????????9216??2017-07-18?17:56??hotel\DAL\bin\DBUtility.dll
?????文件???????22016??2017-07-18?17:56??hotel\DAL\bin\DBUtility.pdb
?????文件???????11264??2017-07-23?08:40??hotel\DAL\bin\Model.dll
?????文件???????54784??2017-07-23?08:40??hotel\DAL\bin\Model.pdb
?????文件??????369152??2011-08-14?23:08??hotel\DAL\bin\MySql.Data.dll
?????文件??????847872??2011-08-14?23:08??hotel\DAL\bin\System.Data.SQLite.DLL
?????文件????????5683??2017-07-22?15:13??hotel\DAL\DAL.csproj
?????文件????????1086??2017-07-22?15:13??hotel\DAL\DAL.csproj.user
?????文件????????3008??2017-07-23?00:03??hotel\DAL\Hotel.cs
?????目錄???????????0??2017-07-17?10:39??hotel\DAL\obj\
?????目錄???????????0??2017-07-23?15:18??hotel\DAL\obj\Debug\
?????文件????????1778??2017-07-23?15:18??hotel\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt
?????文件???????23087??2017-07-23?15:18??hotel\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache
?????文件???????12800??2017-07-23?15:18??hotel\DAL\obj\Debug\DAL.dll
?????文件???????30208??2017-07-23?15:18??hotel\DAL\obj\Debug\DAL.pdb
?????文件????????8189??2017-07-22?15:19??hotel\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????????0??2017-07-17?10:35??hotel\DAL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2017-07-17?10:35??hotel\DAL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2017-07-17?10:35??hotel\DAL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????目錄???????????0??2017-07-17?10:35??hotel\DAL\obj\Debug\TempPE\
?????目錄???????????0??2017-07-19?23:56??hotel\DAL\obj\Release\
?????文件???????????0??2017-07-19?23:56??hotel\DAL\obj\Release\build.force
?????文件????????8191??2017-07-22?15:19??hotel\DAL\obj\Release\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????????0??2017-07-17?10:39??hotel\DAL\obj\Release\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
............此處省略237個文件信息