operate_xinxibiao.cs

人力管理系统

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


namespace BusinessLayer
{
    public class Operate_Xinxibiao
    {
        SqlDataAccess sql = new SqlDataAccess();
        xinxibiao xinxi = new xinxibiao();

        public DataTable SelectXinxibiao()
        {
            return sql.ExecuteDataSetBySelect("c_SelectXinxibiao");
         }
        public DataTable SelectXinxibiao2()
        {
            return sql.ExecuteDataSetBySelect("c_SelectXinxibiao2");
        }
        public int SaveXinxi(xinxibiao x)
        {
            return sql.ExecuteDataSetByUpdate("c_SaveXinxi", x.ID, x.Name, x.Sex, x.Birth, x.ID_card, x.Telephone, x.Address, x.BuMen, x.Zhiwei, x.Cheng, x.GZ, x.InDate, x.Begin, x.End,  x.Jian, x.Bei, x.Image);
                                                        //     1,     1,         1,   1,          1,       1,      1,      1  ,    1,      1,      1,      1,      1,      1,          1,          1,          1);//                        
        }
        public DataTable SelectByChina(string condition)
        {
            return sql.ExecuteDateSetBySelect("c_SelectByChina",condition);
        }
        public DataTable SelectByNumber(string condition)
        {
            return sql.ExecuteDateSetBySelect("c_SelectByNumber", condition);
        }

        public int DeleteByID(string id)
        {
            return sql.ExecuteDataSetByUpdate("c_DeleteByID",id);
        }
        public DataTable SelectPhoto(string id)
        {
            return sql.ExecuteDateSetBySelect("c_SelectPhoto", id);
        }
    }
}