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