jobinfoaccess.cs

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

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

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

        public JobInfoAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获得商品
        public ListView GetItems(ListView lv,string name)
        {

            string sql = "select UserID as 员工编号,useTime as 操作时间,Note as 操作,NoteMoney as 操作金额 from JobInfo where UserID=(select UserID from UserInfo where EmployeeID=(select EmployeeID from Employee where EmployeeName like'%"+name+"%'))";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "JobInfo");
            //添加表头
            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 == 1)
                    ch.Width = 80;
            }

            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 GetItemsInfo(ListView lv, string type)
        {

            string sql = "select UserID as 员工编号,useTime as 操作时间,Note as 操作,NoteMoney as 操作金额 from JobInfo where UserID like'%"+type+"%'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "JobInfo");
            //添加表头
            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 == 1)
                    ch.Width = 80;
            }

            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 GetItemsInfo(ListView lv)
        {

            string sql = "select UserID as 员工编号,useTime as 操作时间,Note as 操作,NoteMoney as 操作金额 from JobInfo";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "JobInfo");
            //添加表头
            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 == 1)
                    ch.Width = 80;
            }

            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 AddJobInfo(string user,string date,string note,float money)
        {
            string sql = "insert JobInfo values('"+user+"','"+date+"','"+note+"',"+money+")";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
 
        }
    }
}