/// <summary>
/// 得到所有交易场ID
/// </summary>
/// <param name="plat3"></param>
/// <returns></returns>
public List <string> findAllExchange(List <string> plat3)
{
if (plat3.Count == 0)
{
return(null);
}
string sql = "select id from plt_plat where plat_father = ";
foreach (string subPlatId in plat3)
{
sql += "'" + subPlatId + "'" + " union";
}
sql = sql.Substring(0, sql.Length - 5);
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql, new MapRow <string>(MapPlatId));
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// 根绝角色ID查询平台ID
/// </summary>
/// <param name="roleList"></param>
/// <returns></returns>
public List <string> findPlatsByRoleId(List <string> roleList)
{
if (roleList.Count == 0)
{
return(null);
}
string sql = "select plat_id as ID from usr_role_plat where role_id = ";
foreach (string subRoleId in roleList)
{
sql += "'" + subRoleId + "'" + " union";
}
sql = sql.Substring(0, sql.Length - 5);
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql, new MapRow <string>(MapPlatId));
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// 根据UserId和平台ID查询角色ID
/// </summary>
/// <param name="userId"></param>
/// <param name="platId"></param>
/// <returns></returns>
public List <string> findRolesByUserIdAndPlatId(string userId, string platId)
{
string sql = "select usr_user_role.role_id as ID from usr_user_role , usr_role_plat where usr_user_role.user_id = :user_id and usr_role_plat.plat_id = :plat_id and usr_user_role.role_id = usr_role_plat.role_id ";
List <DbParameter> parameters = new List <DbParameter>();
DbParameter param = this.DbFacade.CreateParameter();
param.ParameterName = "user_id";
param.DbType = DbType.String;
param.Value = userId;
parameters.Add(param);
param = this.DbFacade.CreateParameter();
param.ParameterName = "plat_id";
param.DbType = DbType.String;
param.Value = platId;
parameters.Add(param);
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql, new MapRow <string>(MapPlatId), parameters.ToArray());
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// 根据HandlerId和Operate查询角色ID列表
/// </summary>
/// <param name="operate"></param>
/// <param name="handlerId"></param>
/// <param name="flag"></param>
/// <returns></returns>
public List <string> findRoleListByHandlerIdAndOperate(string operate, string handlerId, bool flag)
{
StringBuilder sql = new StringBuilder();
sql.Append("select distinct usr_role_function.role_id as ID ");
sql.Append("from usr_role_function , usr_function , usr_action , usr_module ");
sql.Append("where usr_module.url like :handlerId ");
if (!flag)
{
sql.Append("and usr_action.action_code = :operate ");
}
sql.Append("and usr_function.module_id = usr_module.id ");
sql.Append("and usr_function.action_id = usr_action.id ");
sql.Append("and usr_function.parent_id = usr_role_function.parent_id ");
List <DbParameter> parameters = new List <DbParameter>();
DbParameter param = this.DbFacade.CreateParameter();
param.ParameterName = "handlerId";
param.DbType = DbType.String;
param.Value = handlerId + "%";
parameters.Add(param);
if (!flag)
{
param = this.DbFacade.CreateParameter();
param.ParameterName = "operate";
param.DbType = DbType.String;
param.Value = operate;
parameters.Add(param);
}
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql.ToString(), new MapRow <string>(MapPlatId), parameters.ToArray());
}
catch (Exception e)
{
throw e;
}
return(result);
}
public List <string> findPlatsByUserId(string userId)
{
string sql = "select plat_id as id from usr_usr_plat where user_id = :ID";
DbParameter idPara = DbFacade.CreateParameter();
idPara.ParameterName = "ID";
idPara.DbType = DbType.String;
idPara.Value = userId;
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql, new MapRow <string>(MapPlatId), idPara);
}
catch (Exception e)
{
throw e;
}
return(result);
}
public List <string> findSubPlatId(string platFatherId)
{
string sql = "select id from plt_plat where plat_father = :ID";
DbParameter idPara = DbFacade.CreateParameter();
idPara.ParameterName = "ID";
idPara.DbType = DbType.String;
idPara.Value = platFatherId;
List <string> result = null;
try
{
result = (List <string>)DbFacade.SQLExecuteList <string>(sql, new MapRow <string>(MapPlatId), idPara);
}
catch (Exception e)
{
throw e;
}
return(result);
}