LindonSoft.Amico.BULayer/Buy/T_WholeSetManager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/******************************************************************
** Copyright (c) 2005 -2007 灵动软件研发部
** 创建人:
** 创建日期:
** 修改人:
** 修改日期:
** 描 述: 
** 版 本:1.0
**----------------------------------------------------------------------------
******************************************************************/

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace LindonSoft.Amico.BULayer
{
	using LindonSoft.Amico.BULayer.Data;
	using LindonSoft.Amico.BULayer.Schema;
	using LindonSoft.SubstrateLayer.BULayer;
	using LindonSoft.SubstrateLayer.DALayer;
	using LindonSoft.Common.BULayer;
	
	[Serializable()]
	public class T_WholeSetManager : T_WholeSetData
	{
		public DataSet Search(T_WholeSetQuery QueryData)
		{
            string paramSql = "SELECT * FROM " + T_WholeSet.TABLENAME + " WHERE 1=1 ";
            Hashtable ht = new Hashtable();
            DataSet _Ds = new DataSet();
            if (QueryData.FullName.Trim().Length > 0)
            {
                paramSql += " AND " + T_WholeSet.FULLNAME + " LIKE @FULLNAME ";
                ht.Add("@FULLNAME", "%" + QueryData.FullName.Trim() + "%");
            }
            if (QueryData.Code.Trim().Length > 0)
            {
                paramSql += " AND " + T_WholeSet.CODE + "  LIKE @CODE";
                ht.Add("@CODE", "%" + QueryData.Code.Trim() + "%");
            }
            if (QueryData.Type.Trim().Length > 0)
            {
                paramSql += " AND " + T_WholeSet.TYPE + "=@TYPE";
                ht.Add("@TYPE", "%" + QueryData.Type.Trim() + "%");
            }
            BaseDBCon con = new BaseDBCon();
            try
            {
                con.Open();
                con.Fill(paramSql, _Ds, T_WholeSet.TABLENAME, ht);
            }
            catch (Exception err)
            {
                throw err;
            }
            finally
            {