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 算力,解读结果公开显示在下面。
还没有人解读过这个文件。