App_Code/EntityDA/CardTypeDA.cs

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

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

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

/// <summary>
/// CardTypeDA 是专门用于访问CardTypeEntity的方法
/// </summary>
public class CardTypeDA
{
    //常量用来表示T-SQL语句中用到的变量名称和T-SQL语句本身
    private const string PARM_CARD_TYPENAME = "@cardtypename";
    private const string PARM_CARD_RULE = "@cardrule";
    private const string PARM_CARD_ID = "@cardid";
    private const string SQL_SELECT_CARDRULE = "SELECT cardrule FROM cardtype WHERE cardtypename=@cardtypename";
    private const string SQL_UPDATE_CARDTYPENAME = "UPDATE cardtype SET cardtypename=@cardtypename WHERE cardtypename=@oldname";
    private const string SQL_UPDATE_CARDRULE = "UPDATE cardtype SET cardrule=@cardrule WHERE cardtypename=@cardtypename";
    private const string SQL_INSERT_CARDTYPE = "INSERT INTO cardtype VALUES(@cardtypename,@cardrule)";
    private const string SQL_SELECT_CARDNAME = "SELECT cardtypename FROM cardtype WHERE cardtypename=@cardtypename";
    private const string SQL_SELECT_CARDID = "SELECT cardid FROM cardtype WHERE cardtypename=@cardtypename";

    /// <summary>
    /// 通过会员卡类型名称更新积分规则
    /// </summary>
    /// <param name="cardtypename">会员卡类型名称</param>
    /// <returns>积分规则</returns>
    public int GetCardRule(string cardtypename)
    {
        int cardrule=0;
        
        //创建新参数并给参数赋值，用来指定会员卡类型名称
        SqlParameter parm = new SqlParameter(PARM_CARD_TYPENAME, SqlDbType.NVarChar, 20);
        parm.Value = cardtypename;

        //调用SqlHelper访问组件的方法返回第一行第一列的值
        cardrule = (int)  SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CARDRULE, parm);
        
        return cardrule;
    }

    /// <summary>
    /// 更新卡积分规则
    /// </summary>
    /// <param name="cardtypename">卡类型名称</param>
    /// <param name="newrule">更新后的积分规则</param>
    /// <returns>更新是否成功</returns>
    public bool UpdateCardRule(CardTypeEntity mycarden)
    {
        //获取参数列表
        SqlParameter[] cardParms = GetParameters();

        // 给参数赋值
        cardParms[0].Value = mycarden.CardTypeName;
        cardParms[1].Value = mycarden.CardRule;

        //使用StringBuilder来连接字符串
        StringBuilder strSQL = new StringBuilder();
        SqlCommand cmd = new SqlCommand();

        //遍历参数列表并将参数添加到SqlCommand命令中