operate_jiangfa2table.cs

人力管理系统

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

namespace BusinessLayer
{
    public class Operate_Jiangfa2Table
    {

        SqlDataAccess sql = new SqlDataAccess();

        public DataTable SelectJiaofa2()
        {
            return sql.ExecuteDataSetBySelect("c_SelectJiaofa2");
        }

        public int NewAddJf(JiangFa2 jf)
        {
            return sql.ExecuteDataSetByUpdate("c_NewAddJf",jf.Yuanying,jf.Fs);
        }
        public int UpdateJfByYy(JiangFa2 jf, string oldyy)
        {
            return sql.ExecuteDataSetByUpdate("c_UpdateJfByYy",jf.Yuanying,jf.Fs,oldyy);
        }
        public int DeleteJfByYy(string yy)
        {
            return sql.ExecuteDataSetByUpdate("c_DeleteJfByYy", yy);
        }

        public DataTable SelectJfByFs1()
        {
            return sql.ExecuteDataSetBySelect("c_SelectJfByFs1");
        }
        public DataTable SelectJfByFs2()
        {
            return sql.ExecuteDataSetBySelect("c_SelectJfByFs2");
        }
        public string SelectIdByYy(string yying)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("c_SelectIdByYy",yying);
            string t = dt.Rows[0][0].ToString();
          return t; 
        }
        public string SelectIdByYy2(string yying)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("c_SelectIdByYy", yying);
            string t = dt.Rows[0][1].ToString();
            return t; 
        }
    }
}