App_Code/EntityDA/MemberInfoDA.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Text;

/// <summary>
/// MemberInfoDA 的摘要说明
/// </summary>
public class MemberInfoDA
{
    //定义常量表示字段名称或SQL语句。
    private const string SQL_INSERT_MEMBERINFO = "INSERT INTO memberinfo VALUES(@cardid, @cardnum, @custname, @custidentity, @custphone, @custaddress,@carddate)";
    private const string SQL_UPDATE_MEMBERINFO = "update memberinfo set custname=@custname,custphone=@custphone,custaddress=@custaddress";
    private const string PARM_CARD_ID = "@cardid";
    private const string PARM_CUST_PHONE = "@custphone";
    private const string PARM_CARD_NUM = "@cardnum";
    private const string PARM_CUST_ADDRESS = "@custaddress";
    private const string PARM_CARD_DATE= "@carddate";
    private const string PARM_CUST_IDENTITY = "@custidentity";
    private const string PARM_CUST_NAME = "@custname";
    private const string SQL_SELECT_BYCARDNUM = "SELECT memberinfo.cardnum,memberinfo.custname,memberinfo.custidentity,memberinfo.custphone,memberinfo.custaddress,memberinfo.carddate, cardtype.cardtypename,cardtype.cardid FROM memberinfo INNER JOIN cardtype ON memberinfo.cardid=cardtype.cardid WHERE memberinfo.cardnum=@cardnum";
    private const string SQL_SELECT_BYCUSTIDENTITY = "SELECT memberinfo.cardnum,memberinfo.custname,memberinfo.custidentity,memberinfo.custphone,memberinfo.custaddress,memberinfo.carddate, cardtype.cardtypename,cardtype.cardid FROM memberinfo INNER JOIN cardtype ON memberinfo.cardid=cardtype.cardid WHERE memberinfo.custidentity=@custidentity";
    private const string SQL_SELECT_BYCUSTNAME = "SELECT memberinfo.cardnum,memberinfo.custname,memberinfo.custidentity,memberinfo.custphone,memberinfo.custaddress,memberinfo.carddate, cardtype.cardtypename ,cardtype.cardid FROM memberinfo INNER JOIN cardtype ON memberinfo.cardid=cardtype.cardid WHERE memberinfo.custname=@custname";

    /// <summary>
    /// 通过会员卡号查询会员资料
    /// </summary>
    /// <param name="cardnum">会员卡号</param>
    /// <returns>会员信息实体</returns>
    public MemberInfoEntity GetMemberInfoByCardNum(string cardnum)
    {
        //初始化返回的变量
        MemberInfoEntity memberinfo = null;
        //初始化输入参数并赋值
        SqlParameter parm = new SqlParameter(PARM_CARD_NUM, SqlDbType.NVarChar, 20);
        parm.Value = cardnum;
        //使用DataReader来保存返回的数据
        using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_BYCARDNUM, parm))
        {
            //如果数据有多条，循环读取
            while (rdr.Read())
            {
                //给会员信息实体依次赋值，顺序要与会员信息实体的构造参数一样
                memberinfo = new MemberInfoEntity(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetDateTime(5), rdr.GetInt32(7));
            }
        }
        //返回会员信息实体
        return memberinfo;
    }

    /// <summary>
    /// 通过身份证号查询会员资料
    /// </summary>
    /// <param name="cardnum">会员身份证号</param>
    /// <returns>会员信息实体</returns>
    public MemberInfoEntity GetMemberInfoByCustIdentity(string custidentity)
    {
        //初始化会员实体
        MemberInfoEntity memberinfo = null;