Bll/tab_emps.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using SQLFactoryDAL;
using System.Data;
using DAL;
namespace Bll
{
    public class tab_emps
    {
        SQLAccess sqlManager = new SQLAccess();
        public DataTable GetAll()
        {
            return Getany("select * from tab_emps join tab_roles on tab_emps.roleID=tab_roles.roleID");
        }
        public DataTable GetAll(int eid)
        {
            return Getany("select * from tab_emps join tab_roles on tab_emps.roleID=tab_roles.roleID where EmpID="+eid);
        }
        public DataTable Getany(string strsql)
        {
            return sqlManager.ExecuteDataSet(strsql).Tables[0];
        }
        public int Delete(int id)
        {
            return sqlManager.ExecuteNonQuery("delete from tab_emps where empID=" + id);
        }
        public int Update(string sql)
        {
            return sqlManager.ExecuteNonQuery(sql);
        }
    }
}