usertypekey.cs

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

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

namespace DataAccess.TableAccessor
{
    public class UserTypeKey
    {
        private Database db = null;

        public UserTypeKey()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        public int UpdateUserTypeKeyDataSet(TableDefine.UserTypeKeyDefine userTypeKeyDataSet)
        {
            DbCommand insertCommand = db.GetStoredProcCommand("AddUserTypeKey");
            db.AddInParameter(insertCommand,"@UserTypeID",DbType.Int32,"UserTypeID",DataRowVersion.Current);
            db.AddInParameter(insertCommand,"@ColumnChineseName",DbType.String,"ColumnChineseName",DataRowVersion.Current);
            db.AddInParameter(insertCommand,"@DataBaseColumnName",DbType.String,"DataBaseColumnName",DataRowVersion.Current);

            DbCommand deleteCommand = db.GetStoredProcCommand("DeleteUserTypeKey");
            db.AddInParameter(deleteCommand, "@UserTypeKeyID", DbType.Int32, "PK_ID", DataRowVersion.Current);

            DbCommand updateCommand = db.GetStoredProcCommand("UpdateUserTypeKey");
            db.AddInParameter(updateCommand,"@UserTypeKeyID",DbType.Int32,"PK_ID",DataRowVersion.Current);
            db.AddInParameter(updateCommand,"@UserTypeID",DbType.Int32,"UserTypeID",DataRowVersion.Current);
            db.AddInParameter(updateCommand,"@ColumnChineseName",DbType.String,"ColumnChineseName",DataRowVersion.Current);
            db.AddInParameter(updateCommand,"@DataBaseColumnName",DbType.String,"DataBaseColumnName",DataRowVersion.Current);

            int rowsAffected = db.UpdateDataSet(userTypeKeyDataSet, "UserTypeKey", insertCommand,
                updateCommand, deleteCommand, UpdateBehavior.Standard);
            return rowsAffected;
        }
        /// <summary>
        /// 添加用户类型需要字段
        /// </summary>
        /// <param name="userTypeKeyDataSet"></param>
        /// <param name="userTypeID"></param>
        /// <param name="columnName"></param>
        /// <param name="chineseName"></param>
        public void AddUserTypeKey(TableDefine.UserTypeKeyDefine userTypeKeyDataSet, int userTypeID,
            string columnName, string chineseName)
        {
            DataRow row = userTypeKeyDataSet.Tables[0].NewRow();
            row["UserTypeID"] = userTypeID;
            row["DataBaseColumnName"] = columnName;
            row["ColumnChineseName"] = chineseName;

            userTypeKeyDataSet.Tables[0].Rows.Add(row);
        }

        public TableDefine.UserTypeKeyDefine GetMostUserTypeKey()
        {
            //DataSet ds = db.ExecuteDataSet(CommandType.StoredProcedure, "GetMostUserTypeKey");
            TableDefine.UserTypeKeyDefine userTypeKeyDataSet = new DataAccess.TableDefine.UserTypeKeyDefine();
            db.LoadDataSet(CommandType.StoredProcedure, "GetMostUserTypeKey", userTypeKeyDataSet, new string[] {"UserTypeKey"});
            return userTypeKeyDataSet;
            //return userTypeKeyDataSet;
            
        }
        /// <summary>
        /// 根据用户类型编号筛选用户需要的类型字段
        /// </summary>
        /// <param name="userTypeKeyDataSet"></param>
        /// <param name="userTypeID"></param>
        /// <returns></returns>
        public DataRow[] FilterUserTypeKeyByID(TableDefine.UserTypeKeyDefine userTypeKeyDataSet,int userTypeID)
        {
            string filterStr = string.Format("UserTypeID = {0}",userTypeID);
            DataRow[] rows = userTypeKeyDataSet.Tables["UserTypeKey"].Select(filterStr);
            return rows;
        }
    }
}