public int InsertSnsUser(string[] paramNames, string[] paramValues) { SnsPassport oSnsPassportLog = new SnsPassport(); if (!oSnsPassportLog.VerifyRegPassportId(_PassportId)) { return(0); } //md5加密 string password = CryptoHelper.DES_Decrypt(_PassportPwd, GameEnvironment.ProductDesEnKey); password = PasswordEncryptMd5(password); string sInsertSql = string.Empty; string extColumns = string.Join(",", paramNames); extColumns = extColumns.TrimEnd().Length > 0 ? "," + extColumns : string.Empty; string paramColumns = string.Join(",@", paramNames); paramColumns = paramColumns.TrimEnd().Length > 0 ? ",@" + paramColumns : string.Empty; List <SqlParameter> paramsInsert = new List <SqlParameter>(); sInsertSql = string.Format("insert into SnsUserInfo(passportid, passportpwd, DeviceID, RegType, RegTime,RetailID,RetailUser,PwdType{0})", extColumns); sInsertSql += string.Format("values(@aPassportId, @aPassportPwd, @DeviceID, @RegType, @RegTime, @RetailID, @RetailUser,@PwdType{0}) select @@IDENTITY", paramColumns); paramsInsert.Add(SqlParamHelper.MakeInParam("@aPassportId", SqlDbType.VarChar, 0, _PassportId)); paramsInsert.Add(SqlParamHelper.MakeInParam("@aPassportPwd", SqlDbType.VarChar, 0, password)); paramsInsert.Add(SqlParamHelper.MakeInParam("@deviceID", SqlDbType.VarChar, 0, _deviceID)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RegType", SqlDbType.Int, 0, (int)RegType)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RegTime", SqlDbType.DateTime, 0, DateTime.Now)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RetailID", SqlDbType.VarChar, 0, RetailID)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RetailUser", SqlDbType.VarChar, 0, RetailUser)); paramsInsert.Add(SqlParamHelper.MakeInParam("@PwdType", SqlDbType.Int, 0, (int)PwdType.MD5)); for (int i = 0; i < paramNames.Length; i++) { paramsInsert.Add(SqlParamHelper.MakeInParam("@" + paramNames[i], SqlDbType.VarChar, 0, paramValues[i])); } try { if (!oSnsPassportLog.SetPassportReg(_PassportId)) { throw new Exception("SetPassportReg Error"); } using (SqlDataReader aReader = SqlHelper.ExecuteReader(config.connectionString, CommandType.Text, sInsertSql, paramsInsert.ToArray())) { if (aReader.Read()) { _userid = Convert.ToInt32(aReader[0]); } } return(_userid); } catch (Exception ex) { _Logger.SaveLog(ex); return(0); } }
/// <summary> /// Inserts the sns user. /// </summary> /// <returns>The sns user.</returns> /// <param name="paramNames">Parameter names.</param> /// <param name="paramValues">Parameter values.</param> public int InsertSnsUser(string[] paramNames, string[] paramValues) { SnsPassport oSnsPassportLog = new SnsPassport(); if (!oSnsPassportLog.VerifyRegPassportId(_PassportId)) { return(0); } //md5加密 string password = PasswordEncryptMd5(_PassportPwd); var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Insert); command.ReturnIdentity = true; command.AddParameter("passportid", _PassportId); command.AddParameter("passportpwd", password); command.AddParameter("DeviceID", _imei); command.AddParameter("RegType", (int)RegType); command.AddParameter("RegTime", DateTime.Now); command.AddParameter("RetailID", RetailID); command.AddParameter("RetailUser", RetailUser); command.AddParameter("PwdType", (int)PwdType.MD5); if (paramNames != null && paramValues != null) { for (int i = 0; i < paramNames.Length; i++) { command.AddParameter(paramNames[i], paramValues.Length > i ? paramValues[i] : ""); } } command.Parser(); try { if (!oSnsPassportLog.SetPassportReg(_PassportId)) { throw new Exception("Set passport State.Reg fail."); } using (var aReader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (aReader.Read()) { _userid = Convert.ToInt32(aReader[0]); } } return(_userid); } catch (Exception ex) { _Logger.SaveLog(ex); return(0); } }
/// <summary> /// 通行证检查 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool CheckPassport(string user) { SnsPassport passport = new SnsPassport(); return passport.VerifyRegPassportId(user); }
/// <summary> /// 通行证检查 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool CheckPassport(string user) { SnsPassport passport = new SnsPassport(); return(passport.VerifyRegPassportId(user)); }
public int InsertSnsUser(string[] paramNames, string[] paramValues) { SnsPassport oSnsPassportLog = new SnsPassport(); if (!oSnsPassportLog.VerifyRegPassportId(_PassportId)) { return 0; } //md5加密 string password = CryptoHelper.DES_Decrypt(_PassportPwd, GameEnvironment.ProductDesEnKey); password = PasswordEncryptMd5(password); string sInsertSql = string.Empty; string extColumns = string.Join(",", paramNames); extColumns = extColumns.TrimEnd().Length > 0 ? "," + extColumns : string.Empty; string paramColumns = string.Join(",@", paramNames); paramColumns = paramColumns.TrimEnd().Length > 0 ? ",@" + paramColumns : string.Empty; List<SqlParameter> paramsInsert = new List<SqlParameter>(); sInsertSql = string.Format("insert into SnsUserInfo(passportid, passportpwd, DeviceID, RegType, RegTime,RetailID,RetailUser,PwdType{0})", extColumns); sInsertSql += string.Format("values(@aPassportId, @aPassportPwd, @DeviceID, @RegType, @RegTime, @RetailID, @RetailUser,@PwdType{0}) select @@IDENTITY", paramColumns); paramsInsert.Add(SqlParamHelper.MakeInParam("@aPassportId", SqlDbType.VarChar, 0, _PassportId)); paramsInsert.Add(SqlParamHelper.MakeInParam("@aPassportPwd", SqlDbType.VarChar, 0, password)); paramsInsert.Add(SqlParamHelper.MakeInParam("@deviceID", SqlDbType.VarChar, 0, _deviceID)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RegType", SqlDbType.Int, 0, (int)RegType)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RegTime", SqlDbType.DateTime, 0, DateTime.Now)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RetailID", SqlDbType.VarChar, 0, RetailID)); paramsInsert.Add(SqlParamHelper.MakeInParam("@RetailUser", SqlDbType.VarChar, 0, RetailUser)); paramsInsert.Add(SqlParamHelper.MakeInParam("@PwdType", SqlDbType.Int, 0, (int)PwdType.MD5)); for (int i = 0; i < paramNames.Length; i++) { paramsInsert.Add(SqlParamHelper.MakeInParam("@" + paramNames[i], SqlDbType.VarChar, 0, paramValues[i])); } try { if (!oSnsPassportLog.SetPassportReg(_PassportId)) { throw new Exception("SetPassportReg Error"); } using (SqlDataReader aReader = SqlHelper.ExecuteReader(config.connectionString, CommandType.Text, sInsertSql, paramsInsert.ToArray())) { if (aReader.Read()) { _userid = Convert.ToInt32(aReader[0]); } } return _userid; } catch (Exception ex) { _Logger.SaveLog(ex); return 0; } }
/// <summary> /// Inserts the sns user. /// </summary> /// <returns>The sns user.</returns> /// <param name="paramNames">Parameter names.</param> /// <param name="paramValues">Parameter values.</param> public int InsertSnsUser(string[] paramNames, string[] paramValues) { SnsPassport oSnsPassportLog = new SnsPassport(); if (!oSnsPassportLog.VerifyRegPassportId(_PassportId)) { return 0; } //md5加密 string password = PasswordEncryptMd5(_PassportPwd); var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Insert); command.ReturnIdentity = true; command.AddParameter("passportid", _PassportId); command.AddParameter("passportpwd", password); command.AddParameter("DeviceID", _imei); command.AddParameter("RegType", (int)RegType); command.AddParameter("RegTime", DateTime.Now); command.AddParameter("RetailID", RetailID); command.AddParameter("RetailUser", RetailUser); command.AddParameter("PwdType", (int)PwdType.MD5); if (paramNames != null && paramValues != null) { for (int i = 0; i < paramNames.Length; i++) { command.AddParameter(paramNames[i], paramValues.Length > i ? paramValues[i] : ""); } } command.Parser(); try { if (!oSnsPassportLog.SetPassportReg(_PassportId)) { throw new Exception("Set passport State.Reg fail."); } using (var aReader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (aReader.Read()) { _userid = Convert.ToInt32(aReader[0]); } } return _userid; } catch (Exception ex) { _Logger.SaveLog(ex); return 0; } }