/// <summary>
/// 创建用户记录
/// </summary>
/// <param name="uAccount">用户账号信息</param>
/// <param name="uInfo">用户个人信息</param>
/// <param name="extInfo">用户扩展信息</param>
/// <param name="userCoords">用户当前位置坐标信息</param>
/// <param name="userOptions">用户个人应用设置信息</param>
/// <param name="userInSchool">学校用户信息</param>
public static void CreateUser(UserAccount uAccount, UserInfo uInfo, UserExtInfo extInfo, UserCoords userCoords, UserOptions userOptions, UserWithSchool userInSchool)
{
using (DbCommander cmd = new DbCommander(DbConn.WriteDb, "SP_Users_UserAccountCreate", CommandType.StoredProcedure))
{
cmd.AddInputParameters(
@"UserId, UserName, Password, PasswordFormat, PasswordSalt, LoginCount, CreateDate, NickName, RealName, BackIcon, HeadIcon, Signature, Comment, Gender, Birthday, IDCardNo, Area, Address, PostCode, Industry, Company, JobPosition, Interests, WebSite, Email, Mobile, Telphone, QQ, MSN, OtherInfo, UserSite, UserRole, UserAccess, CreateDeviceId, CreateAPPChannel, CreateAccountChannel, Longitude, Latitudes, RemindPrivateMessage, RemindGroupMessage, RemindBeFollowed, RemindTopicBeReply, SchoolId, IsTrial, TrialedSource, IsActivated, IsExpired, StudNo, ClassInfo, SchoolComment, SyncForBbs, Status",
uAccount.UserId,
uAccount.UserName,
uAccount.Password,
uAccount.PasswordFormat,
uAccount.PasswordSalt,
uAccount.LoginCount,
uAccount.CreateDate,
uInfo.NickName,
uInfo.RealName,
uInfo.BackIcon,
uInfo.HeadIcon,
uInfo.Signature,
uInfo.Comment,
uInfo.Gender,
uInfo.Birthday,
uInfo.IDCardNo,
uInfo.Area,
uInfo.Address,
uInfo.PostCode,
uInfo.Industry,
uInfo.Company,
uInfo.JobPosition,
uInfo.Interests,
uInfo.WebSite,
uInfo.Email,
uInfo.Mobile,
uInfo.Telphone,
uInfo.QQ,
uInfo.MSN,
uInfo.OtherInfo,
extInfo.UserSite,
extInfo.UserRole,
extInfo.UserAccess,
extInfo.CreateDeviceId,
extInfo.CreateAPPChannel,
extInfo.CreateAccountChannel,
userCoords.Longitude,
userCoords.Latitudes,
userOptions.RemindPrivateMessage,
userOptions.RemindGroupMessage,
userOptions.RemindBeFollowed,
userOptions.RemindTopicBeReply,
userInSchool.SchoolId,
userInSchool.IsTrial,
userInSchool.TrialedSource,
userInSchool.IsActivated,
userInSchool.IsExpired,
userInSchool.StudNo,
userInSchool.ClassInfo,
userInSchool.Comment,
userInSchool.SyncForBbs,
userInSchool.Status
);
uAccount.UserId = Convert.ToInt32(cmd.ExecuteScalar());
}
}
