App_Code/DAL/dalPayWay.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 dalPayWay
    {
        /*待执行的sql语句*/
        public static string sql = "";

        /*添加交易方式实现*/
        public static bool AddPayWay(ENTITY.PayWay payWay)
        {
            string sql = "insert into PayWay(payWayName) values(@payWayName)";
            /*构建sql参数*/
            SqlParameter[] parm = new SqlParameter[] {
             new SqlParameter("@payWayName",SqlDbType.VarChar)
            };
            /*给参数赋值*/
            parm[0].Value = payWay.payWayName; //交易方式名称

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

        /*根据payWayId获取某条交易方式记录*/
        public static ENTITY.PayWay getSomePayWay(int payWayId)
        {
            /*构建查询sql*/
            string sql = "select * from PayWay where payWayId=" + payWayId;
            SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
            ENTITY.PayWay payWay = new ENTITY.PayWay();
            /*如果查询存在记录，就包装到对象中返回*/
            if (DataRead.Read())
            {
                payWay.payWayId = Convert.ToInt32(DataRead["payWayId"]);
                payWay.payWayName = DataRead["payWayName"].ToString();
            }
            return payWay;
        }

        /*更新交易方式实现*/
        public static bool EditPayWay(ENTITY.PayWay payWay)
        {
            string sql = "update PayWay set payWayName=@payWayName where payWayId=@payWayId";
            /*构建sql参数信息*/
            SqlParameter[] parm = new SqlParameter[] {
             new SqlParameter("@payWayName",SqlDbType.VarChar),
             new SqlParameter("@payWayId",SqlDbType.Int)
            };
            /*为参数赋值*/
            parm[0].Value = payWay.payWayName;
            parm[1].Value = payWay.payWayId;