DAL/DBUser.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//  @ Project : TestOnline
//  @ File Name : DBUser.cs
//  @ Date : 2009-3-12
//  @ Author : ruimingde

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

using Entity;
using Tool;

namespace DAL
{
    public class DBUser : DBOperation<User>
    {
        /// <summary>
        /// 返回-1表示原密码存在、返回1表示修改成功
        /// </summary>
        public int UpdatePwd(string userID, string oldPwd, string newPwd)
        {
            SqlParameter[] parms ={
                new SqlParameter("@reutrnValue",SqlDbType.Int,4),
                new SqlParameter("@userID",SqlDbType.VarChar,30),
                new SqlParameter("@oldPwd",SqlDbType.VarChar,30),
                new SqlParameter("@newPwd",SqlDbType.VarChar,30)
            };
            parms[0].Direction = ParameterDirection.ReturnValue;
            parms[1].Value = userID;
            parms[2].Value = oldPwd;
            parms[3].Value = newPwd;

            DBHelper.ExecuteNonQuery("UP_T_User_ModifyPwd", parms);

            return (int)parms[0].Value;
        }
        public List<User> SelectListByDeptID(short deptID)
        {
            List<User> userList = new List<User>();
            SqlParameter[] parms ={
                new SqlParameter("@deptID",SqlDbType.SmallInt,2)};
            parms[0].Value = deptID;

            using (SqlDataReader dr = DBHelper.Select("UP_T_User_GetListByDeptID", parms))
            {
                while (dr.Read())
                {
                    User user = new User();
                    user.UserID = dr["userID"].ToString();
                    user.UserPwd = dr["userPwd"].ToString();
                    Department dept = new Department();
                    dept.DeptID = deptID;
                    dept.DeptName = dr["deptName"].ToString();
                    user.Department = dept;
                    if (!dr["createdTime"].ToString().Trim().Equals(""))
                    {
                        user.CreatedTime = Convert.ToDateTime(dr["createdTime"]);