dbconnection.cs

来自「航运管理系统」· CS 代码 · 共 108 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ShipManageSystem
{
    class DBConnection
    {
        SqlConnection conn;
        SqlDataAdapter adap;
        DataSet ds = new DataSet();
        String sql;

        public SqlConnection getConnection()
        {
            conn = new SqlConnection("server=1.1.1.1;database=shipManageSystem;uid=sa;pwd=stay hungry");
         //   conn = new SqlConnection("server=localhost;database=shipManageSystem;uid=sa;pwd=sa");
            return conn;
        }

        public SqlDataAdapter getAdapter(String type)
        {
            SqlConnection conn = getConnection();

            if(type.Equals("customer"))
            {
                sql = "select * from 货主";
                adap = new SqlDataAdapter(sql, conn);    
            }

            else if (type.Equals("ship"))
            {
                sql = "select * from 船舶";
                adap = new SqlDataAdapter(sql, conn);
            }

            else if (type.Equals("bill"))
            {
                sql = "select * from 清单";
                adap = new SqlDataAdapter(sql, conn);
            }

            else if (type.Equals("date"))
            {
                sql = "select * from 班轮船期";
                adap = new SqlDataAdapter(sql, conn);
            }

            return adap;
        }

        public DataSet fill() 
        {
            SqlConnection conn = getConnection();

            adap = getAdapter("customer");
            adap.Fill(ds, "货主管理");

            adap = getAdapter("ship");
            adap.Fill(ds, "船舶管理");

            adap = getAdapter("bill");
            adap.Fill(ds, "清单管理");

            adap = getAdapter("date");
            adap.Fill(ds, "班轮船期");

            return ds;
        }

        public DataSet search(string search,string type) 
        {
            SqlConnection conn = getConnection();

            adap = new SqlDataAdapter(search, conn);
            if(type.Equals("customer"))
                adap.Fill(ds,"货主管理");
            else if(type.Equals("ship"))
                adap.Fill(ds,"船舶管理");
            else if(type.Equals("bill"))
                adap.Fill(ds,"清单管理");
            else if (type.Equals("date"))
                adap.Fill(ds,"班轮船期");

            return ds;
        }

        public DataSet index(string search, string type)
        {
            SqlConnection conn = getConnection();

            adap = new SqlDataAdapter(search, conn);
            if (type.Equals("customer"))
                adap.Fill(ds, "货主");
            else if (type.Equals("ship"))
                adap.Fill(ds, "船舶");
            else if (type.Equals("bill"))
                adap.Fill(ds, "清单");
            else if (type.Equals("date"))
                adap.Fill(ds, "船期");
            
            return ds;
        }
    }
}