usertype.cs

该服务平台解决了计算机网络与移动网络之间信息交换问题

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace DataAccess.TableAccessor
{
    public class UserType
    {
        private const string SQL_GET_MOST_AREA = "SELECT AreaID, AreaCode, AreaName, Remark FROM Area WHERE IsValid <> 0";
        private const string SQL_DEL_AREA = "UPDATE Area SET IsValid = 0 WHERE AreaCode = '{0}'";
        private Database db = null;
        public UserType()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        private int UpdateUserTypeTable(TableDefine.UserTypeDefine userTypeDefine)
        {

            DbCommand insertCommand = db.GetStoredProcCommand("AddUserType");
            db.AddInParameter(insertCommand, "@UserTypeName", DbType.String,"TypeName",DataRowVersion.Current);
            db.AddInParameter(insertCommand, "@Remark", DbType.String, "Remark", DataRowVersion.Current);

            DbCommand deleteCommand = db.GetStoredProcCommand("DeleteUserType");
            db.AddInParameter(deleteCommand, "@UserTypeID", DbType.Int32,"UserTypeID",DataRowVersion.Current);

            DbCommand updateCommand = db.GetStoredProcCommand("UpateUserType");
            db.AddInParameter(updateCommand, "@UserTypeID", DbType.Int32,"UserTypeID",DataRowVersion.Current);
            db.AddInParameter(updateCommand, "@TypeName", DbType.String,"TypeName",DataRowVersion.Current);

            int rowsAffected = db.UpdateDataSet(userTypeDefine, "UserType", insertCommand, 
                updateCommand, deleteCommand, UpdateBehavior.Standard);
            return rowsAffected;
        }

        /// <summary>
        /// 得到所有的用户类型信息
        /// </summary>
        /// <returns>用户类型信息表</returns>
        public DataTable GetMostUserType()
        {
            //TableDefine.UserTypeDefine UserTypeDataSet = new DataAccess.TableDefine.UserTypeDefine();
            //db.LoadDataSet(CommandType.StoredProcedure, "GetMostUserType", UserTypeDataSet, new string[] {"UserType"});
            //return UserTypeDataSet;
            DataSet ds = db.ExecuteDataSet(CommandType.Text, SQL_GET_MOST_AREA);
            return ds.Tables[0];
        }

        /// <summary>
        /// 根据用户类型号删除用户类型信息
        /// </summary>
        /// <param name="userTypeID">用户类型号</param>
        /// <returns></returns>
        public int DeleteUserType(string AreaCode)
        {
            //DbCommand dbCommand = db.GetStoredProcCommand("DeleteUserType");
            //db.AddInParameter(dbCommand, "@UserTypeID", DbType.Int32, userTypeID);
            //return db.ExecuteNonQuery(dbCommand);
            string strSQL = string.Format(SQL_DEL_AREA, AreaCode);
            return db.ExecuteNonQuery(CommandType.Text, strSQL);
        }
        /// <summary>
        /// 添加用户类型信息
        /// </summary>
        /// <param name="userTypeName">用户类型名</param>
        /// <returns></returns>
        public int AddUserTypeAndGetUserTypeID(TableDefine.UserTypeDefine userTypeDefine,string userTypeName,string remark)
        {
            //string queryTypeNameInfo = string.Format("TypeName = '{0}'", userTypeName);
            ////DataRow[] rows = userTypeDefine.Tables["UserType"].Select(queryTypeNameInfo);
            ////if (rows.Length > 0)
            ////{
            ////    return 0;
            ////}
            ////if 
            ////{

            ////}
            ////else
            ////{
            ////if (GetMostUserType
            //DataTable userTypeDataSet = GetMostUserType();
            ////userTypeDataSet
            //DataRow[] rows = userTypeDataSet.Tables["UserType"].Select(queryTypeNameInfo);
            //if (rows.Length > 0)
            //{
            //    return 0;
            //}
            //else
            //{
            //    DataRow row = userTypeDefine.Tables["UserType"].NewRow();
            //    row["TypeName"] = userTypeName;
            //    row["Remark"] = remark;
            //    userTypeDefine.Tables["UserType"].Rows.Add(row);
            //    UpdateUserTypeTable(userTypeDefine);
            //    return GetUserTypeID(userTypeName);
            //}
            //}
            return 0;
        }
        /// <summary>
        /// 根据用户类型名得到用户类型号
        /// </summary>
        /// <param name="userTypeName">用户类型名</param>
        /// <returns>用户类型号</returns>
        private int GetUserTypeID(string userTypeName)
        {
            //DbCommand dbCommand = db.GetStoredProcCommand("GetUserTypeID");
            //db.AddInParameter(dbCommand, "@TypeName", DbType.String, userTypeName);
            //try
            //{
            //    int userTypeID = int.Parse(db.ExecuteScalar(dbCommand).ToString());
            //    return userTypeID;
            //}
            //catch
            //{
            //    return 0;
            //}
            return 0;
        }
    }
}