BBSDAL/X_UserInfoService.cs

(开头部分) 11KB

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

using System;
using System.Data;
using System.Data.SqlClient;
using BaseDBUtility;

namespace BBS.DAL
{
    public class X_UserInfoService
    {
        /// <summary>
        ///  增加一条数据
        /// </summary>
        public static int Add(Model.X_UserInfo model)
        {
            int rowsAffected;
            SqlParameter[] parameters = {
					new SqlParameter("@UserId", SqlDbType.Int,4),
					new SqlParameter("@UserName", SqlDbType.VarChar,500),
					new SqlParameter("@PassWord", SqlDbType.VarChar,500),
					new SqlParameter("@Phone", SqlDbType.VarChar,500),
					new SqlParameter("@Mobile", SqlDbType.VarChar,500),
					new SqlParameter("@Sex", SqlDbType.VarChar,50),
					new SqlParameter("@Address", SqlDbType.VarChar,500),
					new SqlParameter("@EntryTime", SqlDbType.DateTime),
					new SqlParameter("@DepartId", SqlDbType.Int,4),
					new SqlParameter("@Depart", SqlDbType.VarChar,50),
					new SqlParameter("@AgentId", SqlDbType.Int,4),
					new SqlParameter("@Agent", SqlDbType.VarChar,50),
					new SqlParameter("@Notes", SqlDbType.NText),
					new SqlParameter("@Email", SqlDbType.VarChar,100),
					new SqlParameter("@InJob", SqlDbType.Bit,1),
					new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
					new SqlParameter("@LastLoginIP", SqlDbType.VarChar,50),
					new SqlParameter("@Photo", SqlDbType.NVarChar,256),
                    new SqlParameter("@IsLimit",SqlDbType.Bit,1)};
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value = model.UserName;
            parameters[2].Value = model.PassWord;
            parameters[3].Value = model.Phone;
            parameters[4].Value = model.Mobile;
            parameters[5].Value = model.Sex;
            parameters[6].Value = model.Address;
            parameters[7].Value = model.EntryTime;
            parameters[8].Value = model.DepartId;
            parameters[9].Value = model.Depart;
            parameters[10].Value = model.AgentId;
            parameters[11].Value = model.Agent;
            parameters[12].Value = model.Notes;
            parameters[13].Value = model.Email;
            parameters[14].Value = model.InJob;
            parameters[15].Value = model.LastLoginTime;
            parameters[16].Value = model.LastLoginIP;
            parameters[17].Value = model.Photo;
            parameters[18].Value = model.IsLimit;

            DbHelperSQL.RunProcedure(PubConstant.GetConnectionString("conn_second"), "X_UserInfo_ADD", parameters, out rowsAffected);
            return (int)parameters[0].Value;
        }

        /// <summary>
后面还有 248 行代码,购买后查看完整代码

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

AI 解读 AI

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

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