DAL/CardInfodal.cs

（完整代码） 1KB 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class CardInfodal
    {
        /// <summary>
        /// 登陆
        /// </summary>
        /// <param name="id">卡号</param>
        /// <param name="pwd">密码</param>
        /// <returns></returns>
        public static DataSet GetCardinfo(long id,string pwd)
        {
            string sql =string.Format("select * from CardInfo where CardId={0} and CardPwd='{1}'",id,pwd);
            return DBHelper.GetSet(sql);
        }
        /// <summary>
        /// 查询是否有此ID
        /// </summary>
        /// <param name="id">转账人ID</param>
        /// <returns></returns>
        public static object GetCardinfo(long id)
        {
            string sql = string.Format("select count(*) from Cardinfo where CardId={0}",id);
            return DBHelper.GetOnly(sql);
        }
        /// <summary>
        /// 记录
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static DataSet GetNotes(string name)
        {
            string sql = string.Format("select * from Notes where showName='{0}' order by Id desc", name);
            return DBHelper.GetSet(sql);
        }
        /// <summary>
        /// 执行存储过程
        /// </summary>
        /// <param name="name">显示源</param>
        /// <param name="money">取出金额</param>
        /// <returns>true/false</returns>
        public static bool GetMoney(string procname, object [] obj)
        {
            return DBHelper.UpdateData(procname, obj);
        }
    }
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。