Ejemplo n.º 1
0
        /// <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));
            }
        }
Ejemplo n.º 2
0
        /// <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);
            }
        }