operate_zhiweitable.cs

人力管理系统

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

namespace BusinessLayer
{
    public class Operate_zhiweiTable
    {
        SqlDataAccess sql = new SqlDataAccess();
        Zhiwei zw = new Zhiwei(); 

        public DataTable Selectzhiwei()
        {
            return sql.ExecuteDataSetBySelect("c_Selectzhiwei");
        }

        public int InsertZhiWei(string zw)
        {
            return sql.ExecuteDataSetByUpdate("c_InsertZhiWei",zw);
        }
        public int UpdateZhiwei(Zhiwei zw)
        {
            return sql.ExecuteDataSetByUpdate("c_UpdateZhiwei", zw.ZhiWei,zw.ID);
        }

        public int DeleteZhiwei(Zhiwei zw)
        {
            return sql.ExecuteDataSetByUpdate("c_DeleteZhiwei", zw.ID);
        }
        public int SelectByZhiwei(string zw)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("c_SelectByZhiwei",zw);
            return int.Parse(dt.Rows[0][0].ToString());
        }
    }

}