operate_bumentable.cs

人力管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataAccess;
using Entity;



namespace BusinessLayer
{
   public class Operate_bumenTable
    {
      

       SqlDataAccess sql = new SqlDataAccess();
       public DataTable SelectAll()
       {
           return sql.ExecuteDataSetBySelect("c_SelectAll");
       }
       public int InsertBumen(Bumen bu)
       {
           return sql.ExecuteDataSetByUpdate("c_InsertBumen",bu.PID,bu.BuMen);
       }
       public int UpdateBumenByPid(string newbumen ,string oldbunem)
       {
           return sql.ExecuteDataSetByUpdate("c_UpdateBumenByPid",newbumen,oldbunem);
       }
       public int DeleteBumen(string bumen)
       {
           return sql.ExecuteDataSetByUpdate("c_DeleteBumen", bumen);
       }
       public int SelectByBumen(string bm)
       {
           DataTable dt = sql.ExecuteDateSetBySelect("c_SelectByBumen", bm);
           return int .Parse(dt.Rows[0][0].ToString());
       }
    }
}