using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?hotelInitalData
{
????public?partial?class?admin?:?Form
????{
????
????????public?admin（）
????????{
????????????InitializeComponent（）;
????????????CellsAlignment（）;//單元格居中對(duì)齊
????????}

????????private?void?CellsAlignment（）
????????{
????????????this.dataGridView1.RowsDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView2.RowsDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView3.RowsDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView4.RowsDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView1.ColumnHeadersDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView2.ColumnHeadersDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView3.ColumnHeadersDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????this.dataGridView4.ColumnHeadersDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????????
????????}

????????/**
?????????*?string?msg?=?String.Format（“第{0}行，第{1}列“dataGridView1.CurrentCell.RowIndexdataGridView1.CurrentCell.ColumnIndex）;
?????????*?
?????????*/
????????private?void?admin_Load（object?sender?EventArgs?e）
????????{?????????
????????????this.roomInitalTableAdapter.Fill（this.hotelmanageDataSet.RoomInital）;
????????????this.guestInfoTableAdapter.Fill（this.hotelmanageDataSet.GuestInfo）;??
????????????this.roomInfoTableAdapter.Fill（this.hotelmanageDataSet.RoomInfo）;????
????????????this.loginTableAdapter.Fill（this.hotelmanageDataSet.login）;
????????????dataGridView1.ColumnHeadersDefaultCellstyle.Alignment?=?DataGridViewContentAlignment.MiddleCenter;
????????}
?????????
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
?????????????????????
????????}

????????private?void?dataGridView1_CellEndEdit（object?sender?DataGridViewCellEventArgs?e）
????????{
????????????
????????????int?result?=?0;???????
????????????if?（String.IsNullOrEmpty（this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString（））?||
????????????????String.IsNullOrWhiteSpace（this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString（）））
????????????{??????
????????????????return;
????????????}
????????????switch?（e.ColumnIndex）
????????????{???
????????????????case?1:
????????????????????result?=?SqlHelper.ExecuteNonQuery（“update?login?set?UserName?=?@name?where?Id?=?@Id“
????????????????????????new?SqlParameter（“@name“?this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString（）

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件?????941608??2015-12-16?20:56??QQ截圖20151216205555.jpg

?????文件????4259840??2015-12-16?21:01??hotelmanage.mdf

?????文件????1064960??2015-12-16?21:01??hotelmanage_log.ldf

?????文件????????953??2015-12-16?21:30??使用必看幫助文檔.txt

?????文件?????198237??2015-12-16?21:31??QQ截圖20151216213155.jpg

?????文件?????231991??2015-12-16?21:32??QQ截圖20151216213250.jpg

?????文件????????413??2015-12-13?01:32??text\text\app.config

?????文件????????187??2015-12-04?12:59??text\text\bin\App.config

?????文件??????44544??2013-07-15?23:04??text\text\bin\Debug\AForge.Controls.dll

?????文件??????17920??2013-07-15?23:04??text\text\bin\Debug\AForge.dll

?????文件?????262656??2013-07-15?23:04??text\text\bin\Debug\AForge.Imaging.dll

?????文件??????61440??2013-07-15?23:04??text\text\bin\Debug\AForge.Video.DirectShow.dll

?????文件??????20992??2013-07-15?23:04??text\text\bin\Debug\AForge.Video.dll

????..A..H.???????182??2015-12-13?22:25??text\text\bin\Debug\hotelLog.txt

?????文件??????24148??2015-12-10?18:38??text\text\bin\Debug\images\Active.png

?????文件???????3610??2015-12-06?11:17??text\text\bin\Debug\images\add.jpg

?????文件???????5754??2015-11-02?12:20??text\text\bin\Debug\images\baymax.jpg

?????文件?????249992??2015-12-07?12:28??text\text\bin\Debug\images\BGImage0.jpg

?????文件?????126124??2015-10-02?19:15??text\text\bin\Debug\images\BGImage1.jpg

?????文件????????766??2015-12-06?11:12??text\text\bin\Debug\images\c1.ico

?????文件????????766??2015-12-06?11:12??text\text\bin\Debug\images\c2.ico

?????文件????????766??2015-12-06?11:12??text\text\bin\Debug\images\c3.ico

?????文件?????135484??2015-12-09?08:40??text\text\bin\Debug\images\day_BGImage.jpg

?????文件???????4808??2015-12-06?11:18??text\text\bin\Debug\images\delete.jpg

?????文件???????7015??2015-12-07?21:17??text\text\bin\Debug\images\find.png

?????文件??????36277??2015-11-14?06:55??text\text\bin\Debug\images\kenan.jpg

?????文件??????16958??2015-12-08?00:55??text\text\bin\Debug\images\Lock.ico

?????文件???????4746??2015-12-10?20:49??text\text\bin\Debug\images\Lock.png

?????文件??????98335??2015-12-08?19:27??text\text\bin\Debug\images\locking_BGImage.jpg

?????文件?????110675??2015-12-09?09:09??text\text\bin\Debug\images\lock_BGImage.jpeg

............此處省略266個(gè)文件信息