MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/BaseData/ComBaseInfoBll.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 ComBaseInfoBll : SaleBusinessMgt.BllBase.BaseBll 
    {
        private string QUERY_COMBASEINFO = @" select *
                                                                                 from com_base_info a  where 1 = 1 {0}
                                                                             ";
        private DataSet GetComBaseInfo(string sqlCondition)
        {
            string sqlStr = string.Format(QUERY_COMBASEINFO,sqlCondition);
            DataSet ds = base.ExecuteQuery(sqlStr);
            return ds;
        }



        public ComBaseInfoBll(OpeBase ob)
            : base(ob)
        { 
        }

        public  DataSet GetComBaseInfoByBaseCode(string baseCode)
        {
            string sqlCondition = string.Format("  and basecode = '{0}' ",baseCode);
            return GetComBaseInfo(sqlCondition);
        }

        public DataSet GetComBaseInfo()
        {
            return GetComBaseInfo("");
        }

        public DataSet GetComBaseInfoBySortCode(string sortCode)
        {
            string sqlCondition = string.Format("  and sortcode = '{0}' ", sortCode);
            return GetComBaseInfo(sqlCondition);
        }

    }
}