/// <summary>
/// 根据roleType查出List<SecRoleEntity>, Add by Alex on 2010.3.20
/// </summary>
/// <param name="roleType"></param>
/// <returns></returns>
public static List <SecRoleEntity> GetRoleEntityByRoleType(string roleType)
{
List <SecRoleEntity> roleEntityList = new List <SecRoleEntity>();
string sql = "select * from " + SecRoleTable.C_TableName;
WhereBuilder wb = new WhereBuilder(sql);
wb.FixFirstCondition = true;
wb.AddAndCondition("1", "1");
//根据RoleName来排序
string sqlExtends = " order by " + SecRoleTable.C_TableName + "." + SecRoleTable.C_ROLE_NAME;
wb.AddCondition(sqlExtends);
roleEntityList = DataAccess.Select <SecRoleEntity>(wb);
return(roleEntityList);
}
//public JqGrid grid;
public WhereBuilder ParseSQL()
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select T1.* from " + SecPageTable.C_TableName + " T1 ");
WhereBuilder wb = new WhereBuilder(strsql.ToString());
//if (!string.IsNullOrEmpty(keyWord))
//{
// wb.AddORCondition(SecPageTable.C_PAGE_NAME, "like", "%" + keyWord + "%");
// wb.AddORCondition(SecPageTable.C_PAGE_NAME_EN, "like", "%" + keyWord + "%");
//}
if (!string.IsNullOrEmpty(systemName))
{
wb.AddAndCondition(SecPageTable.C_SYSTEM_NAME, systemName);
}
return(wb);
}
public WhereBuilder ParseSQL()
{
StringBuilder strsql = new StringBuilder();
strsql.Append("SELECT T1.*,T2.CONTRACT_TYPE_NAME FROM CAS_CONTRACT_APPROVAL_STEP T1 ");
strsql.Append(" INNER JOIN CAS_CONTRACT_TYPE T2 ");
strsql.Append(" ON T1.CONTRACT_TYPE_ID = T2.CONTRACT_TYPE_ID ");
WhereBuilder wb = new WhereBuilder(strsql.ToString());
if (!string.IsNullOrEmpty(keyWord))
{
wb.AddAndCondition("CONTRACT_TYPE_NAME", "=", keyWord);
}
//if (!string.IsNullOrEmpty(keyWord))
//{
// strsql.AppendLine($@" AND T2.CONTRACT_TYPE_NAME LIKE N'%{keyWord}%'");
//}
return(wb);
}
