DataFramework/Auto/ProductSellDAL.cs

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

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

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

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

		public ProductSellInfo GetProductSellInfo()
		{
			ProductSellInfo productSellInfo = null;
			using (IDataReader rdr = dataBase.ExecuteReader(command))
			{
				if (rdr.Read())
				{
                    productSellInfo = new ProductSellInfo(
                            (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]),
                            (rdr.IsDBNull(4)) ? null : Convert.ToString(rdr[4]),
                            (rdr.IsDBNull(5)) ? null : Convert.ToString(rdr[5]),
                            (rdr.IsDBNull(6)) ? null : Convert.ToString(rdr[6]),
                            (rdr.IsDBNull(7)) ? null : Convert.ToString(rdr[7]),
                            (rdr.IsDBNull(8)) ? null : Convert.ToString(rdr[8]),
                            (rdr.IsDBNull(9)) ? null : Convert.ToString(rdr[9]));
				}
			}
            return productSellInfo;
		}

		public List<ProductSellInfo> GetProductSellInfos()
		{
			List<ProductSellInfo> productSellInfos = new List<ProductSellInfo>();
            ProductSellInfo productSellInfo;
			using (IDataReader rdr = dataBase.ExecuteReader(command))
			{
				while (rdr.Read())
				{
                    productSellInfo = new ProductSellInfo(
                            (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]),
                            (rdr.IsDBNull(4)) ? null : Convert.ToString(rdr[4]),
                            (rdr.IsDBNull(5)) ? null : Convert.ToString(rdr[5]),
                            (rdr.IsDBNull(6)) ? null : Convert.ToString(rdr[6]),
                            (rdr.IsDBNull(7)) ? null : Convert.ToString(rdr[7]),
                            (rdr.IsDBNull(8)) ? null : Convert.ToString(rdr[8]),
                            (rdr.IsDBNull(9)) ? null : Convert.ToString(rdr[9]));