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