RentHouseDAL/TopupService.cs

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

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

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

namespace RentHouseDAL
{
    public static class TopupService
    {
        public static void AddTopup(Topup t)
        {
            string sql = "insert into Topups values(@UserName,@Amount,@TopupDate)";
            SqlParameter[] para = new SqlParameter[] { 
                new SqlParameter("@UserName",t.UserName),
                new SqlParameter("@Amount",t.Amount),
                new SqlParameter("@TopupDate",t.TopupDate)
            };
            DBHelper.ExecuteCommand(sql,CommandType.Text,para);
        }

        public static int GetTotalByYear(string year)
        {
            string sql = "select SUM(Amount) from Topups where TopupDate like '" + year + "%'";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }

        public static int GetTotalByYearMonth(string year,int month)
        {
            string sql = "select SUM(Amount) from Topups where TopupDate like '"+year+"/" + month.ToString().Trim() + "/%'";
            object obj= DBHelper.GetScalar(sql, CommandType.Text, null);
            if (obj.Equals(System.DBNull.Value))//当obj类型为DBNull时不能转换
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }          
        }

        public static DataTable GetAllYears()
        {
            string sql = "select distinct SUBSTRING(TopupDate,0,5) as Year from Topups";
            return DBHelper.GetTable(sql,CommandType.Text,null);
        }


        public static int GetAllTotal()
        {
            string sql = "select SUM(Amount) from Topups ";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }

        public static int GetTotalByUserName(string username)
        {
            string sql = "select SUM(Amount) from Topups where UserName=@UserName ";
            SqlParameter[] para = new SqlParameter[] {