useroperation.cs

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

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


namespace DataAccess.TableAccessor
{
    public class UserOperation
    {
        private Database db = null;
        private const string SQL_ADD_USEROPERATION = "INSERT INTO UserOperation (UserID,MainOperationID,ChildOperationID) " +
            "VALUES ({0}, '{1}', '{2}')";
        private const string SQL_VIEW_SIMPMAN_USEROPERATION = "SELECT UserOperation.UserID, MainOperationType.MainOperationName, "+
            "ChildOperationType.ChildOperationName, MainOperationType.MainOperationID, ChildOperationType.ChildOperationID FROM UserOperation "+
            "INNER JOIN MainOperationType ON UserOperation.MainOperationID = MainOperationType.MainOperationID INNER JOIN "+
            "ChildOperationType ON UserOperation.ChildOperationID = ChildOperationType.ChildOperationID WHERE UserOperation.UserID = '{0}' AND UserOperation.IsValid <> 0";

        private const string SQL_DEL_USEROPERATION = "UPDATE UserOperation SET IsValid = 0 WHERE UserID = {0} AND " +
            "MainOperationID = {1} AND ChildOperationID = {2}";
        private const string SQL_DELUSEROPERATION = "UPDATE UserOperation SET IsValid = 0 WHERE UserID = {0}";
        private const string SQL_UPDATE_USEROPERATION = "UPDATE UserOperation SET Mobile = {0} WHERE Mobile = {1}";
        private const string SQL_MAINOPERATION = "SELECT MainOperationID, MainOperationCode, MainOperationName FROM MainOperationType";
        private const string SQL_CHILDOPERAION = "SELECT ChildOperationID, ChildOperationCode, ChildOperationName FROM ChildOperationType "+
            "WHERE MainOperationID = {0}";

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

        public int AddUserOperation(int userID, int mainOperaionID, int childOperationID)
        {
            string strSQL = string.Format(SQL_ADD_USEROPERATION, userID, mainOperaionID, childOperationID);
            try
            {
                return db.ExecuteNonQuery(CommandType.Text, strSQL);
            }
            catch
            {
                return 0;
            }
        }

        public int UpdateUserOperation(int newmobile, int oldmobile)
        {
            string strSQL = string.Format(SQL_UPDATE_USEROPERATION, newmobile, oldmobile);
            try
            {
                return db.ExecuteNonQuery(CommandType.Text, strSQL);
            }
            catch
            {
                return 0;
            }
        }

        public int DelUserOperation(int useID, int mainOperation, int childOperaion)
        {
            string strSQL = string.Format(SQL_DEL_USEROPERATION, useID, mainOperation, childOperaion);
            try
            {
                return db.ExecuteNonQuery(CommandType.Text, strSQL);
            }
            catch
            {
                return 0;
            }
        }

        public int DeluserOperation(int userID)
        {
            string strSql = string.Format(SQL_DELUSEROPERATION, userID);
            return db.ExecuteNonQuery(CommandType.Text, strSql);
        }

        public DataTable GetSimpMan(int userID)
        {
            string strSQL = string.Format(SQL_VIEW_SIMPMAN_USEROPERATION, userID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSQL);
            return ds.Tables[0];
        }

        public DataTable GetMainOperationInfo()
        {
            DataSet ds = db.ExecuteDataSet(CommandType.Text, SQL_MAINOPERATION);
            return ds.Tables[0];
        }

        public DataTable GetChildOperation(int mainOpeationID)
        {
            string strSql = string.Format(SQL_CHILDOPERAION, mainOpeationID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
    }
}