【正文】 )reader[LoginId]。 = (string)reader[LoginPwd]。}endregion}}BLL（業(yè)務(wù)邏輯層）調(diào)用DALusing System。using 。using 。namespace {public class AdminManager{region 驗(yàn)證用戶 /// summary/// 驗(yàn)證用戶/// /summary/// param name=loginId/param/// param name=loginPwd/param/// returns/returnspublic static bool CheckAdminLogin(string loginName, string loginPwd){//調(diào)用數(shù)據(jù)訪問層的執(zhí)行管理員登錄檢查sql語句Admin admin = (loginName)。//用戶不存在}if ( == loginPwd){return true。//密碼錯(cuò)誤}}endregion}}UI（表示層）調(diào)用BLLusing System。using 。using 。using 。using 。namespace HotelManage{public partial class FrmLogin : Form{public FrmLogin(){InitializeComponent()。}endregionregion 數(shù)據(jù)驗(yàn)證/// summary////// /summary/// returns返回布爾類型/returnspublic bool CheckInputNotEmpty(){if (().Equals()){(請(qǐng)輸入用戶名, 輸入提示, , )。return false。()。}else{return true。}bool bAdmin = ((), ())。return。()。}}catch(Exception ex){(, 登錄失敗, , )。}}endregion}}顧客信息GuestRecordModel層using System。using 。namespace {[Serializable]public class GuestRecord{/// summary/// 無參構(gòu)造方法/// /summarypublic GuestRecord(){}private int guestID。 }set { guestID = value。public string IdentityID{get { return identityID。 }}private string guestName。 }set { guestName = value。public int RoomID{get { return roomID。 }}private int resideID。 }set { resideID = value。public DateTime ResideDate{get { return resideDate。 }}private DateTime leaveDate。 }set { leaveDate = value。public decimal Deposit{get { return deposit。 }}private decimal totalMoney。 }set { totalMoney = value。using 。using 。using 。namespace {public class GuestRecordService{region 入住登記public static int InsertGuestRecord(GuestRecord gRecord){string procName = usp_insertGuestRecord。return (, , procName, paras)。DataSet ds = (, , sql, paras)。foreach (DataRow row in ){GuestRecord guestRecord = new GuestRecord()。 = row[IdentityID].ToString()。 = (row[RoomID])。 = (row[ResideDate])。} = (row[Deposit])。}(guestRecord)。}endregionregion 查詢public static ListGuestRecord GetGuestInfo(DateTime beginDate,DateTime endDate,int resideStateId){string sql = select * from GuestRecord where ResideDate between btime and etime and ResideID=ResideID。return GetGuestRecordBySQL(sql, paras)。SqlParameter[] paras ={new SqlParameter(GuestID,guestId),new SqlParameter(requirePay,requirePay),new SqlParameter(LeaveDate,leaveDate)}。}endregion}}BLL（業(yè)務(wù)邏輯層）調(diào)用DALusing System。using 。using 。namespace {public class GuestRecordManager{region 入住登記public static int InsertGuestRecord(GuestRecord gRecord){return (gRecord)。}endregionregion 結(jié)算public static decimal GetAmount(int roomId, int days){Room room = (roomId)。if (rType != null){return * days。}endregionregion 退房public static decimal RefundRoom(int guestId, decimal requirePay, DateTime leaveDate){return (guestId,requirePay,leaveDate)。using 。using 。using 。using 。using 。namespace HotelManage{public partial class FrmRecordInfo : Form{public FrmRecordInfo(){InitializeComponent()。foreach (ResideState resideState in rmStates){ = ()。 = ResideName。}catch (Exception ex){(, 操作錯(cuò)誤, , )。}}public void DBind(){int resideStateId = ()。DateTime endDate = ()。 = false。()。 = 。 = ResideName。foreach (DataGridViewRow row in ){int id = (int)([RoomID].Value)。[TypeName].Value = ().TypeName。}}endregionprivate void FrmRecordInfo_Load(object sender, EventArgs e){()。()。}private void InitAmount(){int roomId = ([RoomID].())。int nDays = ((resideDate).Hours % 24 == 0 ? 0 : 1) + (resideDate).Days。 = ()。return。}private void btnOk_Click(object sender, EventArgs e){if ( 0){if (([0].Cells[ResideId].Value) == 2){(已經(jīng)結(jié)賬)。}int guestId = ([GuestID].Value)。if (refundAmount 0){((退房成功，應(yīng)退還押金{0}元, refundAmount))。}()。}SaveFileDialog sflg = new SaveFileDialog()。 = (*.xls)|*.xls。try{if (result == ){ExcelHandle excel = new ExcelHandle()。}}catch (Exception ex){(數(shù)據(jù)導(dǎo)出異常 + )。using 。using 。using 。using 。using 。private int roomValue。 = true。}private void FrmGuestInfo_Load(object sender, EventArgs e){ListRoom rooms = ()。} = rooms。 = roomID。}}region 數(shù)據(jù)驗(yàn)證/// summary////// /summary/// returns返回布爾類型/returnspublic bool CheckInputNotEmpty(){if (().Equals()){(請(qǐng)輸入請(qǐng)輸入身份證號(hào), 輸入提示, , )。return false。()。}else if (().Equals()){(請(qǐng)輸入押金, 輸入提示, , )。return false。}}endregionprivate void btnOK_Click(object sender, EventArgs e){if (!CheckInputNotEmpty()){return。 = ()。 = ()。 = (())。if (rowcount 0){(添加成功)。}}catch (Exception ex){(添加失敗！