DAL/transfer.cs

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

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

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

namespace DAL
{
    /// <summary>
    ///transfer 的摘要说明
    /// </summary>
    public class transfer
    {
        public transfer()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }
        public void Add(tb_transfer model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into tb_transfer(");
            strSql.Append("perNum,state,time,reason,money");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + model.Pernum + "',");
            strSql.Append("'" + model.State + "',");
            strSql.Append("'" + model.Time + "',");
            strSql.Append("'" + model.Reason + "',");
            strSql.Append("'" + model.Money + "',");
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(tb_transfer model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update tb_transfer set ");
            strSql.Append("perNum='" + model.Pernum + "',");
            strSql.Append("state='" + model.State + "',");
            strSql.Append("time='" + model.Time + "',");
            strSql.Append("reason='" + model.Reason + "',");
            strSql.Append("money='" + model.Money + "',");

            strSql.Append(" where id=" + model.Id + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete tb_transfer ");