public static OrderFile GetFirstOrDefault(OrderFileParam param) { var sql = Sql.Builder .Where("IDOrder =@0", param.IDOrder); if (!param.Types.IsNullOrEmpty()) { sql.Where("Type in (@0)", param.Types); } return(UseInstance.GetFirstByFieldOrdefault(sql)); }
public static List <OrderFile> Search(OrderFileParam param, Pagination paging) { var sql = Sql.Builder .Where("IDOrder =@0", param.IDOrder); if (!param.Types.IsNullOrEmpty()) { sql.Where("Type in (@0)", param.Types); } return(UseInstance.GetListOrDefault(sql, paging)); }