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;
}
}
