/// <summary> /// 增加一条注册日志数据 /// 作者:郭孟稳 /// </summary> /// <param name="storeId"></param> /// <param name="userId"></param> /// <param name="LevelId"></param> /// <param name="belongOne"></param> /// <returns></returns> private int AddRegisterLog(MemberChangeLogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"insert into Mall_Member_ChangeLog (Member_Id,Change_Type,Remark,Add_Time,Customer_Id ,BelongOne,BelongTwo,BelongThree,BeforeBelongOne,BeforeBelongTwo,BeforeBelongThree,ParentId,BeforeParentId,Reason) values (@Member_Id,@Change_Type,@Remark,@Add_Time,@Customer_Id ,@BelongOne,@BelongTwo,@BelongThree,@BeforeBelongOne,@BeforeBelongTwo,@BeforeBelongThree,@ParentId,@BeforeParentId,@Reason) select @@IDENTITY"); var parm = new[] { new SqlParameter("@Member_Id", model.Member_Id), new SqlParameter("@Change_Type", model.Change_Type), new SqlParameter("@Remark", model.Remark), new SqlParameter("@Add_Time", model.Add_Time), new SqlParameter("@Customer_Id", model.Customer_Id), new SqlParameter("@BelongOne", model.BelongOne), new SqlParameter("@BelongTwo", model.BelongTwo), new SqlParameter("@BelongThree", model.BelongThree), new SqlParameter("@BeforeBelongOne", model.BeforeBelongOne), new SqlParameter("@BeforeBelongTwo", model.BeforeBelongTwo), new SqlParameter("@BeforeBelongThree", model.BeforeBelongThree), new SqlParameter("@ParentId", model.ParentId), new SqlParameter("@BeforeParentId", model.BeforeParentId), new SqlParameter("@Reason", model.Reason) }; object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql.ToString(), parm); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 添加商城用户 /// 作者:郭孟稳 /// 时间:2016.07.11 /// </summary> /// <param name="storeId"></param> /// <param name="mobile"></param> /// <param name="password"></param> /// <param name="userName"></param> /// <param name="belongOne"></param> /// <returns></returns> private int AddUserBaseInfoModel(int storeId, string mobile, string loginName, string password, string userName, string nickName, int belongOne, int levelId = 0) { if (UserExist(loginName, storeId)) { return(-1); } UserBaseInfoModel model = new UserBaseInfoModel(); model.UB_UserLoginName = loginName; model.UB_UserLoginPassword = password; model.UB_CustomerID = storeId; model.UB_UserMobile = mobile; model.UB_UserType = 0; model.UB_GroupId = 0; model.UB_RebateEnabled = 0; model.WxNickName = nickName;//QQ昵称对应微信昵称 model.UB_UserRealName = userName; model.UB_UserNickName = nickName; model.UB_ShareCount = 0; //分享机会赠送 model.UB_InviteCount = 0; model.UB_UserEmail = ""; model.UB_UserCardID = ""; model.UB_UserCity = ""; model.UB_UserProvince = ""; model.BelongName = ""; model.LevelName = ""; model.ParentName = ""; model.PayPassword = ""; model.UB_SourcePath = ""; model.UB_StoreAddr = ""; model.UB_UserAddress = ""; model.UB_UserArea = ""; model.UB_UserBirthday = ""; model.UB_UserFace = ""; model.UB_UserIncome = ""; model.UserAllArea = ""; model.WxHeadImg = ""; model.UB_AccountSrc = 0; model.UB_MobileToBeBind = 0; model.UB_ShareTaskID = 0; model.UB_ShareTaskType = 0; UserRelationViewEntity sourceModel = null; if (belongOne > 0) { model.UB_SourceID = belongOne; model.UB_SourceDesc = "我引导注册"; sourceModel = GetRelationInfoPlus(belongOne); } else { model.UB_SourceDesc = "管理员后台添加"; } if (sourceModel != null) { model.UB_BelongOne = sourceModel.UserId; model.UB_BelongTwo = sourceModel.BelongOne; model.UB_BelongThree = sourceModel.BelongTwo; model.UB_SourceID = sourceModel.UserId; model.UB_ParentID = 0; } if (levelId == 0) { model.UB_LevelID = GetMinLevelID(storeId, 0); } else { model.UB_LevelID = levelId; } try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Hot_UserBaseInfo("); strSql.Append("UB_UserMobile,UB_UserEmail,UB_UserCardID,UB_UserProvince,UB_UserCity,UB_UserArea,UB_UserAddress,UB_UserLoginPassword,UB_UserNickName,UB_UserFace,UB_UserRealName,UB_UserAge,UB_UserIncome,UB_IsDelete,UB_CustomerID,UB_UserBirthday,UB_HasCard,UB_UserLoginName,UB_LevelID,UB_UserType,UB_BelongTo,UB_SourceID,UB_SourceDesc,UB_ShareCount,UB_InviteCount,UB_ShareTaskID,UB_ShareTaskType,UB_StoreAddr,UB_IsStore,UB_ParentID,UB_SourcePath,UB_SourceDepth,UB_BelongOne,UB_BelongTwo,UB_BelongThree,UB_UserGroupId,UB_AccountSrc,UB_MobileToBeBind,UB_WxNickName,UB_WxHeadImg"); strSql.Append(") values ("); strSql.Append("@UB_UserMobile,@UB_UserEmail,@UB_UserCardID,@UB_UserProvince,@UB_UserCity,@UB_UserArea,@UB_UserAddress,@UB_UserLoginPassword,@UB_UserNickName,@UB_UserFace,@UB_UserRealName,@UB_UserAge,@UB_UserIncome,@UB_IsDelete,@UB_CustomerID,@UB_UserBirthday,@UB_HasCard,@UB_UserLoginName,@UB_LevelID,@UB_UserType,@UB_BelongTo,@UB_SourceID,@UB_SourceDesc,@UB_ShareCount,@UB_InviteCount,@UB_ShareTaskID,@UB_ShareTaskType,@UB_StoreAddr,@UB_IsStore,@UB_ParentID,@UB_SourcePath,@UB_SourceDepth,@UB_BelongOne,@UB_BelongTwo,@UB_BelongThree,@UB_UserGroupId,@UB_AccountSrc,@UB_MobileToBeBind,@UB_WxNickName,@UB_WxHeadImg"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UB_UserMobile", SqlDbType.NVarChar), new SqlParameter("@UB_UserEmail", SqlDbType.NVarChar), new SqlParameter("@UB_UserCardID", SqlDbType.NVarChar), new SqlParameter("@UB_UserProvince", SqlDbType.NVarChar), new SqlParameter("@UB_UserCity", SqlDbType.NVarChar), new SqlParameter("@UB_UserArea", SqlDbType.NVarChar), new SqlParameter("@UB_UserAddress", SqlDbType.NVarChar), new SqlParameter("@UB_UserLoginPassword", SqlDbType.NVarChar), new SqlParameter("@UB_UserNickName", SqlDbType.NVarChar), new SqlParameter("@UB_UserFace", SqlDbType.NVarChar), new SqlParameter("@UB_UserRealName", SqlDbType.NVarChar), new SqlParameter("@UB_UserAge", SqlDbType.Int), new SqlParameter("@UB_UserIncome", SqlDbType.NVarChar), new SqlParameter("@UB_IsDelete", SqlDbType.Int), new SqlParameter("@UB_CustomerID", SqlDbType.Int), new SqlParameter("@UB_UserBirthday", SqlDbType.NVarChar), new SqlParameter("@UB_HasCard", SqlDbType.Int), new SqlParameter("@UB_UserLoginName", SqlDbType.NVarChar), new SqlParameter("@UB_LevelID", SqlDbType.Int), new SqlParameter("@UB_UserType", SqlDbType.Int), new SqlParameter("@UB_BelongTo", SqlDbType.Int), new SqlParameter("@UB_SourceID", SqlDbType.Int), new SqlParameter("@UB_SourceDesc", SqlDbType.NVarChar), new SqlParameter("@UB_ShareCount", SqlDbType.Int), new SqlParameter("@UB_InviteCount", SqlDbType.Int), new SqlParameter("@UB_ShareTaskID", SqlDbType.Int), new SqlParameter("@UB_ShareTaskType", SqlDbType.Int), new SqlParameter("@UB_StoreAddr", SqlDbType.NVarChar), new SqlParameter("@UB_IsStore", SqlDbType.Int), new SqlParameter("@UB_ParentID", SqlDbType.Int), new SqlParameter("@UB_SourcePath", SqlDbType.NVarChar), new SqlParameter("@UB_SourceDepth", SqlDbType.Int), new SqlParameter("@UB_BelongOne", SqlDbType.Int), new SqlParameter("@UB_BelongTwo", SqlDbType.Int), new SqlParameter("@UB_BelongThree", SqlDbType.Int), new SqlParameter("@UB_UserGroupId", SqlDbType.Int), new SqlParameter("@UB_AccountSrc", SqlDbType.Int), new SqlParameter("@UB_MobileToBeBind", SqlDbType.Int), new SqlParameter("@UB_WxNickName", SqlDbType.VarChar), new SqlParameter("@UB_WxHeadImg", SqlDbType.VarChar) }; parameters[0].Value = model.UB_UserMobile; parameters[1].Value = model.UB_UserEmail; parameters[2].Value = model.UB_UserCardID; parameters[3].Value = model.UB_UserProvince; parameters[4].Value = model.UB_UserCity; parameters[5].Value = model.UB_UserArea; parameters[6].Value = model.UB_UserAddress; parameters[7].Value = model.UB_UserLoginPassword; parameters[8].Value = model.UB_UserNickName; parameters[9].Value = model.UB_UserFace; parameters[10].Value = model.UB_UserRealName; parameters[11].Value = model.UB_UserAge; parameters[12].Value = model.UB_UserIncome; parameters[13].Value = model.UB_IsDelete; parameters[14].Value = model.UB_CustomerID; parameters[15].Value = model.UB_UserBirthday; parameters[16].Value = model.UB_HasCard; parameters[17].Value = model.UB_UserLoginName; parameters[18].Value = model.UB_LevelID; parameters[19].Value = model.UB_UserType; parameters[20].Value = model.UB_BelongTo; parameters[21].Value = model.UB_SourceID; parameters[22].Value = model.UB_SourceDesc; parameters[23].Value = model.UB_ShareCount; parameters[24].Value = model.UB_InviteCount; parameters[25].Value = model.UB_ShareTaskID; parameters[26].Value = model.UB_ShareTaskType; parameters[27].Value = model.UB_StoreAddr; parameters[28].Value = model.UB_IsStore; parameters[29].Value = model.UB_ParentID; parameters[30].Value = model.UB_SourcePath; parameters[31].Value = model.UB_SourceDepth; parameters[32].Value = model.UB_BelongOne; parameters[33].Value = model.UB_BelongTwo; parameters[34].Value = model.UB_BelongThree; parameters[35].Value = model.UB_UserGroupId; parameters[36].Value = model.UB_AccountSrc; parameters[37].Value = model.UB_MobileToBeBind; parameters[38].Value = model.WxNickName; parameters[39].Value = model.WxHeadImg; object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { int userId = Convert.ToInt32(obj); MemberChangeLogModel changeLog = new MemberChangeLogModel() { Member_Id = userId, Change_Type = 5, Remark = "会员注册", Add_Time = DateTime.Now, Customer_Id = storeId, BelongOne = belongOne, BelongTwo = model.UB_BelongTwo, BelongThree = model.UB_BelongThree, ParentId = model.UB_ParentID, GroupId = 0, LevelId = model.UB_LevelID, BeforeBelongOne = 0, BeforeBelongTwo = 0, BeforeBelongThree = 0, BeforeParentId = 0, BeforeGroupId = 0, BeforeLevelId = 0, Reason = "邀请注册" }; if (userId > 0) { AddRegisterLog(changeLog); } return(userId); } } catch (Exception ex) { LogHelper.Log(string.Format("AddUserBaseInfoModel:{0}", ex), LogHelperTag.ERROR, WebConfig.debugMode()); return(0); } }