userclass.cs

中小企业人力资源管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace HRP.BaseClass
{
    class UserClass
    {
        SqlClass sqlclass = new SqlClass();
        //验证登录
        public string LoginEnter(string strUserName,string strUserPwd)
        {
            string strEnter;
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("select count(*) from tb_Purview where Username=@Username and UserPwd=@UserPwd", con);
            SqlParameter para = new SqlParameter("@Username",SqlDbType.VarChar,20);
            para.Value = strUserName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@UserPwd",SqlDbType.VarChar,20);
            para.Value = strUserPwd;
            scd.Parameters.Add(para);
            int intCount=Convert.ToInt32(scd.ExecuteScalar());
            if (intCount > 0)
            {
                strEnter = "true";
            }
            else
            {
                strEnter = "false";
            }
            return strEnter;
        }
        //权限修改
        public void PurviewEdit(bool blBase, bool blWageSetUp, bool blPersonel, bool blWage, bool blSystem,string strUserName)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("update tb_Purview set Base=@Base,WageSetUp=@WageSetUp,Personel=@Personel,Wage=@Wage,System=@System where UserName=@UserName", con);
            SqlParameter para = new SqlParameter("@Base", SqlDbType.Bit, 1);
            para.Value = blBase;
            scd.Parameters.Add(para);
            para = new SqlParameter("@WageSetUp", SqlDbType.Bit, 1);
            para.Value = blWageSetUp;
            scd.Parameters.Add(para);
            para = new SqlParameter("@Personel", SqlDbType.Bit, 1);
            para.Value = blPersonel;
            scd.Parameters.Add(para);
            para = new SqlParameter("@Wage", SqlDbType.Bit, 1);
            para.Value = blWage;
            scd.Parameters.Add(para);
            para = new SqlParameter("@System", SqlDbType.Bit, 1);
            para.Value = blSystem;
            scd.Parameters.Add(para);
            para = new SqlParameter("@UserName", SqlDbType.VarChar, 20);
            para.Value = strUserName;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            scd.Dispose();
            con.Close();
        }
        //添加用户
        public void UserAdd(string strUsername,string strUserPwd)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("insert into tb_Purview (UserName,UserPwd)values(@UserName,@UserPwd)",con);
            SqlParameter para = new SqlParameter("@UserName", SqlDbType.VarChar, 20);
            para.Value = strUsername;
            scd.Parameters.Add(para);
            para = new SqlParameter("@UserPwd", SqlDbType.VarChar, 20);
            para.Value = strUserPwd;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            scd.Dispose();
            con.Close();
        }
        //判断用户名是否存在
        public bool Rename(string strUserName)
        {
            bool blEnter;
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("select count(*) from tb_Purview where Username=@Username", con);
            SqlParameter para = new SqlParameter("@Username", SqlDbType.VarChar, 20);
            para.Value = strUserName;
            scd.Parameters.Add(para);
            int intCount = Convert.ToInt32(scd.ExecuteScalar());
            if (intCount > 0)
            {
                blEnter = true;
            }
            else
            {
                blEnter = false;
            }
            scd.Dispose();
            con.Close();
            return blEnter;
        }
        //修改密码
        public void UserEdit(string strUserName,string strUserPwd)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("update tb_Purview set UserPwd=@UserPwd where UserName=@UserName",con);
            SqlParameter para = new SqlParameter("@UserName", SqlDbType.VarChar, 20);
            para.Value = strUserName;
            scd.Parameters.Add(para);
            para = new SqlParameter("@UserPwd", SqlDbType.VarChar, 20);
            para.Value = strUserPwd;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            scd.Dispose();
            con.Close();
        }
        //删除用户
        public void UserDelete(string strUserName)
        {
            SqlConnection con = sqlclass.SqlConBind();
            con.Open();
            SqlCommand scd = new SqlCommand("delete from tb_Purview where UserName=@UserName", con);
            SqlParameter para = new SqlParameter("@UserName", SqlDbType.VarChar, 20);
            para.Value = strUserName;
            scd.Parameters.Add(para);
            scd.ExecuteNonQuery();
            scd.Dispose();
            con.Close();
        }
    }
}