DAL/Admin/GZXX_UserTable.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using DBUtility;

namespace DAL.Admin
{
    public class GZXX_UserTable
    {
        public bool Exist(string Title)
        {
            SqlParameter[] p = new SqlParameter[] {
                                new SqlParameter("@Title",SqlDbType.NVarChar)
                            };
            p[0].Value = Title;

            string sql = "select count(*) from [UserTable] where LoginName =@Title";
            return DBUtility.DbHelperSQL.Exists(sql, p);
        }

        public int ReturnInfoID(string Title)
        {
            SqlParameter[] p = new SqlParameter[] {
                                new SqlParameter("@Title",SqlDbType.NVarChar)
                            };
            p[0].Value = Title;

            string sql = "select InfoID from [UserTable] where LoginName =@Title";
            object infoid = DBUtility.DbHelperSQL.GetSingle(sql, p);
            if (infoid != null) { return int.Parse(infoid.ToString()); }
            else { return 0; }
        }

        public bool SaveMoney(decimal usermoney,int infoid) 
        {
            SqlParameter[] p = new SqlParameter[] {
                                new SqlParameter("@UserMoney",SqlDbType.NVarChar),
                                new SqlParameter("@InfoID",SqlDbType.Int)
                            };
            p[0].Value = usermoney;
            p[1].Value = infoid;
            string sql = "update [UserTable] set UserMoney = IsNULL(UserMoney,0) + @UserMoney where InfoID = @InfoID";
            if (DBUtility.DbHelperSQL.ExecuteSql(sql, p) > 0)
            {
                return true;
            }
            else { return false; }
        }
    }
}