/// <summary> /// 注册 /// </summary> /// <param name="password"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns>pid</returns> public static string RegisterPassport(string password, string[] paramNames = null, string[] paramValues = null) { string pid = new SnsPassport().GetRegPassport(); DoRegisterPassport(pid, password, paramNames, paramValues); return(pid); }
/// <summary> /// Determines whether this instance is exist retail. /// </summary> /// <returns><c>true</c> if this instance is exist retail; otherwise, <c>false</c>.</returns> public bool IsExistRetail() { var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Inquiry); command.Columns = "userid"; command.OrderBy = "USERID ASC"; command.Filter = ConnectManager.Provider.CreateCommandFilter(); command.Filter.Condition = string.Format("{0} AND {1}", command.Filter.FormatExpression("RetailID"), command.Filter.FormatExpression("RetailUser") ); command.Filter.AddParam("RetailID", RetailID); command.Filter.AddParam("RetailUser", RetailUser); command.Parser(); using (var aReader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (aReader.Read()) { return(true); } } //自动获取通行证 SnsPassport passport = new SnsPassport(); this._PassportId = passport.GetRegPassport(); this._PassportPwd = passport.GetRandomPwd(); return(false); }
/// <summary> /// 通道商验证登录 /// </summary> /// <param name="retailId"></param> /// <param name="retailUser"></param> /// <returns></returns> public static string[] LoginByRetail(string retailId, string retailUser) { string[] result = new string[2]; SnsCenterUser snsCenterUser = new SnsCenterUser(); var snsuser = snsCenterUser.GetUserInfo(retailId, retailUser); if (snsuser.UserId <= 0) { //自动获取通行证 SnsPassport passport = new SnsPassport(); string pid = passport.GetRegPassport(); string pwd = passport.GetRandomPwd(); //modify login of retail bug. snsCenterUser = new SnsCenterUser(pid, pwd, string.Empty) { RetailID = retailId, RetailUser = retailUser }; result[0] = snsCenterUser.InsertSnsUser().ToString(); result[1] = pid; return(result); } result[0] = snsuser.UserId.ToString(); result[1] = snsuser.PassportId; return(result); }
/// <summary> /// 注册 /// </summary> /// <param name="password"></param> /// <param name="imei"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns>pid</returns> public static string RegisterPassport(string password, string imei, string[] paramNames = null, string[] paramValues = null) { int userType; string pid = new SnsPassport().GetRegPassport(); DoRegisterPassport(pid, password, imei, paramNames, paramValues, out userType, false); return(pid); }
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="imei">if null then get new pid</param> /// <returns></returns> public static string[] GetRegPassport(string imei) { if (!SnsCenterUser.CheckDevice(imei)) { throw (new Exception("禁止登入")); } var list = new List <string>(); SnsCenterUser user = SnsCenterUser.GetUserByDeviceId(imei); string passportId = string.Empty; if (user != null) { passportId = user.PassportId; list.Add(passportId); list.Add(user.Password); } else { SnsPassport passport = new SnsPassport(); PassportExpired passportExpired; if (!imeiMap.TryGetValue(imei, out passportExpired)) { passportId = passport.GetRegPassport(); imeiMap[imei] = new PassportExpired(passportId); } else { passportId = passportExpired.Pid; if (passportExpired.ExpiredTime < DateTime.Now) { //过期移除 imeiMap.TryRemove(imei, out passportExpired); } //检查超出 List <string> expiredMap; if (imeiMap.Count > 100 && ((expiredMap = imeiMap.Where(t => t.Value.ExpiredTime < DateTime.Now).Select(t => t.Key).ToList()).Count > 10)) { foreach (var expired in expiredMap) { imeiMap.TryRemove(expired, out passportExpired); } } } string password = passport.GetRandomPwd(); list.Add(passportId); list.Add(password); } return(list.ToArray()); }
/// <summary> /// 注册 /// </summary> /// <param name="password"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns></returns> public static string RegisterPassport(string password, string[] paramNames, string[] paramValues) { string pid = new SnsPassport().GetRegPassport(); SnsCenterUser snsCenterUser = new SnsCenterUser(pid, password, string.Empty); if (snsCenterUser.InsertSnsUser(paramNames, paramValues) > 0) { return(pid); } else { return(string.Empty); } }
/// <summary> /// 获取通行证 /// </summary> /// <param name="imei">if null then get new pid</param> /// <returns></returns> public static string[] GetRegPassport(string imei) { if (!SnsCenterUser.CheckDevice(imei)) throw (new Exception("禁止登入")); var list = new List<string>(); SnsCenterUser user = SnsCenterUser.GetUserByDeviceId(imei); string passportId = string.Empty; if (user != null) { passportId = user.PassportId; list.Add(passportId); list.Add(user.Password); } else { SnsPassport passport = new SnsPassport(); PassportExpired passportExpired; if (!imeiMap.TryGetValue(imei, out passportExpired)) { passportId = passport.GetRegPassport(); imeiMap[imei] = new PassportExpired(passportId); } else { passportId = passportExpired.Pid; if (passportExpired.ExpiredTime < DateTime.Now) { //过期移除 imeiMap.TryRemove(imei, out passportExpired); } //检查超出 List<string> expiredMap; if (imeiMap.Count > 100 && ((expiredMap = imeiMap.Where(t => t.Value.ExpiredTime < DateTime.Now).Select(t => t.Key).ToList()).Count > 10)) { foreach (var expired in expiredMap) { imeiMap.TryRemove(expired, out passportExpired); } } } string password = passport.GetRandomPwd(); list.Add(passportId); list.Add(password); } return list.ToArray(); }
/// <summary> /// 获取通行证 /// </summary> /// <param name="imei">if null then get new pid</param> /// <param name="isNew"></param> /// <param name="encodeFunc"></param> /// <returns></returns> public static string[] GetRegPassport(string imei, bool isNew = false, Func<string, string> encodeFunc = null) { if (!SnsCenterUser.CheckDevice(imei)) throw (new Exception("禁止登入")); var list = new List<string>(); SnsUser user = new SnsCenterUser().GetUserByDeviceId(imei); string passportId = string.Empty; if (!isNew && user.UserId > 0) { passportId = user.PassportId; if (user.RegType == RegType.Guest) { //客户端换包重新获取游客账号,密码需要重置 string password = GetRandomPassword(); user.Password = encodeFunc != null ? encodeFunc(password) : password; var sns = new SnsCenterUser(user.PassportId, password, imei); sns.ChangePassword(user.UserId.ToString(), true); } else { if (encodeFunc != null) user.Password = encodeFunc(user.Password); } list.Add(passportId); list.Add(user.Password); } else { PassportExpired passportExpired; if (isNew || !imeiMap.TryGetValue(imei, out passportExpired)) { passportId = new SnsPassport().GetRegPassport(); if (!string.IsNullOrEmpty(imei)) imeiMap[imei] = new PassportExpired(passportId); } else { passportId = passportExpired.PassportId; if (passportExpired.ExpiredTime < DateTime.Now) { //过期移除 imeiMap.TryRemove(imei, out passportExpired); } //检查超出 List<string> expiredMap; if (imeiMap.Count > 100 && ((expiredMap = imeiMap.Where(t => t.Value.ExpiredTime < DateTime.Now).Select(t => t.Key).ToList()).Count > 10)) { foreach (var expired in expiredMap) { imeiMap.TryRemove(expired, out passportExpired); } } } string password = GetRandomPassword(); if (encodeFunc != null) password = encodeFunc(password); list.Add(passportId); list.Add(password); } return list.ToArray(); }
/// <summary> /// 获取通行证 /// </summary> /// <param name="deviceID"></param> /// <returns></returns> public static string[] GetRegPassport(string deviceID) { if (!SnsCenterUser.CheckDevice(deviceID)) throw (new Exception("禁止登入")); List<string> list = new List<string>(); SnsCenterUser user = SnsCenterUser.GetUserByDeviceID(deviceID); if (user != null) { list.Add(user.PassportId); list.Add(user.Password); } else { SnsPassport passport = new SnsPassport(); string password = passport.GetRandomPwd(); list.Add(passport.GetRegPassport()); list.Add(CryptoHelper.DES_Encrypt(password, GameEnvironment.Setting.ProductDesEnKey)); } return list.ToArray(); }
public bool IsExistRetail() { string sGetSql = "select top 1 userid from SnsUserInfo where RetailID=@RetailID and RetailUser=@RetailUser"; List <SqlParameter> listTmp = new List <SqlParameter>(); listTmp.Add(SqlParamHelper.MakeInParam("@RetailID", SqlDbType.VarChar, 0, RetailID)); listTmp.Add(SqlParamHelper.MakeInParam("@RetailUser", SqlDbType.VarChar, 0, RetailUser)); SqlParameter[] paramsGet = listTmp.ToArray(); using (SqlDataReader aReader = SqlHelper.ExecuteReader(config.connectionString, CommandType.Text, sGetSql, paramsGet)) { if (aReader.Read()) { return(true); } } //自动获取通行证 SnsPassport passport = new SnsPassport(); this._PassportId = passport.GetRegPassport(); this._PassportPwd = CryptoHelper.DES_Encrypt(passport.GetRandomPwd(), GameEnvironment.ProductDesEnKey); return(false); }
/// <summary> /// 获取通行证 /// </summary> /// <param name="imei">if null then get new pid</param> /// <returns></returns> public static string[] GetRegPassport(string imei) { if (!SnsCenterUser.CheckDevice(imei)) { throw (new Exception("禁止登入")); } var list = new List <string>(); SnsCenterUser user = SnsCenterUser.GetUserByDeviceId(imei); if (user != null) { list.Add(user.PassportId); list.Add(user.Password); } else { SnsPassport passport = new SnsPassport(); string password = passport.GetRandomPwd(); list.Add(passport.GetRegPassport()); list.Add(password); } return(list.ToArray()); }
/// <summary> /// 获取通行证 /// </summary> /// <param name="deviceID"></param> /// <returns></returns> public static string[] GetRegPassport(string deviceID) { if (!SnsCenterUser.CheckDevice(deviceID)) { throw (new Exception("禁止登入")); } List <string> list = new List <string>(); SnsCenterUser user = SnsCenterUser.GetUserByDeviceID(deviceID); if (user != null) { list.Add(user.PassportId); list.Add(user.Password); } else { SnsPassport passport = new SnsPassport(); string password = passport.GetRandomPwd(); list.Add(passport.GetRegPassport()); list.Add(CryptoHelper.DES_Encrypt(password, GameEnvironment.ProductDesEnKey)); } return(list.ToArray()); }
/// <summary> /// 注册 /// </summary> /// <param name="password"></param> /// <param name="imei"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns>pid</returns> public static string RegisterPassport(string password, string imei, string[] paramNames = null, string[] paramValues = null) { int userType; string pid = new SnsPassport().GetRegPassport(); DoRegisterPassport(pid, password, imei, paramNames, paramValues, out userType, false); return pid; }
/// <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="retailId"></param> /// <param name="retailUser"></param> /// <returns></returns> public static string[] LoginByRetail(string retailId, string retailUser) { string[] result = new string[2]; SnsCenterUser snsCenterUser = new SnsCenterUser(); var snsuser = snsCenterUser.GetUserInfo(retailId, retailUser); if (snsuser.UserId <= 0) { //自动获取通行证 SnsPassport passport = new SnsPassport(); string pid = passport.GetRegPassport(); string pwd = passport.GetRandomPwd(); //modify login of retail bug. snsCenterUser = new SnsCenterUser(pid, pwd, string.Empty) { RetailID = retailId, RetailUser = retailUser }; result[0] = snsCenterUser.InsertSnsUser().ToString(); result[1] = pid; return result; } result[0] = snsuser.UserId.ToString(); result[1] = snsuser.PassportId; return result; }
/// <summary> /// 注册 /// </summary> /// <param name="password"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns>pid</returns> public static string RegisterPassport(string password, string[] paramNames = null, string[] paramValues = null) { string pid = new SnsPassport().GetRegPassport(); DoRegisterPassport(pid, password, paramNames, paramValues); return pid; }
/// <summary> /// Determines whether this instance is exist retail. /// </summary> /// <returns><c>true</c> if this instance is exist retail; otherwise, <c>false</c>.</returns> public bool IsExistRetail() { var command = ConnectManager.Provider.CreateCommandStruct("SnsUserInfo", CommandMode.Inquiry); command.Columns = "userid"; command.OrderBy = "USERID ASC"; command.Filter = ConnectManager.Provider.CreateCommandFilter(); command.Filter.Condition = string.Format("{0} AND {1}", command.Filter.FormatExpression("RetailID"), command.Filter.FormatExpression("RetailUser") ); command.Filter.AddParam("RetailID", RetailID); command.Filter.AddParam("RetailUser", RetailUser); command.Parser(); using (var aReader = ConnectManager.Provider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters)) { if (aReader.Read()) { return true; } } //自动获取通行证 SnsPassport passport = new SnsPassport(); this._PassportId = passport.GetRegPassport(); this._PassportPwd = CryptoHelper.DES_Encrypt(passport.GetRandomPwd(), GameEnvironment.ProductDesEnKey); return false; }
/// <summary> /// 通行证检查 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool CheckPassport(string user) { SnsPassport passport = new SnsPassport(); return(passport.VerifyRegPassportId(user)); }
/// <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="password"></param> /// <param name="paramNames"></param> /// <param name="paramValues"></param> /// <returns></returns> public static string RegisterPassport(string password, string[] paramNames, string[] paramValues) { string pid = new SnsPassport().GetRegPassport(); SnsCenterUser snsCenterUser = new SnsCenterUser(pid, password, string.Empty); if (snsCenterUser.InsertSnsUser(paramNames, paramValues) > 0) { return pid; } else { return string.Empty; } }
/// <summary> /// 获取通行证 /// </summary> /// <param name="imei">if null then get new pid</param> /// <param name="isNew"></param> /// <param name="encodeFunc"></param> /// <returns></returns> public static string[] GetRegPassport(string imei, bool isNew = false, Func <string, string> encodeFunc = null) { if (!SnsCenterUser.CheckDevice(imei)) { throw (new Exception("禁止登入")); } var list = new List <string>(); SnsUser user = new SnsCenterUser().GetUserByDeviceId(imei); string passportId = string.Empty; if (!isNew && user.UserId > 0) { passportId = user.PassportId; if (user.RegType == RegType.Guest) { //客户端换包重新获取游客账号,密码需要重置 string password = GetRandomPwd(); user.Password = encodeFunc != null?encodeFunc(password) : password; var sns = new SnsCenterUser(user.PassportId, password, imei); sns.ChangePass(user.UserId.ToString(), true); } else { if (encodeFunc != null) { user.Password = encodeFunc(user.Password); } } list.Add(passportId); list.Add(user.Password); } else { PassportExpired passportExpired; if (isNew || !imeiMap.TryGetValue(imei, out passportExpired)) { passportId = new SnsPassport().GetRegPassport(); if (!string.IsNullOrEmpty(imei)) { imeiMap[imei] = new PassportExpired(passportId); } } else { passportId = passportExpired.Pid; if (passportExpired.ExpiredTime < DateTime.Now) { //过期移除 imeiMap.TryRemove(imei, out passportExpired); } //检查超出 List <string> expiredMap; if (imeiMap.Count > 100 && ((expiredMap = imeiMap.Where(t => t.Value.ExpiredTime < DateTime.Now).Select(t => t.Key).ToList()).Count > 10)) { foreach (var expired in expiredMap) { imeiMap.TryRemove(expired, out passportExpired); } } } string password = GetRandomPwd(); if (encodeFunc != null) { password = encodeFunc(password); } list.Add(passportId); list.Add(password); } return(list.ToArray()); }
public bool IsExistRetail() { string sGetSql = "select top 1 userid from SnsUserInfo where RetailID=@RetailID and RetailUser=@RetailUser"; List<SqlParameter> listTmp = new List<SqlParameter>(); listTmp.Add(SqlParamHelper.MakeInParam("@RetailID", SqlDbType.VarChar, 0, RetailID)); listTmp.Add(SqlParamHelper.MakeInParam("@RetailUser", SqlDbType.VarChar, 0, RetailUser)); SqlParameter[] paramsGet = listTmp.ToArray(); using (SqlDataReader aReader = SqlHelper.ExecuteReader(config.connectionString, CommandType.Text, sGetSql, paramsGet)) { if (aReader.Read()) { return true; } } //自动获取通行证 SnsPassport passport = new SnsPassport(); this._PassportId = passport.GetRegPassport(); this._PassportPwd = CryptoHelper.DES_Encrypt(passport.GetRandomPwd(), GameEnvironment.ProductDesEnKey); return false; }
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; } }