NewGCSSDAL/Users/CardManage/CardServices.cs

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

/*------------------------------------------------------------------------
//
// Copyright (C) 2008 宜昌斯瑞北大青鸟T56班
//版权所有。
//
// 文件名：CardServices.cs
//
//文件功能描述：Card相关的数据访问层
// 
// 创建标识：冯玲
// 创建时间：2008.10.28
// 
// 修改标识：
// 修改描述：
// 
------------------------------------------------------------------------*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using NewGCSS.Models;

namespace NewGCSS.DAL.Users.CardManage
{
   public class CardServices
    {
       /// <summary>
       /// 综合信息中的购物记录
       /// </summary>
       /// <returns></returns>
       public List<Card> GetAllCard()
       {
           int CardTypeId;
           int CardPrice;
           List<Card> list = new List<Card>();
           string sql = "select * from Card";
           SqlDataReader reader = SqlHelper.ExecuteReader(sql);
           CardTypeService card = new CardTypeService();
           while (reader.Read())
           {
               Card model = new Card();
               
               model.CardId = (int)reader["CardId"];
               CardTypeId = (int)reader["CardTypeId"];
               model.Types = card.GetCardTypeNameByCardTypeId(CardTypeId);
               CardPrice = (int)reader["CardTypeId"];
               model.CardPrice = card.GetCardTypeNameByCardTypeId(CardTypeId);
               model.CardNo=reader["CardNo"].ToString();
               model.CardPassword = (int)reader["CardPassword"];
               model.CardTime =DateTime.Parse(reader["CardTime"].ToString());
               list.Add(model);
           }
           reader.Close();
           return list;
       }
    }
}