smsoperationtype.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 58 行

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 SMSOperationType
    {
        private Database db;
        public SMSOperationType()
        {
            db = DatabaseFactory.CreateDatabase("Connection String");
        }

        public DataTable GetSMSOperationType()
        {
            string strSql = "SELECT OperationTypeID, MainOperationCode, OperationTypeName FROM SMSOperationType WHERE(IsValid <> 0)";
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }

        public DataTable GetSMSParticulerType(string operationID)
        {
            string strSql = string.Format("SELECT ChildOperationID, ChildOperationCode, ChildOperationName FROM ChildOperationType "+
                "WHERE MainOperationID = '{0}' AND (IsValid <> 0)", operationID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
        /// <summary>
        /// 得到所有主业务类型
        /// </summary>
        /// <returns></returns>
        public DataTable GetMainOperationInfo()
        {
            String strSql = "SELECT MainOperationID, MainOperationCode, MainOperationName FROM " +
                "MainOperationType WHERE (IsValid <> 0)";
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
        /// <summary>
        /// 得到所有子业务类型
        /// </summary>
        /// <param name="mainOperationID"></param>
        /// <returns></returns>
        public DataTable GetChildOperationInfo(int mainOperationID)
        {
            String strSql = string.Format("SELECT ChildOperationID, ChildOperationCode, " +
                "ChildOperationName, MainOperationID FROM ChildOperationType WHERE " +
                "(IsValid <> 0) AND (MainOperationID = {0})", mainOperationID);
            DataSet ds = db.ExecuteDataSet(CommandType.Text, strSql);
            return ds.Tables[0];
        }
    }
}