DataFramework/Auto/SupplyDAL.cs

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

using System;
using System.Data;
using System.Collections.Generic;
using System.Text;
using NLKIRADAL;
using NLKIRADBCommon;
using Model;

namespace DAL
{
	public partial class SupplyDAL : DALBase
	{
		public SupplyDAL(DataBase dataBase, IDbCommand command)
		{
			base.dataBase = dataBase;
			base.command = command;
		}

		public SupplyInfo GetSupplyInfo()
		{
			SupplyInfo supplyInfo = null;
			using (IDataReader rdr = dataBase.ExecuteReader(command))
			{
				if (rdr.Read())
				{
                    supplyInfo = new SupplyInfo(
							(rdr.IsDBNull(0)) ? null : Convert.ToString(rdr[0]),
							(rdr.IsDBNull(1)) ? null : Convert.ToString(rdr[1]),
							(rdr.IsDBNull(2)) ? null : Convert.ToString(rdr[2]),
							(rdr.IsDBNull(3)) ? null : Convert.ToString(rdr[3]));
				}
			}
            return supplyInfo;
		}

		public List<SupplyInfo> GetSupplyInfos()
		{
			List<SupplyInfo> supplyInfos = new List<SupplyInfo>();
            SupplyInfo supplyInfo;
			using (IDataReader rdr = dataBase.ExecuteReader(command))
			{
				while (rdr.Read())
				{
                    supplyInfo = new SupplyInfo(
							(rdr.IsDBNull(0)) ? null : Convert.ToString(rdr[0]),
							(rdr.IsDBNull(1)) ? null : Convert.ToString(rdr[1]),
							(rdr.IsDBNull(2)) ? null : Convert.ToString(rdr[2]),
							(rdr.IsDBNull(3)) ? null : Convert.ToString(rdr[3]));
                    supplyInfos.Add(supplyInfo);
				}
			}
            return supplyInfos;
		}
	}
}