MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/BaseData/SlmBaseStation.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
using System.Collections;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData
{
    public class SlmBaseStation : SaleBusinessMgt.BllBase.BaseBll 
    {
        public SlmBaseStation(OpeBase ob)
            : base(ob)
        { 
            
        }
        private string query = " select * from Slm_Base_Station where  1= 1 {0}";

        private DataSet GetSlmBaseStation(string sqlCondition)
        {
            string sqlStr = string.Format(query, sqlCondition);
            DataSet ds = base.ExecuteQuery(sqlStr);
            return ds;
        }

        public DataSet GetSlmBaseStationAll()
        {
            return GetSlmBaseStation("");
        }

        public DataSet GetSlmBaseStationAllValid()
        {
            return GetSlmBaseStation("  and validflag = '1' ");
        }

        public DataSet GetSlmBaseStationByStationNo(string StationNo)
        {
            return GetSlmBaseStation(string.Format("  and Station_No = '{0}' ", StationNo));
        }

    }
}