C# IList应用

最新推荐文章于 2024-08-09 08:02:10 发布

工业互联

最新推荐文章于 2024-08-09 08:02:10 发布

阅读量319

点赞数

分类专栏： C# 文章标签： c# string constructor sql interface class

本文链接：https://blog.csdn.net/yoyoch1/article/details/4308384

版权

C# 专栏收录该内容

98 篇文章 0 订阅

订阅专栏

------显示数据-----------------

IEnumerator sales = DAOFactory.getSalesDAOInstance().getSalesDetail().GetEnumerator();

        while (sales.MoveNext())
        {
            Sales ss = (Sales) sales.Current;
            Response.Write(ss.SalesOrderID.ToString() + "   | " + ss.SalesOrderDetailID.ToString() + "   | " + ss.CarrierTrackingNum + "   | " + ss.Qty.ToString() + "<br>");

        }

-----DAOFactory-----------------------------------

        public static SalesDAO getSalesDAOInstance()
        {
            return new SalesDAOImpl();
        }

----DAO----------------------------------

    public interface SalesDAO
    {
          IList<Sales> getSalesDetail();
    }
    /// <summary>
    /// Summary description for SalesDAO
    /// </summary>
    public class SalesDAOImpl:SalesDAO
    {
      public IList<Sales> getSalesDetail()
        {
            IList<Sales> salesDetail = new List<Sales>();
            string constr = string.Empty;
            string SQL = string.Empty;

            constr = ConfigurationManager.ConnectionStrings["SSISConnectionString2"].ToString();
            SQL =     "select top 20 SalesOrderID,SalesOrderDetailID,CarrierTrackingNumber,productID,OrderQty ";
            SQL +=   "from SalesOrderDetail0";
            SqlConnection conn = new SqlConnection(constr);

            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            SqlCommand cmmd = new SqlCommand(SQL, conn);
            SqlDataReader dr = cmmd.ExecuteReader();
            while (dr.Read())
            {

                Sales sd = new Sales();
                sd.SalesOrderID = int.Parse(dr["SalesOrderID"].ToString());
                sd.SalesOrderDetailID = int.Parse(dr["SalesOrderDetailID"].ToString());
                sd.CarrierTrackingNum = dr["CarrierTrackingNumber"].ToString();
                sd.Qty = int.Parse(dr["OrderQty"].ToString());
                salesDetail.Add(sd);
            }
            dr.Close();
            return salesDetail;
        }

-----实体VO:Sales----------------------------------

public class Sales
{

    private int _SalesOrderID;
    private int _SalesOrderDetailID;
    private string _CarrierTrackingNum;
    private int _productID;
    private int _Qty;

public Sales()
{
  //
  // TODO: Add constructor logic here
  //
}

    public int SalesOrderID
    {
        get {
            return _SalesOrderID;
        }

        set {
            _SalesOrderID = value;
        }
    }

    public int SalesOrderDetailID
    {
        get {
            return _SalesOrderDetailID;
        }
        set {
            _SalesOrderDetailID = value;
        }
    }

    public string CarrierTrackingNum
    {
        get {

            return _CarrierTrackingNum;
        }
        set {

            _CarrierTrackingNum = value;
        }
    }

    public int productID
    {
        get {
            return _productID;
        }
        set {
            _productID = value;
        }
      }

    public int Qty
    {
        get {
            return _Qty;
        }
        set {
            _Qty = value;
        }

    }