SQLServerDAL/User.cs

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

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

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using ElfinNet.Model;
using ElfinNet.IDAL;

namespace ElfinNet.SQLServerDAL
{
    /// <summary>
    /// Data Access Layer For dbo.User.
    /// </summary>
    public class User : IUser
    {
		#region Constructor
		/// <summary>
		/// Default constructor
		/// </summary>
		public User()
		{
		}
		#endregion

        #region Interfaces
		
		/// <summary>
		/// Insert a new user record to database.
		/// </summary>
		/// <param name="oUserInfo"></param>
		/// <returns></returns>
		public int Insert(UserInfo oUserInfo)
		{
			SQLUtil db = new SQLUtil();
			int identityKey = 0;
			DateTime deadDate = new DateTime();
			
			db.AddOutputParameter("@UserName");
			db.AddParameter("@Password",oUserInfo.Password,50);
			if(oUserInfo.Email!=null&&oUserInfo.Email.Length>0){db.AddParameter("@Email",oUserInfo.Email,50);}
			if(oUserInfo.UserGroup.ToString()!=null&&oUserInfo.UserGroup>0){db.AddParameter("@UserGroup",oUserInfo.UserGroup);}
			db.AddParameter("@Active",oUserInfo.Active);

			identityKey = Convert.ToInt32(db.ExecuteScalarWithReturn("USP_UserInsert", "@UserName", SQLUtil.DatabaseType.ElfinNetDB));
			return identityKey;
		}

        /// <summary>
		/// Gets a user record from the database.
		/// </summary>
		/// <param name="userName"></param>
		/// <returns></returns>
		public UserInfo Get(string userName)
		{
			SQLUtil db = new SQLUtil();
			UserInfo oUserInfo = new UserInfo();

			db.AddParameter("@UserName", userName, 20);
			
			using (SqlDataReader rdr = db.ExecuteDataReader("USP_UserGet", SQLUtil.DatabaseType.ElfinNetDB))