Backup/SQLServerDAL/UserGroup.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.UserGroup.
    /// </summary>
    public class UserGroup : IUserGroup
    {
		#region Constructor
		/// <summary>
		/// Default constructor
		/// </summary>
		public UserGroup()
		{
		}
		#endregion

        #region Interfaces
		
		/// <summary>
		/// Insert a new usergroup record to database.
		/// </summary>
		/// <param name="oUserGroupInfo"></param>
		/// <returns></returns>
		public int Insert(UserGroupInfo oUserGroupInfo)
		{
			SQLUtil db = new SQLUtil();
			int identityKey = 0;
			DateTime deadDate = new DateTime();
			
			db.AddOutputParameter("@UserGroupID");
			db.AddParameter("@Name",oUserGroupInfo.Name,50);
			db.AddParameter("@Active",oUserGroupInfo.Active);

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

        /// <summary>
		/// Gets a usergroup record from the database.
		/// </summary>
		/// <param name="userGroupID"></param>
		/// <returns></returns>
		public UserGroupInfo Get(int userGroupID)
		{
			SQLUtil db = new SQLUtil();
			UserGroupInfo oUserGroupInfo = new UserGroupInfo();

			db.AddParameter("@UserGroupID", userGroupID);
			
			using (SqlDataReader rdr = db.ExecuteDataReader("USP_UserGroupGet", SQLUtil.DatabaseType.ElfinNetDB))
			{
				rdr.Read();