buyerinfoaccess.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections;
using System.Text;
using System.Windows.Forms;
using System.Data;
using Hotel.DAO;

namespace Hotel.Operation
{
    class BuyerInfoAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;

        public BuyerInfoAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        public ListView GetBuyerInfo(ListView lv)
        {

            string sql = "select BuyerID as 顾客编号,BName as 顾客姓名,Birthday as 登记日期,certificateID as 证件类型编号,BCarNum as 证件号码,BSex as 性别,Phone as 联系电话,Company as 公司名称,NationalityID as 国家编号,ProvinceID as 省份编号,Address as 地址,Blacklist as 是否黑名单,Remark as 备注 from Buyer";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Buyer");
            //添加表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 120;
                if (i == 1)
                    ch.Width = 100;
            }

            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());

                }
                lv.Items.Add(lsvItem);
            }

            return lv;
        }
        public ListView GetBuyerInfo(ListView lv, int BuyerID)
        {

            string sql = "select BuyerID as 顾客编号,BName as 顾客姓名,Birthday as 登记日期,certificateID as 证件类型编号,BCarNum as 证件号码,BSex as 性别,Phone as 联系电话,Company as 公司名称,NationalityID as 国家编号,ProvinceID as 省份编号,Address as 地址,Blacklist as 是否黑名单,Remark as 备注 from Buyer where BuyerID like'%" + BuyerID+"%'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Buyer");
            //添加表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 120;
                if (i == 1)
                    ch.Width = 100;
            }

            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());

                }
                lv.Items.Add(lsvItem);
            }

            return lv;
        }
        public ListView GetBuyerInfo(ListView lv, string BName)
        {

            string sql = "select BuyerID as 顾客编号,BName as 顾客姓名,Birthday as 登记日期,certificateID as 证件类型编号,BCarNum as 证件号码,BSex as 性别,Phone as 联系电话,Company as 公司名称,NationalityID as 国家编号,ProvinceID as 省份编号,Address as 地址,Blacklist as 是否黑名单,Remark as 备注 from Buyer where BName like '%" + BName + "%'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Buyer");
            //添加表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 120;
                if (i == 1)
                    ch.Width = 100;
            }

            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());

                }
                lv.Items.Add(lsvItem);
            }

            return lv;
        }
    }
}