daluser.cs

登陆界面

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using corInfMan.Utility;
using System.Data;
using System.Data.SqlClient;
namespace corInfMan.DAL
{
    public class DALUser
    {
        public DALUser() { }
        /// <summary>
        /// 是否公司职员
        /// </summary>
        /// <param name="id">员工ID</param>
        /// <param name="name">员工姓名</param>
        /// <returns></returns>
        public static bool isEmployee(int id,string name)
        {
            StringBuilder str = new StringBuilder();
            str.Append("select EmployeeName from aspnet_Employee where EmployeeID=@id ");
            SqlParameter[] parm = {new SqlParameter("@id", SqlDbType.Int)};
            parm[0].Value = id;
            if (SQLHelper.Exists(str.ToString(), parm))
            {
                string retName = SQLHelper.GetSingle(str.ToString(), parm).ToString();
                if (Object.Equals(retName.TrimEnd(new char[]{' '}), name))//从数据库读出时要注意字节长度
                    return true;
                else
                    return false;
                
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 将注册信息写入公司个人信息中
        /// </summary>
        /// <param name="id">员工ID</param>
        /// <param name="name">注册名字</param>
        public void addtoEmployeeInf(string id,string name)
        {
            StringBuilder str = new StringBuilder();
            str.Append("update aspnet_Employee set RegName=@name where EmployeeID=@id ");
            SqlParameter[] parm={new SqlParameter("@name",SqlDbType.NChar),new SqlParameter("@id",SqlDbType.NChar)};
            parm[0].Value = name;
            parm[1].Value = id;
            SQLHelper.ExecuteSql(str.ToString(), parm);
        }
        /// <summary>
        /// 员工是否管理者
        /// </summary>
        /// <param name="id">员工ID</param>
        /// <returns></returns>
        public int isMan(string id)
        {
            string sqlStr = "select isMan from aspnet_Employee where EmployeeID=@id";
            SqlParameter[] parm = { new SqlParameter("@id", SqlDbType.NChar) };
            parm[0].Value = id;
            int man = int.Parse(SQLHelper.GetSingle(sqlStr, parm).ToString());
            return man;
        }
        //public string retUserID(string name)
        //{
        //    string sqlStr = "select UserID from aspnet_Users where UserName=@name";
        //    SqlParameter[] parm = { new SqlParameter("@name",SqlDbType.NVarChar)};
        //    parm[0].Value = name;
        //    return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString();
        //}
        ///// <summary>
        /////将职位 写入注册信息
        ///// </summary>
        ///// <param name="man">职位</param>
        ///// <param name="username">注册名字</param>
        //public void manToUsers(int man,string username)
        //{
        //    string sqlStr = "update aspnet_Users set IsMan=@man where UserName=@username";
        //    SqlParameter[] parm = { new SqlParameter("@man", SqlDbType.Int), new SqlParameter("@username", SqlDbType.NChar) };
        //    parm[0].Value = man;
        //    parm[1].Value = username;
        //    SQLHelper.ExecuteSql(sqlStr, parm);
            
        //}

        /// <summary>
        /// 用户名检测
        /// </summary>
        /// <param name="name">要注册的用户名</param>
        /// <returns></returns>
        public bool userNameCheck(string name)
        {
            string sqlStr = "select UserID from aspnet_Users where UserName=@name";
            SqlParameter[] parm = { new SqlParameter("@name",SqlDbType.NChar)};
            parm[0].Value = name;
            return SQLHelper.Exists(sqlStr, parm);
        }
        
        public string emplloyeeName(string regname)
        {
            string sqlStr = "select EmplloyeeName from aspnet_Emplloyee where RegName=@regname";
            SqlParameter[] parm = { new SqlParameter("@regname",SqlDbType.NChar)};
            parm[0].Value = regname;
            return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString().TrimEnd();
        }

        /// <summary>
        /// 返回用户所在部门
        /// </summary>
        /// <param name="regname">用户注册名</param>
        /// <returns></returns>
        public string sectorName(string regname)
        {
            string sqlStr = "select SectorName from aspnet_Employee where RegName=@regname";
            SqlParameter[] parm = { new SqlParameter("@regname", SqlDbType.NChar) };
            parm[0].Value = regname;
            return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString().TrimEnd();
        }
    }

}