【摘要】: 互联网和计算机技术在各行各业的广泛应用和取得的惊人效益, 酒店经营者也争相把目光投入到用计算机的先进技术来管理酒店上来, 较之于传统的手工管理, 酒店管理系统就显示出了 它独特的优势: 市场经济的迅速发展和人们生活水平的不断提高, 宾馆酒店业的竞争越来越激烈。 要想在竞争中取得优势, 面对庞大的信息量, 就需要一个酒店管理系统来提高酒店管理效率。 本文主要介绍了开发一个酒店管理系统的分析和设计过程。 它运行在单机环境下, 实现了最基本和最核心的功能。
以下是部份源码,全部源码请下载
//------------------------------------------------------------------------------
// <autogenerated>
// This code was generated by a tool.
// Runtime Version: 1.1.4322.573
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------
namespace ConnectDBLibrary {
using System;
using System.Data;
using System.Xml;
using System.Runtime.Serialization;
[Serializable()]
[System.ComponentModel.DesignerCategoryAttribute('code')]
[System.Diagnostics.DebuggerStepThrough()]
[System.ComponentModel.ToolboxItem(true)]
public class ConList : DataSet {
private view_ConListDataTable tableview_ConList;
public ConList() {
this.InitClass();
System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
this.Tables.CollectionChanged += schemaChangedHandler;
this.Relations.CollectionChanged += schemaChangedHandler;
}
protected ConList(SerializationInfo info, StreamingContext context) {
string strSchema = ((string)(info.GetValue('XmlSchema', typeof(string))));
if ((strSchema != null)) {
DataSet ds = new DataSet();
ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));
if ((ds.Tables['view_ConList'] != null)) {
this.Tables.Add(new view_ConListDataTable(ds.Tables['view_ConList']));
}
this.DataSetName = ds.DataSetName;
this.Prefix = ds.Prefix;
this.Namespace = ds.Namespace;
this.Locale = ds.Locale;
this.CaseSensitive = ds.CaseSensitive;
this.EnforceConstraints = ds.EnforceConstraints;
this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
this.InitVars();
}
else {
this.InitClass();
}
this.GetSerializationData(info, context);
System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
this.Tables.CollectionChanged += schemaChangedHandler;
this.Relations.CollectionChanged += schemaChangedHandler;
}
[System.ComponentModel.Browsable(false)]
[System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
public view_ConListDataTable view_ConList {
get {
return this.tableview_ConList;
}
}
public override DataSet Clone() {
ConList cln = ((ConList)(base.Clone()));
cln.InitVars();
return cln;
}
protected override bool ShouldSerializeTables() {
return false;
}
protected override bool ShouldSerializeRelations() {
return false;
}
protected override void ReadXmlSerializable(XmlReader reader) {
this.Reset();
DataSet ds = new DataSet();
ds.ReadXml(reader);
if ((ds.Tables['view_ConList'] != null)) {
this.Tables.Add(new view_ConListDataTable(ds.Tables['view_ConList']));
}
this.DataSetName = ds.DataSetName;
this.Prefix = ds.Prefix;
this.Namespace = ds.Namespace;
this.Locale = ds.Locale;
this.CaseSensitive = ds.CaseSensitive;
this.EnforceConstraints = ds.EnforceConstraints;
this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
this.InitVars();
}
protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
System.IO.MemoryStream stream = new System.IO.MemoryStream();
this.WriteXmlSchema(new XmlTextWriter(stream, null));
stream.Position = 0;
return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
}
internal void InitVars() {
this.tableview_ConList = ((view_ConListDataTable)(this.Tables['view_ConList']));
if ((this.tableview_ConList != null)) {
this.tableview_ConList.InitVars();
}
}
private void InitClass() {
this.DataSetName = 'ConList';
this.Prefix = '';
this.Namespace = 'http://tempuri.org/ConList.xsd';
this.Locale = new System.Globalization.CultureInfo('zh-CN');
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableview_ConList = new view_ConListDataTable();
this.Tables.Add(this.tableview_ConList);
}
private bool ShouldSerializeview_ConList() {
return false;
}
private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
this.InitVars();
}
}
public delegate void view_ConListRowChangeEventHandler(object sender, view_ConListRowChangeEvent e);
[System.Diagnostics.DebuggerStepThrough()]
public class view_ConListDataTable : DataTable, System.Collections.IEnumerable {
private DataColumn columnSid;
private DataColumn columnNrid;
private DataColumn columnWname;
private DataColumn columnWprice;
private DataColumn columnDiscount;
private DataColumn columnSnumber;
private DataColumn columnStotal;
private DataColumn columnSdatetime;
private DataColumn columnEname;
private DataColumn columnAname;
internal view_ConListDataTable() :
base('view_ConList') {
this.InitClass();
}
internal view_ConListDataTable(DataTable table) :
base(table.TableName) {
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
this.DisplayExpression = table.DisplayExpression;
}
[System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
internal DataColumn SidColumn {
get {
return this.columnSid;
}
}
internal DataColumn NridColumn {
get {
return this.columnNrid;
}
}
internal DataColumn WnameColumn {
get {
return this.columnWname;
}
}
internal DataColumn WpriceColumn {
get {
return this.columnWprice;
}
}
internal DataColumn DiscountColumn {
get {
return this.columnDiscount;
}
}
internal DataColumn SnumberColumn {
get {
return this.columnSnumber;
}
}
internal DataColumn StotalColumn {
get {
return this.columnStotal;
}
}
internal DataColumn SdatetimeColumn {
get {
return this.columnSdatetime;
}
}
internal DataColumn EnameColumn {
get {
return this.columnEname;
}
}
internal DataColumn AnameColumn {
get {
return this.columnAname;
}
}
public view_ConListRow this[int index] {
get {
return ((view_ConListRow)(this.Rows[index]));
}
}
public event view_ConListRowChangeEventHandler view_ConListRowChanged;
public event view_ConListRowChangeEventHandler view_ConListRowChanging;
public event view_ConListRowChangeEventHandler view_ConListRowDeleted;
public event view_ConListRowChangeEventHandler view_ConListRowDeleting;
public void Addview_ConListRow(view_ConListRow row) {
this.Rows.Add(row);
}
public view_ConListRow Addview_ConListRow(string Nrid, string Wname, System.Decimal Wprice, System.Double Discount, int Snumber, System.Double Stotal, System.DateTime Sdatetime, string Ename, string Aname) {
view_ConListRow rowview_ConListRow = ((view_ConListRow)(this.NewRow()));
rowview_ConListRow.ItemArray = new object[] {
null,
Nrid,
Wname,
Wprice,
Discount,
Snumber,
Stotal,
Sdatetime,
Ename,
Aname};
this.Rows.Add(rowview_ConListRow);
return rowview_ConListRow;
}
public System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
public override DataTable Clone() {
view_ConListDataTable cln = ((view_ConListDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
protected override DataTable CreateInstance() {
return new view_ConListDataTable();
}
internal void InitVars() {
this.columnSid = this.Columns['Sid'];
this.columnNrid = this.Columns['Nrid'];
this.columnWname = this.Columns['Wname'];
this.columnWprice = this.Columns['Wprice'];
this.columnDiscount = this.Columns['Discount'];
this.columnSnumber = this.Columns['Snumber'];
this.columnStotal = this.Columns['Stotal'];
this.columnSdatetime = this.Columns['Sdatetime'];
this.columnEname = this.Columns['Ename'];
this.columnAname = this.Columns['Aname'];
}
private void InitClass() {
this.columnSid = new DataColumn('Sid', typeof(int), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnSid);
this.columnNrid = new DataColumn('Nrid', typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnNrid);
this.columnWname = new DataColumn('Wname', typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnWname);
this.columnWprice = new DataColumn('Wprice', typeof(System.Decimal), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnWprice);
this.columnDiscount = new DataColumn('Discount', typeof(System.Double), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnDiscount);
this.columnSnumber = new DataColumn('Snumber', typeof(int), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnSnumber);
this.columnStotal = new DataColumn('Stotal', typeof(System.Double), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnStotal);
this.columnSdatetime = new DataColumn('Sdatetime', typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnSdatetime);
this.columnEname = new DataColumn('Ename', typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnEname);
this.columnAname = new DataColumn('Aname', typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnAname);
this.columnSid.AutoIncrement = true;
this.columnSid.AllowDBNull = false;
this.columnSid.ReadOnly = true;
this.columnNrid.AllowDBNull = false;
this.columnWname.AllowDBNull = false;
this.columnWprice.AllowDBNull = false;
this.columnDiscount.AllowDBNull = false;
this.columnSnumber.AllowDBNull = false;
this.columnStotal.ReadOnly = true;
this.columnEname.AllowDBNull = false;
this.columnAname.AllowDBNull = false;
}
public view_ConListRow Newview_ConListRow() {
return ((view_ConListRow)(this.NewRow()));
}
protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
return new view_ConListRow(builder);
}
protected override System.Type GetRowType() {
return typeof(view_ConListRow);
}
protected override void OnRowChanged(DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.view_ConListRowChanged != null)) {
this.view_ConListRowChanged(this, new view_ConListRowChangeEvent(((view_ConListRow)(e.Row)), e.Action));
}
}
protected override void OnRowChanging(DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.view_ConListRowChanging != null)) {
this.view_ConListRowChanging(this, new view_ConListRowChangeEvent(((view_ConListRow)(e.Row)), e.Action));
}
}
protected override void OnRowDeleted(DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.view_ConListRowDeleted != null)) {
this.view_ConListRowDeleted(this, new view_ConListRowChangeEvent(((view_ConListRow)(e.Row)), e.Action));
}
}
protected override void OnRowDeleting(DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.view_ConListRowDeleting != null)) {
this.view_ConListRowDeleting(this, new view_ConListRowChangeEvent(((view_ConListRow)(e.Row)), e.Action));
}
}
public void Removeview_ConListRow(view_ConListRow row) {
this.Rows.Remove(row);
}
}
[System.Diagnostics.DebuggerStepThrough()]
public class view_ConListRow : DataRow {
private view_ConListDataTable tableview_ConList;
internal view_ConListRow(DataRowBuilder rb) :
base(rb) {
this.tableview_ConList = ((view_ConListDataTable)(this.Table));
}
public int Sid {
get {
return ((int)(this[this.tableview_ConList.SidColumn]));
}
set {
this[this.tableview_ConList.SidColumn] = value;
}
}
public string Nrid {
get {
return ((string)(this[this.tableview_ConList.NridColumn]));
}
set {
this[this.tableview_ConList.NridColumn] = value;
}
}
public string Wname {
get {
return ((string)(this[this.tableview_ConList.WnameColumn]));
}
set {
this[this.tableview_ConList.WnameColumn] = value;
}
}
public System.Decimal Wprice {
get {
return ((System.Decimal)(this[this.tableview_ConList.WpriceColumn]));
}
set {
this[this.tableview_ConList.WpriceColumn] = value;
}
}
public System.Double Discount {
get {
return ((System.Double)(this[this.tableview_ConList.DiscountColumn]));
}
set {
this[this.tableview_ConList.DiscountColumn] = value;
}
}
public int Snumber {
get {
return ((int)(this[this.tableview_ConList.SnumberColumn]));
}
set {
this[this.tableview_ConList.SnumberColumn] = value;
}
}
public System.Double Stotal {
get {
try {
return ((System.Double)(this[this.tableview_ConList.StotalColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException('无法获取值,因为它是 DBNull。', e);
}
}
set {
this[this.tableview_ConList.StotalColumn] = value;
}
}
public System.DateTime Sdatetime {
get {
try {
return ((System.DateTime)(this[this.tableview_ConList.SdatetimeColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException('无法获取值,因为它是 DBNull。', e);
}
}
set {
this[this.tableview_ConList.SdatetimeColumn] = value;
}
}
public string Ename {
get {
return ((string)(this[this.tableview_ConList.EnameColumn]));
}
set {
this[this.tableview_ConList.EnameColumn] = value;
}
}
public string Aname {
get {
return ((string)(this[this.tableview_ConList.AnameColumn]));
}
set {
this[this.tableview_ConList.AnameColumn] = value;
}
}
public bool IsStotalNull() {
return this.IsNull(this.tableview_ConList.StotalColumn);
}
public void SetStotalNull() {
this[this.tableview_ConList.StotalColumn] = System.Convert.DBNull;
}
public bool IsSdatetimeNull() {
return this.IsNull(this.tableview_ConList.SdatetimeColumn);
}
public void SetSdatetimeNull() {
this[this.tableview_ConList.SdatetimeColumn] = System.Convert.DBNull;
}
}
[System.Diagnostics.DebuggerStepThrough()]
public class view_ConListRowChangeEvent : EventArgs {
private view_ConListRow eventRow;
private DataRowAction eventAction;
public view_ConListRowChangeEvent(view_ConListRow row, DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public view_ConListRow Row {
get {
return this.eventRow;
}
}
public DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}