public static List <BaseStatus> QueryBaseStatus(QueryCondition queryCondition)
{
string sql = @"
SELECT A.ID AS ID,A.STATUS_ID AS StatusId,A.STATUS_NAME AS StatusName,A.GROUP_NAME AS GroupName,A.CREATED_ON AS CreatedOn,A.CREATED_BY AS CreatedBy
FROM T_BASE_STATUS AS A WITH(NOLOCK)
WHERE 1=1
";
var dict = new Dictionary <QueryConditionField, string>
{
//{QueryConditionField.Workshop, " AND WORKSHOP = "},
};
var builder = new QueryConditionBuilder(queryCondition, dict);
sql += builder.Build();
//sql += " ORDER BY RECORD_STATUS DESC,MODIFIED_ON DESC ";
return(Dapper.Query <BaseStatus>(sql, queryCondition));
}
public static List<BaseStatus> QueryBaseStatus(QueryCondition queryCondition)
{
string sql = @"
SELECT A.ID AS ID,A.STATUS_ID AS StatusId,A.STATUS_NAME AS StatusName,A.GROUP_NAME AS GroupName,A.CREATED_ON AS CreatedOn,A.CREATED_BY AS CreatedBy
FROM T_BASE_STATUS AS A WITH(NOLOCK)
WHERE 1=1
";
var dict = new Dictionary<QueryConditionField, string>
{
//{QueryConditionField.Workshop, " AND WORKSHOP = "},
};
var builder = new QueryConditionBuilder(queryCondition, dict);
sql += builder.Build();
//sql += " ORDER BY RECORD_STATUS DESC,MODIFIED_ON DESC ";
return Dapper.Query<BaseStatus>(sql, queryCondition);
}