tdsselectedinfo.cs

航空公司用的简单管理系统

using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.Common;
using System.ComponentModel;
using System;

namespace SouthernAir.Business.TypeDataSet {

    [DataObject]
    partial class tdsSelectedInfo
    {
        protected static string strPros = "dbo.GetSelectedInfo";

        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public static BSASelectedInfoDataTable GetSelectedInfo(int intFlightID)
        {
            try
            {
                string strConn = "Data Source=TRTGR\\SQLEXPRESS;AttachDbFilename=D:\\Project\\SouthernAir\\SouthernAir.Business\\SouthernAirData.mdf;Integrated Security=True";

                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(strPros, conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@FlightID", intFlightID);
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    DataSet ds = new DataSet();
                    da.Fill(ds, "SelectedInfo");
                    BSASelectedInfoDataTable oDataTable = new BSASelectedInfoDataTable();
                    oDataTable.Merge(ds.Tables["SelectedInfo"]);
                    return oDataTable;
                }
            }
            catch
            {
                BSASelectedInfoDataTable oDataTable = new BSASelectedInfoDataTable();
                return oDataTable;
            }
        }
    }
}