SSWMS_2230395/SSWMS.Server/Persistence/P_House/P_IO_CONTROL_ROUTE.cs

using SSWMS.Common;
using System;
using System.Collections;
using System.Collections.Generic;

namespace SSWMS.Server
{
    public class P_IO_CONTROL_ROUTE : P_Base_House<IO_CONTROL_ROUTE>
    {
        public IO_CONTROL_ROUTE GetModelByDeviceCode(string sStartDeviceCode, string sEndDeviceCode)
        {
            return this._sqlMap.QueryForObject<IO_CONTROL_ROUTE>("IO_CONTROL_ROUTE_SELECT_BY_DEVICE_CODE", new Hashtable()
            {
                { "START_DEVICE", sStartDeviceCode },
                { "END_DEVICE", sEndDeviceCode },
                { "CONTROL_ROUTE_STATUS", Convert.ToInt32(SystemCode.FLAG.Enable) },
                { "CONTROL_ROUTE_FLAG", SystemCode.FLAG.Enable }
            });
        }

        public IO_CONTROL_ROUTE GetModelByDeviceCode_L(string sStartDeviceCode, string sEndDeviceCode)
        {
            return this._sqlMap.QueryForObject<IO_CONTROL_ROUTE>("IO_CONTROL_ROUTE_SELECT_BY_DEVICE_CODE_L", new Hashtable()
            {
                { "START_DEVICE", sStartDeviceCode },
                { "END_DEVICE", sEndDeviceCode },
                { "CONTROL_ROUTE_FLAG", SystemCode.FLAG.Enable }
            });
        }

        public IList<IO_CONTROL_ROUTE> GetListByStartDeviceCode(int iControlRouteType, string sStartDeviceCode)
        {
            return this._sqlMap.QueryForList<IO_CONTROL_ROUTE>("IO_CONTROL_ROUTE_SELECT_BY_START_DEVICE_CODE", new Hashtable()
            {
                { "CONTROL_ROUTE_TYPE", iControlRouteType },
                { "START_DEVICE", sStartDeviceCode },
                { "CONTROL_ROUTE_FLAG", SystemCode.FLAG.Enable }
            });
        }

        public IList<IO_CONTROL_ROUTE> GetListByEndDeviceCode(int iControlRouteType, string sEndDeviceCode)
        {
            return this._sqlMap.QueryForList<IO_CONTROL_ROUTE>("IO_CONTROL_ROUTE_SELECT_BY_END_DEVICE_CODE", new Hashtable()
            {
                { "CONTROL_ROUTE_TYPE", iControlRouteType },
                { "END_DEVICE", sEndDeviceCode },
                { "CONTROL_ROUTE_FLAG", SystemCode.FLAG.Enable }
            });
        }
    }
}