public void wkfproGetNextTask(DbTransaction tran, int userId, string sessionID, out string entityType, out int entityId, out string functionType, out int lockId, out DateTime lockAcquired, out DateTime lockExpired)
{
string spName = "";
try
{
spName = "wkfproGetNextTask";
DbCommand dbCommand = base.DB.GetStoredProcCommand(spName);
dbCommand.Parameters.Clear();
base.DB.AddInParameter(dbCommand, "@UserId", DbType.Int64, userId);
base.DB.AddInParameter(dbCommand, "@SessionId", DbType.String, sessionID);
base.DB.AddOutParameter(dbCommand, "@EntityType", DbType.String, 1);
base.DB.AddOutParameter(dbCommand, "@EntityId", DbType.Int64, 0);
base.DB.AddOutParameter(dbCommand, "@FunctionType", DbType.String, 1);
base.DB.AddOutParameter(dbCommand, "@LockId", DbType.Int64, 0);
base.DB.AddOutParameter(dbCommand, "@LockAcquiredDateTime", DbType.DateTime, 0);
base.DB.AddOutParameter(dbCommand, "@LockTimeoutDateTime", DbType.DateTime, 0);
if (tran != null)
{
base.DB.ExecuteNonQuery(dbCommand, tran);
}
else
{
base.DB.ExecuteNonQuery(dbCommand);
}
entityType = DataReaderHelper.GetString(base.DB.GetParameterValue(dbCommand, "@EntityType"));
entityId = DataReaderHelper.GetInt(base.DB.GetParameterValue(dbCommand, "@EntityId"));
functionType = DataReaderHelper.GetString(base.DB.GetParameterValue(dbCommand, "@FunctionType"));
lockId = DataReaderHelper.GetInt(base.DB.GetParameterValue(dbCommand, "@LockId"));
lockAcquired = DataReaderHelper.GetDateTime(base.DB.GetParameterValue(dbCommand, "@LockAcquiredDateTime"));
lockExpired = DataReaderHelper.GetDateTime(base.DB.GetParameterValue(dbCommand, "@LockTimeoutDateTime"));
}
catch (SqlException ex)
{
throw new DacSqlException(ex);
}
catch (Exception ex)
{
throw ex;
}
finally
{
base.ReleaseConnection();
}
}
public void fralokLockSteal(DbTransaction tran, int entityId, string entityType, string lockContext, string lockTimeoutType, int userId, string sessionId, int functionTypeId, out int lockId, out DateTime lockAcquired, out DateTime lockTimeout)
{
string spName = "";
try
{
spName = "fralokLockSteal";
DbCommand dbCommand = base.DB.GetStoredProcCommand(spName);
dbCommand.Parameters.Clear();
base.DB.AddInParameter(dbCommand, "@ObjectId", DbType.Int32, entityId);
base.DB.AddInParameter(dbCommand, "@ObjectType", DbType.String, entityType);
base.DB.AddInParameter(dbCommand, "@LockContext", DbType.String, lockContext);
base.DB.AddInParameter(dbCommand, "@LockTimeOutType", DbType.String, lockTimeoutType);
base.DB.AddInParameter(dbCommand, "@UserId", DbType.Int32, userId);
base.DB.AddInParameter(dbCommand, "@SessionId", DbType.String, sessionId);
base.DB.AddInParameter(dbCommand, "@FunctionTypeId", DbType.Int32, functionTypeId);
base.DB.AddOutParameter(dbCommand, "@LockId", DbType.Int32, 0);
base.DB.AddOutParameter(dbCommand, "@LockAcquiredDateTime", DbType.DateTime, 0);
base.DB.AddOutParameter(dbCommand, "@LockTimeoutDateTime", DbType.DateTime, 0);
if (tran != null)
{
base.DB.ExecuteNonQuery(dbCommand, tran);
}
else
{
base.DB.ExecuteNonQuery(dbCommand);
}
lockId = DataReaderHelper.GetInt(base.DB.GetParameterValue(dbCommand, "@LockId"));
lockAcquired = DataReaderHelper.GetDateTime(base.DB.GetParameterValue(dbCommand, "@LockAcquiredDateTime"));
lockTimeout = DataReaderHelper.GetDateTime(base.DB.GetParameterValue(dbCommand, "@LockTimeoutDateTime"));
}
catch (SqlException ex)
{
throw new DacSqlException(ex);
}
catch (Exception ex)
{
throw ex;
}
finally
{
base.ReleaseConnection();
}
}
public User GetUsers(string userName, string passWord)
{
User _user = null;
string sqlCommand = "select * from User where Deleted=0 and LoginID=" + userName + " and Password="******"PhoneNumber");
_user.Password = DataReaderHelper.GetString(dr, "Password");
_user.LoginID = DataReaderHelper.GetString(dr, "LoginID");
_user.UserType = DataReaderHelper.GetInt16(dr, "UserType");
_user.Name = DataReaderHelper.GetString(dr, "Name");
_user.Deleted = DataReaderHelper.GetBoolean(dr, "Deleted");
_user.Notification = DataReaderHelper.GetBoolean(dr, "Notification");
_user.NotificationSound = DataReaderHelper.GetBoolean(dr, "NotificationSound");
_user.NotificationVibration = DataReaderHelper.GetBoolean(dr, "NotificationVibration");
_user.CreateTime = DataReaderHelper.GetDateTime(dr, "CreateTime");
_user.UpdateTime = DataReaderHelper.GetDateTime(dr, "UpdateTime");
}
return(_user);
}
