DAL/editable/tbUser.cs

（开头部分） 8KB

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;

namespace DAL
{
    /// <summary>
    /// 数据访问类 tbUser
    /// <summary>
    public partial class tbUser : DALHelper
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Model.tbUser model)
        {
            string strSql = "INSERT INTO tbUser(U_Account,U_Name, U_CardID, U_Photo, U_Pwd, U_Sex, U_Level, U_Title, U_Tel, U_Address, U_Remark, U_AddDate, H_Account) VALUES (@in_U_Account,@in_U_Name, @in_U_CardID, @in_U_Photo, @in_U_Pwd, @in_U_Sex, @in_U_Level, @in_U_Title, @in_U_Tel, @in_U_Address, @in_U_Remark, @in_U_AddDate, @in_H_Account)";
            IDbDataParameter[] parms = DBUtility.DbParameterCache.GetCachedParameterSet(dbHelper.ConnectionString, strSql);
            if (parms == null)
            {
                parms = new IDbDataParameter[]{
                    dbHelper.CreateDbParameter(PARM_U_ACCOUNT, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_NAME, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_CARDID, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_PHOTO, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_PWD, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_SEX, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_LEVEL, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_TITLE, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_TEL, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_ADDRESS, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_REMARK, DbType.AnsiString, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_U_ADDDATE, DbType.DateTime, ParameterDirection.Input),
                    dbHelper.CreateDbParameter(PARM_H_ACCOUNT, DbType.AnsiString, ParameterDirection.Input)};
                DBUtility.DbParameterCache.CacheParameterSet(dbHelper.ConnectionString, COMMAND_ADD, parms);
            }

            parms[0].Value = model.U_Account;
            parms[1].Value = model.U_Name;
            parms[2].Value = model.U_CardID;
            parms[3].Value = model.U_Photo;
            parms[4].Value = model.U_Pwd;
            parms[5].Value = model.U_Sex;
            parms[6].Value = model.U_Level;
            parms[7].Value = model.U_Title;
            parms[8].Value = model.U_Tel;
            parms[9].Value = model.U_Address;
            parms[10].Value = model.U_Remark;
            parms[11].Value = model.U_AddDate;
            parms[12].Value = model.H_Account;
            return dbHelper.ExecuteNonQuery(CommandType.Text, strSql, parms);
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public int Update(Model.tbUser model)
        {
后面还有 155 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。