App_Code/DAL/dalFeeInfo.cs

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

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

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

using ENTITY;

namespace DAL
{
    /*缴费信息业务逻辑层实现*/
    public class dalFeeInfo
    {
        /*待执行的sql语句*/
        public static string sql = "";

        /*添加缴费信息实现*/
        public static bool AddFeeInfo(ENTITY.FeeInfo feeInfo)
        {
            string sql = "insert into FeeInfo(userObj,moneyValue,payWayObj,startDate,endDate,businessPointObj,addTime) values(@userObj,@moneyValue,@payWayObj,@startDate,@endDate,@businessPointObj,@addTime)";
            /*构建sql参数*/
            SqlParameter[] parm = new SqlParameter[] {
             new SqlParameter("@userObj",SqlDbType.VarChar),
             new SqlParameter("@moneyValue",SqlDbType.Float),
             new SqlParameter("@payWayObj",SqlDbType.Int),
             new SqlParameter("@startDate",SqlDbType.DateTime),
             new SqlParameter("@endDate",SqlDbType.DateTime),
             new SqlParameter("@businessPointObj",SqlDbType.Int),
             new SqlParameter("@addTime",SqlDbType.VarChar)
            };
            /*给参数赋值*/
            parm[0].Value = feeInfo.userObj; //用户
            parm[1].Value = feeInfo.moneyValue; //缴费金额
            parm[2].Value = feeInfo.payWayObj; //交易方式
            parm[3].Value = feeInfo.startDate; //开始时间
            parm[4].Value = feeInfo.endDate; //到期时间
            parm[5].Value = feeInfo.businessPointObj; //缴费网点
            parm[6].Value = feeInfo.addTime; //交易时间

            /*执行sql进行添加*/
            return (DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false;
        }

        /*根据feeId获取某条缴费信息记录*/
        public static ENTITY.FeeInfo getSomeFeeInfo(int feeId)
        {
            /*构建查询sql*/
            string sql = "select * from FeeInfo where feeId=" + feeId;
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
            ENTITY.FeeInfo feeInfo = new ENTITY.FeeInfo();
            /*如果查询存在记录，就包装到对象中返回*/
            if (DataRead.Read())
            {
                feeInfo.feeId = Convert.ToInt32(DataRead["feeId"]);
                feeInfo.userObj = DataRead["userObj"].ToString();
                feeInfo.moneyValue = float.Parse(DataRead["moneyValue"].ToString());
                feeInfo.payWayObj = Convert.ToInt32(DataRead["payWayObj"]);
                feeInfo.startDate = Convert.ToDateTime(DataRead["startDate"].ToString());
                feeInfo.endDate = Convert.ToDateTime(DataRead["endDate"].ToString());