associatoraccess.cs

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

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

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

        public AssociatorAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //添加卡类型
        public int AddAssociator(string name,float re,int am,string rema)
        {
            string sql = "insert Associator values('"+name+"',"+re+","+am+",'"+rema+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //添加卡的类型信息到表
        public ListView GetAssociatorInfo(ListView lv)
        {
            string sql = "select 类型编号=CarID,类型名称=CarType,折扣=Rebate,积分统计点=amass,备注=Remark from Associator";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Associator");
           
            //添加表头
            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 = 70;
                if (i == 3)
                    ch.Width = 90;
            }

            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 int ModifiInfo(string name, float re, int am, string rema,int num)
        {
            string sql = "update Associator set CarType='"+name+"',Rebate="+re+",amass="
                +am+",Remark='"+rema+"' where CarID="+num;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //查询某类型卡信息到界面
        public SqlDataReader GetInfo(int num)
        {
            string sql = "select * from Associator where CarID="+num;
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            return dr;
        }
        //查询所有会员卡各类型的名称
        public ArrayList GetAllName()
        {
            ArrayList arr=new ArrayList();
            string sql = "select CarType from Associator";
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {   
                for (int i = 0; i < dr.FieldCount; i++)
                {
                    arr.Add(dr.GetValue(i).ToString());
                    dr.Read();
                }
                
            }
            dr.Close();
            return arr;
        }
        //删除
        public int DeleteInfo(int num)
        {
            string sql = "Delete from Associator where CarID="+num;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //查询所有会员卡各类型的名称
        public DataSet GetName()
        {
            string sql = "select CarType from Associator";
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "Associator");
            return ds;
        }
      

    }
}