App_Code/CardCountInfo.cs

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

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

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

/// <summary>
/// CardCountInfo 的摘要说明
/// </summary>
public class CardCountInfo
{
    private int _cardcount;
    private const string PARM_CARD_NUM = "@cardnum";
    private const string SQL_SELECT_CARDCOUNT = "SELECT ISNULL(SUM(Point),0) AS CardCount FROM CardHistory  WHERE CardNum=@cardnum";

    private const string PARM_CARD_POINT = "@point";
    private const string PARM_OPERATION_TYPE = "@mark";
    private const string PARM_HANDLE_DATE = "@handledate";
    private const string SQL_INSERT_CARDHISTORY = "INSERT INTO CardHistory VALUES(@cardnum,@mark,@point,@handledate)";
    private const string SQL_SELECT_CARDRULE = "SELECT cardtype.cardrule FROM memberinfo INNER JOIN cardtype on cardtype.cardid=memberinfo.cardid WHERE  cardnum=@cardnum";

    private const string SQL_SELECT_HISTORY = "SELECT ConsumeID,CardNum,Point,HandleDate, CASE Mark WHEN 0 THEN '销售' WHEN 1 THEN '退货' WHEN 2 THEN '反馈' END AS operationtype FROM cardhistory WHERE CardNum=@cardnum";

    public CardCountInfo()
	{
	}
    /// <summary>
    /// 根据卡号查询卡积分
    /// </summary>
    /// <param name="cardnum">卡号</param>
    /// <returns>总积分</returns>
    public int GetCountByCardNum(string cardnum)
    {
        //初始化输入参数并赋值
        SqlParameter parm = new SqlParameter(PARM_CARD_NUM, SqlDbType.NVarChar, 20);
        parm.Value = cardnum;
        
        //调用SqlHelper访问组件的方法返回第一行第一列的值
        string tempstr=SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CARDCOUNT, parm).ToString();
        //为了转换不发生错误，可以先把取出的值从object转到string,再转到int.
        _cardcount = int.Parse(tempstr);
        //返回总积分
        return _cardcount;
    }
    /// <summary>
    /// 积分处理方法，添加历史记录
    /// </summary>
    /// <param name="cardnum">会员卡号</param>
    /// <param name="money">金额（只允许输入整数，因为只有整数才能积分）</param>
    /// <param name="operationtype">操作类型（0-销售，1-退货，2-反馈）</param>
    /// <returns>操作是否成功</returns>
    public bool AddHistory(string cardnum,int money,int operationtype)
    {
        //首先获取该卡号对应的积分规则。
        //初始化输入参数并赋值
        SqlParameter parm1 = new SqlParameter(PARM_CARD_NUM, SqlDbType.NVarChar, 20);
        parm1.Value = cardnum;

        //调用SqlHelper访问组件的方法返回第一行第一列的值-积分规则
        string tempstr = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CARDRULE, parm1).ToString();