storeyda.cs

酒店管理软件,c#版本可以选择不同的模式

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data;
using System.Data.Common;
using Hotel.Command;


namespace Hotel.DA
{
    public class StoreyDA
    {
        public Int32 AddStoreyUnit(string dm, string demo, Boolean default1, Boolean hide)
        {
            Database db = DatabaseFactory.CreateDatabase();
            string sqlCommand = "AddStoreyUnit";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            // Retrieve products from the specified category.
            db.AddInParameter(dbCommand, "dm", DbType.String, dm);
            db.AddInParameter(dbCommand, "demo", DbType.String, demo);
            db.AddInParameter(dbCommand, "default1", DbType.Boolean, default1);
            db.AddInParameter(dbCommand, "hide", DbType.Boolean, hide);

            // DataSet that will hold the returned results		

            Int32 resultCon = db.ExecuteNonQuery(dbCommand);

            
            return resultCon;

        }

        public DataSet  GetStoreyAll()
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "GetStoreyAll";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
	
            DataSet productsDataSet = null;

            productsDataSet = db.ExecuteDataSet(dbCommand);

            // Note: connection was closed by ExecuteDataSet method call 

            return productsDataSet;
        }

        public DataSet GetLayerInUnit(string unit)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "GetLayerInUnit";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "unit", DbType.String, unit);

            DataSet productsDataSet = null;

            productsDataSet = db.ExecuteDataSet(dbCommand);

            // Note: connection was closed by ExecuteDataSet method call 

            return productsDataSet;
        }
         
        public Boolean UpdateStoryUnitOf(string  dm,string memo,
                            Boolean  default1,Boolean hide,Int32  id)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "UpdateStoryUnitOf";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "dm", DbType.String, dm);
            db.AddInParameter(dbCommand, "memo", DbType.String, memo);
            db.AddInParameter(dbCommand, "default", DbType.Boolean, default1);
            db.AddInParameter(dbCommand, "hide", DbType.Boolean, hide);
            db.AddInParameter(dbCommand, "id", DbType.Int32, id);

            Int32 resu=db.ExecuteNonQuery(dbCommand);

            BaseMothed bm = new BaseMothed();
            return bm.ResultIntToBool(resu);
   
        }

        public Boolean UpdateStoryLayerOf(string unitDm,string layerDm, string memo,
                               string layer, Boolean default1, Boolean hide, Int32 id)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "UpdateStoryLayerOf";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "unitDm", DbType.String, unitDm);
            db.AddInParameter(dbCommand, "layerDm", DbType.String, layerDm);
            db.AddInParameter(dbCommand, "memo", DbType.String, memo);
            db.AddInParameter(dbCommand, "layer", DbType.String, layer);
            db.AddInParameter(dbCommand, "default", DbType.Boolean, default1);
            db.AddInParameter(dbCommand, "hide", DbType.Boolean, hide);
            db.AddInParameter(dbCommand, "id", DbType.Int32, id);

            Int32 resu = db.ExecuteNonQuery(dbCommand);

            BaseMothed bm = new BaseMothed();
            return bm.ResultIntToBool(resu);

        }

        public Boolean UpdateStoryRoomOf(string unitDm, string layerDm, 
                                      string no, string class1,
                                      string style, Int32 population,
                                      Boolean used, string id)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "UpdateStoryRoomOf";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "unitDm", DbType.String, unitDm);
            db.AddInParameter(dbCommand, "layerDm", DbType.String, layerDm);
            db.AddInParameter(dbCommand, "no", DbType.String, no);
            db.AddInParameter(dbCommand, "class", DbType.String, class1);
            db.AddInParameter(dbCommand, "style", DbType.String, style);
            db.AddInParameter(dbCommand, "population", DbType.Int32, population);
            db.AddInParameter(dbCommand, "used", DbType.Boolean, used);
            db.AddInParameter(dbCommand, "id", DbType.Int32, id);

            Int32 resu = db.ExecuteNonQuery(dbCommand);

            BaseMothed bm = new BaseMothed();
            return bm.ResultIntToBool(resu);

        }
        public DataSet GetRoomInLayer(string unit,string layer)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "GetRoomInLayer";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "unit", DbType.String, unit);
            db.AddInParameter(dbCommand, "layer", DbType.String, layer);

            DataSet productsDataSet = null;

            productsDataSet = db.ExecuteDataSet(dbCommand);

            // Note: connection was closed by ExecuteDataSet method call 

            return productsDataSet;
        }

        public DataSet GetStoreyLayerAll(string dm)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "GetStoreyLayerAll";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "dm", DbType.String, dm);

            DataSet productsDataSet = null;

            productsDataSet = db.ExecuteDataSet(dbCommand);

            // Note: connection was closed by ExecuteDataSet method call 

            return productsDataSet;
        }
        public Boolean GetStoreyUnitInDm(string dm,
              out string memo, out  Boolean default1, out  Boolean hide, out Int32 id)
        {
            memo = "";
            default1=false;
            hide = false;
            id = 0;
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "GetStoreyUnitInDm";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "dm", DbType.String, dm);


            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                // Iterate through DataReader and put results to the text box.
                // DataReaders cannot be bound to Windows Form controls (e.g. the
                // resultsDataGrid), but may be bound to Web Form controls.
                if (dataReader.Read())
                {
                    // Get the value of the 'Name' column in the DataReader
                    memo = dataReader["楼区解释"].ToString() ;
                    default1 =System.Convert.ToBoolean( dataReader["省缺"].ToString());
                    hide = System.Convert.ToBoolean(dataReader["预留"].ToString());
                    id = System.Convert.ToInt32(dataReader["流水号"].ToString()); 
                    return true;
                }
            }

            return false;
        }
    }
}