MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/BaseData/SlmBaseSpclLn.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 SlmBaseSpclLn : SaleBusinessMgt.BllBase.BaseBll 
    {
       public SlmBaseSpclLn(OpeBase ob)
            : base(ob)
        { 
            
        }

       private string query = " select * from slm_base_spcl_ln where  1= 1 {0}";
       private DataSet GetSlmBaseSpclLn(string sqlCondition)
       {
           string sqlStr = string.Format(query, sqlCondition);
           DataSet ds = base.ExecuteQuery(sqlStr);
           return ds;
       }


       public DataSet GetSlmBaseSpclLnAll()
       {
           return GetSlmBaseSpclLn("");
       }

       public DataSet GetSlmBaseSpclLnAllValid()
       {
           return GetSlmBaseSpclLn("  and validflag = '1' ");
       }

       public DataSet GetSlmBaseSpclLnBySpclLnNo(string SPCL_LN_NO)
       {
           return GetSlmBaseSpclLn(string.Format( "  and spcl_ln_no = '{0}' ",SPCL_LN_NO));
       }
    }
}