private void SetUserInfo(string sGetSql, SqlParameter[] paramsGet, SnsUser snsUser) { using (SqlDataReader aReader = SqlHelper.ExecuteReader(config.connectionString, CommandType.Text, sGetSql, paramsGet)) { if (aReader.Read()) { snsUser.UserId = Convert.ToInt32(aReader["UserId"]); snsUser.PassportId = Convert.ToString(aReader["PassportID"]); snsUser.RegTime = Convert.ToDateTime(aReader["RegTime"]); snsUser.RetailID = Convert.ToString(aReader["RetailID"]); snsUser.RetailUser = Convert.ToString(aReader["RetailUser"]); snsUser.Mobile = Convert.ToString(aReader["Mobile"]); snsUser.Mail = Convert.ToString(aReader["Mail"]); snsUser.RealName = Convert.ToString(aReader["RealName"]); snsUser.IDCards = Convert.ToString(aReader["IDCards"]); snsUser.ActiveCode = Convert.ToString(aReader["ActiveCode"]); snsUser.SendActiveDate = ToDate(Convert.ToString(aReader["SendActiveDate"])); snsUser.ActiveDate = ToDate(Convert.ToString(aReader["ActiveDate"])); snsUser.WeixinCode = Convert.ToString(aReader["WeixinCode"]); } } }
/// <summary> /// 补全用户信息 /// </summary> /// <param name="pid"></param> /// <param name="snsuser"></param> /// <returns></returns> public static int ChangeUserInfo(string pid, SnsUser snsuser) { SnsCenterUser snsCenterUser = new SnsCenterUser(); return snsCenterUser.ChangeUserInfo(pid, snsuser); }
internal int ChangeUserInfo(string pid, SnsUser snsuser) { try { string sInsertSql = string.Empty; List<SqlParameter> paramsUpdate = new List<SqlParameter>(); paramsUpdate.Add(SqlParamHelper.MakeInParam("@PassportId", SqlDbType.VarChar, 0, pid)); sInsertSql = "update SnsUserInfo set PassportId=@PassportId"; if (!string.IsNullOrEmpty(snsuser.Mobile)) { sInsertSql += ", Mobile=@Mobile"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@Mobile", SqlDbType.VarChar, 0, snsuser.Mobile)); } if (!string.IsNullOrEmpty(snsuser.Mail)) { sInsertSql += ", Mail=@Mail"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@Mail", SqlDbType.VarChar, 0, snsuser.Mail)); } if (!string.IsNullOrEmpty(snsuser.RealName)) { sInsertSql += ", RealName=@RealName"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@RealName", SqlDbType.VarChar, 0, snsuser.RealName)); } if (!string.IsNullOrEmpty(snsuser.IDCards)) { sInsertSql += ", IDCards=@IDCards"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@IDCards", SqlDbType.VarChar, 0, snsuser.IDCards)); } if (!string.IsNullOrEmpty(snsuser.ActiveCode)) { sInsertSql += ", ActiveCode=@ActiveCode"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@ActiveCode", SqlDbType.VarChar, 0, snsuser.ActiveCode)); } if (snsuser.SendActiveDate > DateTime.MinValue) { sInsertSql += ", SendActiveDate=@SendActiveDate"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@SendActiveDate", SqlDbType.DateTime, 0, snsuser.SendActiveDate)); } if (snsuser.ActiveDate > DateTime.MinValue) { sInsertSql += ", ActiveDate=@ActiveDate"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@ActiveDate", SqlDbType.DateTime, 0, snsuser.ActiveDate)); } if (!string.IsNullOrEmpty(snsuser.WeixinCode)) { sInsertSql += ", WeixinCode=@WeixinCode"; paramsUpdate.Add(SqlParamHelper.MakeInParam("@WeixinCode", SqlDbType.VarChar, 0, snsuser.WeixinCode)); } sInsertSql += " where PassportId=@PassportId"; return SqlHelper.ExecuteNonQuery(config.connectionString, CommandType.Text, sInsertSql, paramsUpdate.ToArray()); } catch (Exception ex) { _Logger.SaveLog(ex); return 0; } }
internal SnsUser GetUserInfo(string passportId) { SnsUser snsUser = new SnsUser(); string sGetSql = "select top 1 [UserId],[PassportID],[PassportPwd],[DeviceID],[RegType],[RegTime],[RetailID],[RetailUser],[Mobile],[Mail],[PwdType],[RealName],[IDCards],[ActiveCode],[SendActiveDate],[ActiveDate],WeixinCode from SnsUserInfo where PassportId=@PassportId"; List<SqlParameter> listTmp = new List<SqlParameter>(); listTmp.Add(SqlParamHelper.MakeInParam("@PassportId", SqlDbType.VarChar, 0, passportId)); SqlParameter[] paramsGet = listTmp.ToArray(); SetUserInfo(sGetSql, paramsGet, snsUser); return snsUser; }
private void SetUserInfo(Action<CommandFilter> match, SnsUser snsUser) { var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Inquiry); command.OrderBy = "USERID ASC"; command.Columns = "UserId,PassportID,PassportPwd,DeviceID,RegType,RegTime,RetailID,RetailUser,Mobile,Mail,PwdType,RealName,IDCards,ActiveCode,SendActiveDate,ActiveDate,WeixinCode"; command.Filter = ConnectManager.Provider.CreateCommandFilter(); match(command.Filter); command.Parser(); using (var aReader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (aReader.Read()) { snsUser.UserId = Convert.ToInt32(aReader["UserId"]); snsUser.IMEI = Convert.ToString(aReader["DeviceID"]); snsUser.PassportId = Convert.ToString(aReader["PassportID"]); snsUser.Password = Convert.ToString(aReader["PassportPwd"]); snsUser.RegTime = Convert.ToDateTime(aReader["RegTime"]); snsUser.RetailID = Convert.ToString(aReader["RetailID"]); snsUser.RetailUser = Convert.ToString(aReader["RetailUser"]); snsUser.Mobile = Convert.ToString(aReader["Mobile"]); snsUser.Mail = Convert.ToString(aReader["Mail"]); snsUser.RealName = Convert.ToString(aReader["RealName"]); snsUser.IDCards = Convert.ToString(aReader["IDCards"]); snsUser.ActiveCode = Convert.ToString(aReader["ActiveCode"]); snsUser.SendActiveDate = ToDate(Convert.ToString(aReader["SendActiveDate"])); snsUser.ActiveDate = ToDate(Convert.ToString(aReader["ActiveDate"])); snsUser.WeixinCode = Convert.ToString(aReader["WeixinCode"]); snsUser.PwdType = (PwdType)Enum.ToObject(typeof(PwdType), Convert.ToInt32(aReader["PwdType"])); RegType regType = (RegType)Enum.ToObject(typeof(RegType), Convert.ToInt32(aReader["RegType"])); if (regType == RegType.Other && regType != RegType.Other) { //渠道登陆的用户允许更换包登陆 regType = string.IsNullOrEmpty(snsUser.IMEI) ? RegType.Normal : regType; } snsUser.RegType = regType; } } }
/// <summary> /// /// </summary> /// <param name="pid"></param> /// <param name="password"></param> /// <param name="deviceID"></param> /// <param name="openId"></param> /// <returns>0:失败, 1:成功 2:已绑定</returns> public static int RegisterWeixin(string pid, string password, string deviceID, string openId) { SnsCenterUser snsCenterUser = new SnsCenterUser(pid, password, deviceID); if (snsCenterUser.GetUserId() > 0) { if (string.IsNullOrEmpty(snsCenterUser.WeixinCode)) { SnsUser snsuser = new SnsUser() { PassportId = pid, WeixinCode = openId }; return snsCenterUser.ChangeUserInfo(pid, snsuser) > 0 ? 1 : 0; } return 2; } return 0; }
/// <summary> /// /// </summary> /// <param name="retailID"></param> /// <param name="retailUser"></param> /// <returns></returns> public SnsUser GetUserInfo(string retailID, string retailUser) { SnsUser snsUser = new SnsUser(); SetUserInfo(f => { f.Condition = string.Format("{0} AND {1}", f.FormatExpression("RetailID"), f.FormatExpression("RetailUser")); f.AddParam("RetailID", retailID); f.AddParam("RetailUser", retailUser); }, snsUser); return snsUser; }
/// <summary> /// 通过微信号 /// </summary> /// <param name="openId"></param> /// <returns></returns> public SnsUser GetUserByWeixin(string openId) { SnsUser snsUser = new SnsUser(); SetUserInfo(f => { f.Condition = f.FormatExpression("WeixinCode"); f.AddParam("WeixinCode", openId); }, snsUser); return snsUser; }
internal int ChangeUserInfo(string pid, SnsUser snsuser) { try { var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Modify); if (!string.IsNullOrEmpty(snsuser.Mobile)) { command.AddParameter("Mobile", snsuser.Mobile); } if (!string.IsNullOrEmpty(snsuser.Mail)) { command.AddParameter("Mail", snsuser.Mail); } if (!string.IsNullOrEmpty(snsuser.RealName)) { command.AddParameter("RealName", snsuser.RealName); } if (!string.IsNullOrEmpty(snsuser.IDCards)) { command.AddParameter("IDCards", snsuser.IDCards); } if (!string.IsNullOrEmpty(snsuser.ActiveCode)) { command.AddParameter("ActiveCode", snsuser.ActiveCode); } if (snsuser.SendActiveDate > DateTime.MinValue) { command.AddParameter("SendActiveDate", snsuser.SendActiveDate); } if (snsuser.ActiveDate > DateTime.MinValue) { command.AddParameter("ActiveDate", snsuser.ActiveDate); } if (!string.IsNullOrEmpty(snsuser.WeixinCode)) { command.AddParameter("WeixinCode", snsuser.WeixinCode); } command.Filter = ConnectManager.Provider.CreateCommandFilter(); command.Filter.Condition = command.Filter.FormatExpression("PassportID"); command.Filter.AddParam("PassportID", pid); command.Parser(); return ConnectManager.Provider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters); } catch (Exception ex) { _Logger.SaveLog(ex); return 0; } }
/// <summary> /// /// </summary> /// <param name="passportId"></param> /// <returns></returns> public SnsUser GetUserInfo(string passportId) { SnsUser snsUser = new SnsUser(); SetUserInfo(f => { f.Condition = f.FormatExpression("PassportId"); f.AddParam("PassportId", passportId); }, snsUser); return snsUser; }
/// <summary> /// 验证 /// </summary> /// <param name="snsUser"></param> /// <returns></returns> public bool ValidatePassport(SnsUser snsUser) { string password = _PassportPwd; if (snsUser.RegType == RegType.Normal) { if (snsUser.PwdType == PwdType.MD5) { password = PasswordEncryptMd5(_PassportPwd); } return snsUser.PassportId == _PassportId && snsUser.Password == password; } if (snsUser.RegType == RegType.Guest) { if (snsUser.PwdType == PwdType.MD5) { if (password.Length != 32) { //判断是否已经MD5加密 password = PasswordEncryptMd5(_PassportPwd); } } return snsUser.PassportId == _PassportId && snsUser.Password == password && snsUser.IMEI == _imei; } return snsUser.RetailID == RetailID && snsUser.RetailUser == RetailUser; }
private void SetUserInfo(Action<CommandFilter> match, SnsUser snsUser) { var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Inquiry); command.OrderBy = "USERID ASC"; command.Columns = "UserId,PassportId,Password,DeviceId,RegType,RegTime,RetailId,RetailUser,Mobile,Mail,PwdType,RealName,IdCards,ActiveCode,SendActiveDate,ActiveDate,WeixinCode"; command.Filter = ConnectManager.Provider.CreateCommandFilter(); match(command.Filter); command.Parser(); using (var reader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (reader.Read()) { snsUser.UserId = Convert.ToInt32(reader["UserId"]); snsUser.DeviceId = Convert.ToString(reader["DeviceId"]); snsUser.PassportId = Convert.ToString(reader["PassportId"]); snsUser.Password = Convert.ToString(reader["Password"]); snsUser.RegTime = Convert.ToDateTime(reader["RegTime"]); snsUser.RetailId = Convert.ToString(reader["RetailId"]); snsUser.RetailUser = Convert.ToString(reader["RetailUser"]); snsUser.Mobile = Convert.ToString(reader["Mobile"]); snsUser.Mail = Convert.ToString(reader["Mail"]); snsUser.RealName = Convert.ToString(reader["RealName"]); snsUser.IdCards = Convert.ToString(reader["IdCards"]); snsUser.ActiveCode = Convert.ToString(reader["ActiveCode"]); snsUser.SendActiveDate = ToDate(Convert.ToString(reader["SendActiveDate"])); snsUser.ActiveDate = ToDate(Convert.ToString(reader["ActiveDate"])); snsUser.WeixinCode = Convert.ToString(reader["WeixinCode"]); snsUser.PwdType = (PwdType)Enum.ToObject(typeof(PwdType), Convert.ToInt32(reader["PwdType"])); snsUser.RegType = (RegType)Enum.ToObject(typeof(RegType), Convert.ToInt32(reader["RegType"])); } } }
/// <summary> /// 是否有绑定DeviceId /// </summary> /// <returns></returns> public SnsUser GetUserByDeviceId(string imei) { SnsUser snsUser = new SnsUser(); if (string.IsNullOrEmpty(imei)) { return snsUser; } SetUserInfo(f => { f.Condition = string.Format("RegType = 1 AND {0}", f.FormatExpression("DeviceId")); //Guest f.AddParam("DeviceId", imei); }, snsUser); return snsUser; }
/// <summary> /// 验证 /// </summary> /// <param name="snsUser"></param> /// <returns></returns> public bool ValidatePassport(SnsUser snsUser) { string pwd = password; if (snsUser.RegType == RegType.Normal) { if (snsUser.PwdType == PwdType.MD5) { pwd = PasswordEncryptMd5(pwd); } return snsUser.PassportId == passportId && snsUser.Password == pwd; } if (snsUser.RegType == RegType.Guest) { if (snsUser.PwdType == PwdType.MD5) { //判断是否已经MD5加密 pwd = PasswordEncryptMd5(pwd); } return snsUser.PassportId == passportId && snsUser.Password == pwd; } return snsUser.RetailId == RetailId && snsUser.RetailUser == RetailUser; }
/// <summary> /// 补全用户信息 /// </summary> /// <param name="pid"></param> /// <param name="snsuser"></param> /// <returns></returns> public static int ChangeUserInfo(string pid, SnsUser snsuser) { SnsCenterUser snsCenterUser = new SnsCenterUser(); return(snsCenterUser.ChangeUserInfo(pid, snsuser)); }